Exam (elaborations)
BITM 215 COMPREHENSIVE QUESTIONS AND VERIFIED CORRECT ANSWERS 2024 UPDATE
- Course
- Institution
BITM 215 COMPREHENSIVE QUESTIONS AND VERIFIED CORRECT ANSWERS 2024 UPDATE
[Show more]
1 review
By: TheAlphanurse • 4 months ago
Great doc!!
Seller
Follow
MEGAMINDS
Reviews received
Content preview
BITM 215 COMPREHENSIVE QUESTIONS AND VERIFIEDCORRECT ANSWERS 2024 UPDATE
What settings should you select for a PivotTable if you want to apply a different
color scheme and display different fill colors for main category rows and
horizontal lines within the PivotTable?
(a) Banded Rows and Banded Columns check boxes
(b) Banded Columns check box and a different PivotTable style
(c) Banded Rows check box and a different PivotTable style
(d) A different PivotTable style only
(c) Banded Rows check box and a different PivotTable style
Why would you create a slicer for a PivotTable?
(a) To filter data in a PivotTable
(b) To sort data in a PivotTable
(c) To slice data into a timeline
(d) To create a color-coded slice for each category
(a) To filter data in a PivotTable
Which of the following is not used when creating a calculated field in a
PivotTable?
(a) Operands, such as multiplication (*)
(b) Name of a field containing values
(c) Another value to be used in a calculation
(d) A cell reference to a value outside of the PivotTable
(d) A cell reference to a value outside of the PivotTable
You created a PivotChart showing sales by quarter by sales rep. How do you
remove a sales rep from the chart without deleting the data?
(a) Make the employee's data points and axis titles invisible
(b) You cannot delete the rep from the chart without first deleting the data
(c) Filter the Sales Rep field in the PivotChart and deselect the employee's check
box
(d) Hide that rep's row(s) in the underlying list, which automatically removes that
rep from the chart
(c) Filter the Sales Rep field in the PivotChart and deselect the employee's check box
You want to create a PivotTable that uses fields from two Excel tables. What is
the first step?
(a) Create a relationship on a common field between the two tables
(b) Create a PivotTable using one table and then add the second table to the
PivotTable Fields task pane
(c) Merge the two tables into one large dataset before creating the PivotTable
, (d) Create a subtotal for each table, copy and paste the two subtotals together,
and then create the PivotTable
(b) Create a PivotTable using one table and then add the second table to the PivotTable
Fields task pane
Which what-if analysis tool is the best option for complex calculations requiring
constrained optimization?
(a) Goal Seek
(b) Scenario Manager
(c) Data Tables
(d) Solver
(d) Solver
What tool is used to view existing range names?
(a) Name Box
(b) Scenario Manager
(c) Name Manager
(d) Solver
(c) Name Manager
Which tool is most effective when comparing the impact of various combinations
of production expenses and new customer acquisition on net sales profit?
(a) Goal Seek
(b) Solver
(c) Two-variable data table
(d) Scenario Manager
(d) Scenario Manager
This tool calculates the value required in a single cell to produce a desired result
within a related cell.
(a) Goal Seek
(b) Solver
(c) One- or two-variable data table
(d) Scenario Manager
(c) One- or two-variable data table
You want to apply a subtotal to a dataset containing names, departments, and
salaries. What is the first step you need to do?
(a) Filter the dataset by salaries
(b) Select the function to be used for the subtotal
(c) Insert new rows where you want the subtotal rows within the dataset
(d) Sort the data by a field containing categories
(d): sort the data by a field containing categories
Why would you click the collapse outline symbol above a column of outlined
data?
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller MEGAMINDS. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
83662 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now