Exam 77-427 Microsoft Excel 2013 EXPERT
4. Create Advanced Charts and Tables
4.2 Create and Manage PivotTables: Manupulate PivotTables (Group Records)

 

PivotTable: Display

4. What Do You See? There are four Categories. Each Category has a Subtotal. The names and the sum of the amounts for each Product sold is listed in alphabetical order in the client categories.

 

What Else Do You See? The Row Labels in Cell A3 have Filters. You can use the filter to show some or all of the Categories.

 

This is a good place to pause and try that again. Try switching the fields from the Row Labels to the Column Labels. Look at the PivotTable and see which way is easiest to read, which way makes more sense.

 

Then, Save.

 

Memo to Self: These numbers may look odd because they are not formatted for Accounting ($).

PivotTable Tools ->Analyze

graphic1
graphic2