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
In order to apply your own custom PivotTable style to a PivotTable, what steps are necessary?
Duplicate an existing style which is close to your end goal and modify the elements to suit
Duplicate an existing style which is close to your end goal, apply it to the PivotTable and modify the elements to suit
Apply the built-in style closest to what you want and modify the elements to suit
Don’t know
2
Intermediate
You have created a custom PivotTable style with the view shown below. You’d like to modify the header rows for Alcohol and Food to be shown in light blue. What element should you modify?
Subtotal Row 1
Row Subheading 1
First Row Stripe
Don’t know
3
Intermediate
Assuming you wanted to modify the row banding so that it shaded 3 rows grey, then 3 rows white, which PivotTable style elements would you modify?
Set First Column Stripe and Second Column Stripe’s Stripe Size elements both to 3
Set First Row Stripe and Second Row Stripe’s Stripe Size elements both to 3
Set First Row Stripe’s Stripe Size element to 3
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement