1. To the right of the large table, Lael has made a quick way to look up a student's name by their Student ID number. To make sure that the cell always displays a meaningful message, nest the existing function in another function to display Invalid Student ID if the VLOOKUP function returns an error result.
2. Lael wants to determine several totals and averages for active students. In the appropriate cell, enter a function and structured references to count the total number of students if they have been elected to offices in student organizations.
3. In the appropriate cell, use a function and structured references to determine the average number of post-secondary years for students who have been elected.
4. In the appropriate cell, use a function and structured references to determine the average number of years of post-secondary education for all students.
5. Switch to the Academic Groups worksheet. Below the cell labeled "Largest Academic Club, 2023:", use a function and structured references to display the first value of the AcademicGroups table.
6. Below the cell labeled "2023 memberships in large groups:", use a function and structured references to display the total membership in 2023 for groups with at least 40 members.
7. Lael is also planning for student groups that the office will be working with in the coming year. She decides to make a PivotTable to better manipulate and filter the student group data. Switch to the Academic PivotTable worksheet, and then make a PivotTable in the first cell based on the AcademicGroups table. Update the PivotTable as follows:
   1. Change the PivotTable name to: AcademicPivotTable
   2. Add rows for Activities and Group Name (in that order).
   3. Add values for 2021, 2022, and 2023 (in that order).
   4. Display all subtotals at the top of each group.
   5. Display the report layout in Outline Form.
   6. Display the appropriate field with the name 2021 Membership as a number with zero decimal places.
   7. Display the appropriate field with the name 2022 Membership as a number with zero decimal places.
   8. Display the appropriate field with the name 2023 Membership as a number with zero decimal places.
8. 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.
9. 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.
10. Match the style of the PivotTable to the one on the Activities PivotTable worksheet.
11. Add the Office field to the Filters area of the PivotTable. Display only organizations with private offices.
12. Make 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:J14. Use the slicer to display only fraternal groups.
13. 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. Insert a Clustered Column PivotChart and format it as follows:
    1. Move and size the PivotChart so that it covers the range F3:O19.
    2. Add the chart title Membership by Type to the PivotChart above the chart.
    3. Display only the membership data for groups with educational, field, and fraternal activities. (This filter may be automatically applied when you make the table.)