Back to School Sale -
20% off all courses with code BTS2019
Search for courses or lessons
Redeem a coupon
Start free trial
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?
Manually set the colors on the PivotTable then ensure that the Preserve Formatting on Update option is set.
Select a cell in the PivotTable > PivotTable Tools > Design > Choose this color scheme from the Styles gallery.
Manually set the colors on the PivotTable and move on, since they will be retained on update.
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?
Turn on the Banded Columns setting for the PivotTable style.
Select the columns and manually color their cells.
Choose a PivotTable style that does come with this formatting built in.
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?
Banded Columns off, Row Headers, Column Headers and Banded Rows on.
Row Headers and Banded Columns off, Column Headers and Banded Rows on.
Row Headers and Column Headers on, Banded Rows and Banded Columns off.