BITM 215 (2) QUESTIONS & ANSWERS
You used the Subtotal feature on a dataset containing states, major cities within each
state, and populations. You intended to create one subtotal for each state; however, a
subtotal row displays below each city. What caused this result? - Answer -The At a
change setting was City within the subtotal dialog box
Why would you click the collapse outline symbol above a column of outlined data? -
Answer -You want to hide the detailed columns to focus on the result column
After creating a blank PivotTable, you click a check box for a field that contains
categorical data, such as state names, in the PivotTable Fields task pane. Where does
Excel place that field? - Answer -Rows area.
You created a PivotTable that shows total number of customers per day; however, you
want to display the average number of customers per day. What would you do to
change the PivotTable results? - Answer -Select the Average calculation as a value
field setting.
You create a PivotTable and changed some values in the dataset from which the
PivotTable was created. How does this affect the PivotTable? - Answer -Changes in
the dataset do not affect the PivotTable until you refresh the PivotTable.
You created a PivotTables for a major department store that lists department names
(Shoes) in the first column and total weekly sales in the second column. How can you
exclude Sunday sales from being reflected in the second column? - Answer -Set filter
for the Weekday field and deselect the Sunday check box in the filter menu.
Which of the following is NOT used when creating a calculated field in a PivotTable? -
Answer -A cell reference to a value outside of the PivotTable.
What settings should you select to apply a different color scheme and display a fill color
for every other row or horizontal lines within the PivotTable? - Answer -Banded Rows
check box and a different PivotTable style.
You want to create a PivotTable that uses fields from two Excel Tables. What is the first
step? - Answer -Create a relationship on a common field between the two tables.
When you create a clustered column PivotChart from a PivotTable, the field that was in
the Rows area of the PivotTable Fields task pane create what part of the PivotChart? -
Answer -Categoy Axis
Which what-if analysis tool is the best option for complex calculations requiring
constrained optimization? - Answer -Solver
You used the Subtotal feature on a dataset containing states, major cities within each
state, and populations. You intended to create one subtotal for each state; however, a
subtotal row displays below each city. What caused this result? - Answer -The At a
change setting was City within the subtotal dialog box
Why would you click the collapse outline symbol above a column of outlined data? -
Answer -You want to hide the detailed columns to focus on the result column
After creating a blank PivotTable, you click a check box for a field that contains
categorical data, such as state names, in the PivotTable Fields task pane. Where does
Excel place that field? - Answer -Rows area.
You created a PivotTable that shows total number of customers per day; however, you
want to display the average number of customers per day. What would you do to
change the PivotTable results? - Answer -Select the Average calculation as a value
field setting.
You create a PivotTable and changed some values in the dataset from which the
PivotTable was created. How does this affect the PivotTable? - Answer -Changes in
the dataset do not affect the PivotTable until you refresh the PivotTable.
You created a PivotTables for a major department store that lists department names
(Shoes) in the first column and total weekly sales in the second column. How can you
exclude Sunday sales from being reflected in the second column? - Answer -Set filter
for the Weekday field and deselect the Sunday check box in the filter menu.
Which of the following is NOT used when creating a calculated field in a PivotTable? -
Answer -A cell reference to a value outside of the PivotTable.
What settings should you select to apply a different color scheme and display a fill color
for every other row or horizontal lines within the PivotTable? - Answer -Banded Rows
check box and a different PivotTable style.
You want to create a PivotTable that uses fields from two Excel Tables. What is the first
step? - Answer -Create a relationship on a common field between the two tables.
When you create a clustered column PivotChart from a PivotTable, the field that was in
the Rows area of the PivotTable Fields task pane create what part of the PivotChart? -
Answer -Categoy Axis
Which what-if analysis tool is the best option for complex calculations requiring
constrained optimization? - Answer -Solver
