Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
1
Intermediate
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
Manually set the colors on the PivotTable and move on, since they will be retained on update
Select a cell in the PivotTable > PivotTable Tools > Design > Choose this color scheme from the Styles gallery
Don’t know
2
Intermediate
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?
Select the columns and manually color their cells
Choose a PivotTable style that does come with this formatting built in
Turn on the Banded Columns setting for the PivotTable style
Don’t know
3
Intermediate
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?
Row Headers and Column Headers on, Banded Rows and Banded Columns off
Row Headers and Banded Columns off, Column Headers and Banded Rows on
Banded Columns off, Row Headers, Column Headers and Banded Rows on
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement