Exam 5: Subtotals Pivot-tables and Pivot-charts

Once slicers are created additional Slicer Styles can be applied.

How are grouped columns ungrouped?

PivotTables can be created from the ________ tab in the Ribbon.

A PivotTable can be created from the Quick Analysis gallery.

Slicers can only be removed from the Analyze tab in the Ribbon.

Which of the following is not a PivotTable Subtotals option?

Where is the command to insert a PivotTable located in the Ribbon?

Match the following PivotTable areas with the corresponding description: I.PivotTable Fields task pane II.Filters Area III.Columns Area IV.Rows Area V.Values Area A.Organizes and groups data into categories on the left side.Each group name occupies a single row. B.Displays summary statistics,such as totals or averages. C.Subdivides data into one or more additional categories. D.Filters the data to display results based on particular conditions you set. E.Contains two sections that allow for the editing of a PivotTable.

Which of the following tools is best suited for complex cross referenced subtotals?

Where are PowerPivot tools located on the Ribbon?

When editing a PivotTable where are values field settings edited?

When the calculation options of a PivotTable are set to % of ________ Row Total,the PivotTable displays values as: (value for the item)/ (value for the parent item on rows).

Where is the Subtotal command located on the Ribbon?

The ________ is text that displays in the header at the top of the slicer window.