BITM 215 Exam #2 Multiple Choice
Question and answers verified to pass
2025/2026
You want to apply a subtotal to a dataset containing names, departments, and salaries. What is the first
step you need to do? - correct answer ✔(d): sort the data by a field containing categories
Why would you click the collapse outline symbol above a column of outlined data? - correct answer
✔(b): You want to hide the detailed columns to focus on the result column
After creating a blank PivotTable, you click a field containing monetary amounts in the PivotTable Fields
task pane. Where does Excel place this field? - correct answer ✔(c): Values area
What is the default summary statistic for any value field added to a PivotTable? - correct answer ✔(d):
Sum
You created a PivotTable and made some changes to values in the original dataset from which the
PivotTable was created. How does this affect the PivotTable? - correct answer ✔(b) Changes in the
dataset do not affect the PivotTable until you refresh the PivotTable
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? - correct
answer ✔(c) Banded Rows check box and a different PivotTable style
Why would you create a slicer for a PivotTable? - correct answer ✔(a) To filter data in a PivotTable
Which of the following is not used when creating a calculated field in a PivotTable? - correct answer
✔(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? - correct answer ✔(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? - correct
answer ✔(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? - correct answer ✔(d) Solver
What tool is used to view existing range names? - correct answer ✔(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? - correct answer ✔(d) Scenario Manager
This tool calculates the value required in a single cell to produce a desired result within a related cell. -
correct answer ✔Goal Seek
This analysis tool can handle multiple adjustable cells while minimizing, maximizing, or meeting goals. -
correct answer ✔(a) Goal Seek
Which of the following is an Excel add-in? - correct answer ✔(b) Solver
Which of the following is not an acceptable range name? - correct answer ✔(c) 2021_Rate
What is the keyboard shortcut to open the Paste Name dialogue box? - correct answer ✔(b) F3
Which of the following tools can incorporate constraints? - correct answer ✔(b) Solver
Question and answers verified to pass
2025/2026
You want to apply a subtotal to a dataset containing names, departments, and salaries. What is the first
step you need to do? - correct answer ✔(d): sort the data by a field containing categories
Why would you click the collapse outline symbol above a column of outlined data? - correct answer
✔(b): You want to hide the detailed columns to focus on the result column
After creating a blank PivotTable, you click a field containing monetary amounts in the PivotTable Fields
task pane. Where does Excel place this field? - correct answer ✔(c): Values area
What is the default summary statistic for any value field added to a PivotTable? - correct answer ✔(d):
Sum
You created a PivotTable and made some changes to values in the original dataset from which the
PivotTable was created. How does this affect the PivotTable? - correct answer ✔(b) Changes in the
dataset do not affect the PivotTable until you refresh the PivotTable
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? - correct
answer ✔(c) Banded Rows check box and a different PivotTable style
Why would you create a slicer for a PivotTable? - correct answer ✔(a) To filter data in a PivotTable
Which of the following is not used when creating a calculated field in a PivotTable? - correct answer
✔(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? - correct answer ✔(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? - correct
answer ✔(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? - correct answer ✔(d) Solver
What tool is used to view existing range names? - correct answer ✔(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? - correct answer ✔(d) Scenario Manager
This tool calculates the value required in a single cell to produce a desired result within a related cell. -
correct answer ✔Goal Seek
This analysis tool can handle multiple adjustable cells while minimizing, maximizing, or meeting goals. -
correct answer ✔(a) Goal Seek
Which of the following is an Excel add-in? - correct answer ✔(b) Solver
Which of the following is not an acceptable range name? - correct answer ✔(c) 2021_Rate
What is the keyboard shortcut to open the Paste Name dialogue box? - correct answer ✔(b) F3
Which of the following tools can incorporate constraints? - correct answer ✔(b) Solver
