1. 1

    Assume you wanted to format a PivotTable so that it appeared as shown below and automatically preserved the formatting with updates. What would you do?

  2. 2

    The PivotTable shown below is formatted using the “Pivot Style Light 22”, which does not highlight columns by default. How would we achieve the effect of shading every other column as shown below?

  3. 3

    If you wanted to select a PivotTable style that was as close to this as possible, what settings would you check before you started browsing the PivotTable Styles gallery?