(Solved): 14. Lael wants you to summarize data for all student groups in a PivotTable. ...

???????

14. Lael wants you to summarize data for all student groups in a PivotTable. To do so, you must first update the AllGroups table. Switch to the All Groups worksheet. Update the Astronomy Society membership to 76 for the year 2023. $$\times$$ Edit a record in a table. In the All Groups worksheet, the value in cell G7 should be changed to 76 . 15. Switch to the All Groups PivotTable worksheet. Refresh the PivotTable data, and then verify that the Astronomy Society membership reflects the change you made in the previous step. X Refresh PivotTable data. In the All Groups PivotTable worksheet, the PivotTable should be refreshed. 16. Match the style of the PivotTable to the one on the Activities PivotTable worksheet. X Apply a PivotTable style. In the All Groups PivotTable worksheet, the PivotTable should be formatted using the Light Blue, Pivot Style Medium 2 PivotTable style. 17. Add the Office field to the Filters area of the PivotTable. Display only organizations with private offices. X Filter a PivotTable using a filter. In the All Groups PivotTable worksheet, the PivotTable should be filtered by the Office field. 18. Create an Activities Slicer. Resize the slicer so that it has a height of 2.2 ' and a width of 3.2 . Move and size the slicer so that it covers the range F3:J 14 . Use the slicer to display only fraternal groups. $$X$$ Add a slicer to a PivotTable. In the All Groups PivotTable worksheet, a slicer based on the Activities field should be added to the PivotTable. X Resize and reposition a slicer. In the All Groups PivotTable worksheet, a slicer based on the Activities field should be added to the PivotTable. X Filter a PivotTable using a slicer. In the All Groups PivotTable worksheet, a slicer based on the Activities field should be added to the PlvotTable.