Excel PivotTables

Auto audio on: the next questions will be read aloud when you click Continue.

1. 1

   What is the first step to creating a PivotTable in Excel?

   A Select the cells containing the data you want to use. B Go to the 'Insert' tab and select 'Chart'. C Change the cell format to 'Table'.
2. 2

   Which area in a PivotTable would you place a field you want to use as a filter?

   A Values Area B Rows Area C Filters Area
3. 3

   How can you display the sum of sales instead of the count of sales records in a PivotTable?

   A Right-click a sales record cell, choose 'Summarize Values By' and then 'Sum'. B Drag the sales field to the 'Values' area twice. C Change the format of the sales data to currency before creating the PivotTable.
4. 4

   What does the 'Refresh' action do in a PivotTable?

   A Changes the PivotTable style and formatting. B Updates the PivotTable to reflect changes in the underlying data source. C Sorts the PivotTable fields alphabetically.
5. 5

   How can you change the layout of a PivotTable to show field names in different rows?

   A By dragging the fields in the PivotTable Fields pane to the 'Rows' area. B Through PivotTable Tools > Design > Layout Group > Report Layout. C By right-clicking the PivotTable and selecting 'PivotTable Options'.
6. 6

   Which of the following can you use to group dates in a PivotTable?

   A A calculated field B The 'Group' option when right-clicking a date in the PivotTable C The 'Sort & Filter' command on the Home tab
7. 7

   What happens if you click 'Collapse Field' in a PivotTable with multiple row fields?

   A All data outside the first row field is hidden. B The entire PivotTable is minimized into a single row. C Data related to the second row field is grouped under the first row field.
8. 8

   What does adding a 'Calculated Field' allow you to do in a PivotTable?

   A Calculate the average value of a data field. B Create a new data field based on formulas that use existing fields. C Filter out any fields that do not contain numerical values.
9. 9

   What is the default action when double-clicking on a PivotTable value cell?

   A It creates a new worksheet with the source data for that value. B It sorts the PivotTable based on the value of that cell. C It opens the 'Value Field Settings' dialog box.
10. 10

    How do you change a PivotTable value from a 'Count' to a 'Percentage of Column Total'?

    A Right-click on the value cell, choose 'Show Values As', then 'Percentage of Column Total'. B Right-click on the value cell and choose 'Format Cells' to change to percentage format. C Drag the field to the 'Values' area, then use the 'Format Painter' to apply percentage formatting.