CTED VIEW

This file has been verified by Microsoft Defender Advanced Threat Protection and it hasn't detected any threats. If you need to edit this file, click enable editing.

Werspectives Excel $2019|$ Module $7$: SAM Project $1b$

$12.$ Switch to the Melbourne Swim Teams worksheet. In cell B$14,$ use the INDEX function and structured references to display the value in the first row and first column of the SwimTeams table.

$13.$ In cell B$16,$ use the SUMIF function and structured references to display the total wins for teams in the Youth league.

$14.$ Brittany wants to display the Melbourne swim teams data by league and year. She asks you to create a PivotTable to better manipulate and filter the data. Switch to the Melbourne PivotTable worksheet, and then create a PivotTable in cell A$1$ based on the SwimTeams table. Update the PivotTable as follows so that it matches Final Figure $3$:

a$.$ Change the PivotTable name to: MelbournePivotTable

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

c$.$ Add the $2020,2021,$ and $2022$ fields $($in that order$)$ to the Values area.

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

e$.$ Change the report layout to Show in Outline Form.

f$.$ Update the Sum of $2020$ field in the Values area to display the name $2020$ Win with the Number number format with $0$ decimal places.