ch 5 excel

Question 1

You created a PivotTable and changed some values in the dataset from which the PivotTable was created. How does this affect the​ PivotTable?

A. The PivotTable is deleted from the workbook because it is not​ up-to-date.
B. Changes in the dataset do not affect the PivotTable until you refresh the PivotTable.
C. The PivotTable is updated automatically when you make changes to the dataset.
D. You must create a new PivotTable if you want updated results in a PivotTable.

Answer 1

B. Changes in the dataset do not affect the PivotTable until you refresh the PivotTable.

Question 2

Which of the following is not used when creating a calculated field in a​ PivotTable?

A. Another value to be used in the calculation
B. Operands, such as multiplication​ (*)
C. Name of a field containing values
D. A cell reference to a value outside of the PivotTable

Answer 2

D. A cell reference to a value outside of the PivotTable

Question 3

When you create a clustered column PivotChart from a​ PivotTable, the field that was in the Rows area of the PivotTable Fields task pane creates what part of the​ PivotChart?

A. Category axis
B. Legend
C. Filters
D. Value axis

Answer 3

A. Category axis

Question 3

You created a PivotTable 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?

A. Sort the PivotTable by weekday and then collapse the rows containing Sunday data.
B. Create a calculated field with an IF function.
C. Remove the weekdays from the Columns area of the PivotTable.
D. Set a filter for the Weekday field and deselect the Sunday check box in the filter menu.

Answer 3

D. Set a filter for the Weekday field and deselect the Sunday check box in the filter menu.

Question 4

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?

A. Move the number of customers field from the Values area to the Filters area in the PivotTable Fields task pane.
B. Use the Subtotal feature to select the Average function.
C. Select the Average calculation as a value field setting.
D. Create a calculated field and then remove the PivotTable column containing the totals.

Answer 4

C. Select the Average calculation as a value field setting.

Question 4

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?

A. You filtered out the state names before using the Subtotal feature.
B. The At a change in setting was City within the Subtotal dialog box.
C. You forgot to engage the Auto Outline feature before using the Subtotal feature.
D. The data was sorted by state and further sorted by city.

Answer 4

B. The At a change in setting was City within the Subtotal dialog box.

Question 5

You want to create a PivotTable that uses fields from two Excel tables. What is the first​ step?

A. Merge the two tables into one large dataset before creating the PivotTable.
B. Create a PivotTable using one table and then add the second table to the PivotTable Fields task pane.
C. Create a relationship on a common field between the two tables.
D. Create a subtotal for each​ table, copy and paste the two subtotals​ together, and then create the PivotTable.

Answer 5

C. Create a relationship on a common field between the two tables.

Question 6

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?

A. Rows area
B. Columns area
C. Values area
D. Filters area

Answer 6

A. Rows area

Question 6

Why would you click the collapse outline symbol above a column of outlined​ data?

A. You want to hide the detailed columns to focus on the result column.
B. You want to see more detailed columns that relate to the formula in that column.
C. You want to insert a subtotal row for a set of rows.
D. You want to delete columns containing values.

Answer 6

A. You want to hide the detailed columns to focus on the result column.

Question 7

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?

A. Banded Rows check box and a different PivotTable style
B. Banded Columns check box and a different PivotTable style
C. Banded Rows and Banded Columns check boxes
D. A different PivotTable style only

Answer 7

A. Banded Rows check box and a different PivotTable style