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
How would you clear all the conditional formatting rules from your PivotTable?
Select any cell in the PivotTable > Home > Conditional Formatting > Clear Rules > Clear Rules from Entire Worksheet
Select any number of cells in the PivotTable > Home > Conditional Formatting > Clear Rules > Clear Rules from This PivotTable
Select all cells of the PivotTable > Home > Conditional Formatting > Clear Rules > Clear Rules from Selected Cells
Don’t know
2
Intermediate
The conditional format for the Food subtotal on the following PivotTable appears to be a Top 3 rule. What can we be certain of?
It is configured to show the Top 3 Values
It is applied to “All cells showing Sales $ Values”
It is applied to “All cells showing Sales $ values for Class and Week”
Don’t know
3
Intermediate
The light green conditional format applied to the sales by week and category details area of the PivotTable below appears to be a Top 10 rule. What can we be certain of?
It is configured to show Top 10 Values for “All cells showing Sales $ values for Category and Week”
It is applied to “All cells showing Sales $ values for Category and Week”
It is applied to “All cells showing Sales $ Values”
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement