BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+
GRADED
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?
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?
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?
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?
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?
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?
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?
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?
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?
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?
Categoy Axis
Which what-if analysis tool is the best option for complex calculations requiring
constrained optimization?
Solver
Which of the following is NOT a capability of the Name Manager?
Paste a name range
Which tool is most effective when comparing the impact of various combiniations
of production expenses and new customer acquisistion on net sales profit?
GRADED
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?
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?
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?
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?
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?
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?
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?
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?
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?
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?
Categoy Axis
Which what-if analysis tool is the best option for complex calculations requiring
constrained optimization?
Solver
Which of the following is NOT a capability of the Name Manager?
Paste a name range
Which tool is most effective when comparing the impact of various combiniations
of production expenses and new customer acquisistion on net sales profit?
