Exam 77-427 Microsoft Excel 2013 EXPERT 4. Create Advanced Charts and Tables 4.2   Create and Manage PivotTables: Format Data   PivotTable Design There are two sets of PivotTable Tools. The following pages will walk through the PivotTable Tools Design Ribbon. 1. Try This: Review the Design Ribbon The Layout Group lets you format the: Subtotals Grand Totals Report Layout Blank Rows   The PivotTable Style Options are: Row Headers Column Headers Banded Rows Banded Columns   Keep going...

PivotTable Tools ->Design-> Layout