Back to School Sale -
20% off all courses with code BTS2019
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, 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.
Duplicate an existing style which is close to your end goal 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?
First Row Stripe.
Subtotal Row 1.
Row Subheading 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 and Second Row Stripe’s Stripe Size elements both to 3.
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.