17. Apply the Light Blue, Pivot Style Medium 2 PivotTable style to the PivotTable.

18. Add the Office field to the Filters area of the Pivot Table. Filter the table so that only organizations with private offices are visible. 1

9. Filter the PivotTable as follows: a. Create a Slicer based on the Activities field value. b. Resize the slicer so that it has a height of 2.2" and a width of 3.2". c. Move the slicer so that its upper-left corner appears within cell F3 and its lower-right corner appears within cell J14. d. Use the slicer to filter the PivotTable so that only Fraternal groups are visible.

20. Lael also wants to summarize membership data for all organizations using a PivotChart to help determine which groups are showing the most interest from students. Switch to the Activities PivotTable worksheet. Based on the PivotTable on the Activities PivotTable worksheet, insert a PivotChart using the Clustered Column chart type and format it as follows: a. Resize and reposition the PivotChart so that the upper-left corner is located within cell F3 and the lower-right corner is located within cell O19. b. Add the chart title Membership by Type to the PivotChart using the Above Chart option. c. Filter the PivotChart so that only the membership data for groups with educational, field, and fraternal activities in each type of group displays in the chart. (This filter may be automatically applied when you create the table.)

how to solve these please please provide me the formulas