BITM 215 EXAM #2 QUESTIONS & ANSWERS
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 - Answer -(d): sort the data by a field
containing categories
Why would you click the collapse outline symbol above a column of outlined data?
(a) You want to see more detailed columns that relate to the formula in that column
(b) You want to hide the detailed columns to focus on the result column
(c) You want to insert a subtotal row for a set of rows
(d) You want to delete columns containing values - 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?
(a) Filters area
(b) Columns area
(c) Values area
(d) Rows area - Answer -(c): Values area
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 - Answer -(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 - 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?
, (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 - 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?
(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 - 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?
(a) Goal Seek
(b) Scenario Manager
(c) Data Tables
(d) Solver - Answer -(d) Solver
What tool is used to view existing range names?
(a) Name Box
(b) Scenario Manager
(c) Name Manager
(d) Solver - Answer -(c) Name Manager
What is the default summary statistic for any value field added to a PivotTable?
(a) Average
(b) Count
(c) Min
(d) Sum - 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?
(a) The PivotTable is updated automatically when you make changes to the dataset
(b) Changes in the dataset do not affect the PivotTable until you refresh the PivotTable
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 - Answer -(d): sort the data by a field
containing categories
Why would you click the collapse outline symbol above a column of outlined data?
(a) You want to see more detailed columns that relate to the formula in that column
(b) You want to hide the detailed columns to focus on the result column
(c) You want to insert a subtotal row for a set of rows
(d) You want to delete columns containing values - 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?
(a) Filters area
(b) Columns area
(c) Values area
(d) Rows area - Answer -(c): Values area
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 - Answer -(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 - 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?
, (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 - 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?
(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 - 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?
(a) Goal Seek
(b) Scenario Manager
(c) Data Tables
(d) Solver - Answer -(d) Solver
What tool is used to view existing range names?
(a) Name Box
(b) Scenario Manager
(c) Name Manager
(d) Solver - Answer -(c) Name Manager
What is the default summary statistic for any value field added to a PivotTable?
(a) Average
(b) Count
(c) Min
(d) Sum - 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?
(a) The PivotTable is updated automatically when you make changes to the dataset
(b) Changes in the dataset do not affect the PivotTable until you refresh the PivotTable
