Read Only To save a copy of this document, click Duplicate.

In cell R$9,$ enter a formula using the AVERAGE function and structured references to

determine the average number of years of post$-$secondary education of all students as

shown in the Post$-$Secondary Years column.

Switch to the Academic Groups workshept. In cell A$14,$ use the INDEX function and

structured references to display the value in the first row and first column of the

AcademicGroups table.

In cell A$17,$ use the SUMIF function and structured references to display the total

membership in $2026$ for groups with at least $40$ members.

Lael is also planning for student groups that the office will be working with in the coming

year. She decides to create a PivotTable to better manipulate and filter the student

group data.

Switch to the Academic PivotTable worksheet, then create a PivotTable in cell A$1$ based

on the AcademicGroups table. Update the PivotTable as follows so that it matches Final

Figure $2$:

a$.$ Change the PivotTable name to: AcademicPivotTable

b$.$ Add the Activities field and the Group Name field $($in that order$)$ to the Rows area.

c$.$ Add the $2024,2025,$ and $2026$ fields $($in that order$)$ to the Values area.

d$.$ Change the display of subtotals to Show all Subtotals at Top of Group.

e$.$ Chance the report lavout to Show in Outline Form.