1. Lael wants to summarize data for all student groups in a PivotTable. To do so, she must first update the AllGroups table. Switch to the All Groups worksheet then edit the record for the Astronomy Society to use 76 as the 2023 field value. 2. Switch to the All Groups PivotTable worksheet. Refresh the PivotTable data, then verify that the 2023 Membership value for the Astronomy Society in row 6 reflects the change you made in the previous step.
Group Name Type Activities Office 2021 2022 2023
Accounting and
Finance Forum Academic Professional None 5 6 5
Alpha Chi Omega Greek Fraternal Private 13 12 13
Alpha Phi Greek Fraternal Private 54 49 61
Alpha Phi Alpha Greek Fraternal Private 6 6 6
Arab Students
Association Cultural Educational Private 4 3 4
Astronomy Society Academic Field Private 37 51 42
Badminton Club Recreational Field None 28 36 47
Black Students
Association Cultural Educational Private 35 35 33
Broomstick Ball Recreational Field None 34 41 38
Camping and
Excursion Club Recreational Field Public 14 17 14
Chi Omega Greek Fraternal Private 27 30 36
College
Democrats Cultural Political Private 7 10 10