Please help me this again. Below, there is Excel links

Instructions:

2.Group worksheets Quarter1 through Quarter4. Create formulas in the cell range D6:E10 to calculate the admission collected from both adult and children visitors for each location using the appropriate rates in the Rates worksheet.

Widen column widths, if necessary.0.75

3.With the worksheets still grouped, in cells B11:E11, calculate the total adult and children visitors as well as the adult and child admission collected.

4.Format cells D11:E11 with the Accounting Number Format. Format the number of visitors in B6:C11 with the Comma Style and no decimals. AutoFit columns A:E. Add a bottom border to cells B10:E10, and then typeTotalin cell A11.

5.On the Summary worksheet, enter a 3-D SUM function in cells B6:E10 to calculate the total visitors and admissions for each category and location from Quarter1 through Quarter4.

0.75

6.Use Fill Across Worksheets to copy the formatting for cells B6:E10 from the Quarter4 worksheet to the Summary worksheet. Adjust column widths on the Summary worksheet, if necessary.

0.75

7.Use Fill Across Worksheets to copy the content and formatting from cells A11:E11 on the Quarter4 worksheet to the Summary worksheet. AutoFit columns B:E in the Summary worksheet.

0.25

8.On the LinkedSummary worksheet, in cell A5, createAa linked consolidation using cells A5:E11 from each of the quarter worksheets. Select Top row, Left column, and Create links to source data in the Consolidate dialog box.

0.75

9.Change the column width of column A to20, hide column B, and use the AutoFit feature for columns C:F. Save the workbook.

0.5

10.In the opene04ch07Parks_grader_a1_LastFirstworkbook, delete the Rates worksheet.

Open the downloaded filee04ch07_grader_a1_ParkRates.xlsx.

Click the Rates worksheet.

Arrange the two workbooks so you can see them side by side.

One04ch07Parks_grader_a1_LastFirst, group the Quarter1 through Quarter4 worksheets.

Click cell D6, and then in the Formula Bar, replace#REF!B6with a link to cell B6 on the Rates worksheet of thee04ch07_grader_a1_ParkRatesworkbook.0.7511In cell D6, change the cell reference$B$6to a relative reference to remove the absolute reference, and then use the fill handle to copy to cell E6 and cells D7:E10.Select D10:E10 and reapply the bottom border.Ungroup the sheets. If necessary, adjust column width.Closee04ch07_grader_a1_ParkRates.

212One04ch07_grader_a1_Parks_LastFirstworkbook, if necessary, add the Compare Merge Workbooks button to the Quick Access Toolbar.

Sharee04ch07_grader_a1_Parks_LastFirstworkbook and allow changes to be made.

Savee04ch07_grader_a1_Parks_LastFirstworkbook ase04ch07_grader_a1_Parks2_LastFirst, using your last and first name.

On the Quarter1 sheet, change the Adult visitors to Splash Park to250and the Children visitors to576. Save the changes and close the workbook.

Opene04ch07_grader_a1_Parks_LastFirst.xlsx, click Enable Content, and compare and merge the workbook with e04ch07_grader_a1_Parks2_LastFirst.xlsx.Save and close the workbooks.

Note, Mac users, on the Review tab, click Share Workbook. Ensure that the Allow changes by more than one user at the same time option is selected, and then click OK. From the Tools menu, click Merge Workbooks.1.513Exit Excel and submit the filee04ch07_grader_a1_Parks_LastFirst.xlsxas directed by your instructor.

https://drive.google.com/file/d/1SifHbwXBoCRDJJUBnKuU1CN_8GcXy1hN/view?usp=sharing

https://drive.google.com/file/d/1LQE-Yyge66mSrT_4HNqEN0Zeog5RlD2_/view?usp=sharing