Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

12. Switch to the Melbourne Swim Teams worksheet. In cell B14, use the INDEX function and structured references to display the value in the first

image text in transcribed
12. Switch to the Melbourne Swim Teams worksheet. In cell B14, 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 B16, 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 A1 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 2023, 2024, and 2025 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 2023 field in the Values area to display the name 2023 Wins with the Number number format with 0 decimal places. g. Update the Sum of 2024 field in the Values area to display the name 2024 Wins with the Number number format with 0 decimal places. h. Update the Sum of 2025 field in the Values area to display the name 2025 Wins with the Number number format with 0 decimal places

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting Information For Decisions

Authors: Thomas L. Albright , Robert W. Ingram, John S. Hill

4th Edition

0324222432, 978-0324222432

Students also viewed these Accounting questions