Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.3. Apply and manipulate PivotTables: Column Header

 

Column Headers

2. What Do You See? This PivotTable now has a Column Header that shows the Categories in Columns. There is a Subtotal for each category: Corporate, Educational, Government, Private. These are the Column Labels.

 

What Else Do You See? Cell B3 is the Filter for the Column Labels.

 

Keep going...

 

Memo to Self: These numbers may look odd because they are not formatted for currency.

PivotTable Tools ->Options-> Show> Field List