Search for courses or lessons
Redeem a coupon
Start free trial
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
Apply the built-in style closest to what you want 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
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?
Row Subheading 1
First Row Stripe
Subtotal Row 1
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 Row Stripe’s Stripe Size element to 3
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
Back to the top
© 2019 GoSkills Ltd.
Skills for career advancement