Start Excel. Open the downloaded Excel file named e04ch07_grader_a1_Parks.xisx. Save it 0 as e04ch07_grader_al_Parks_LastFirst using your last and first name. Enable content if necessary. 2 Group worksheets Quarter1 through Quarter4. Create formulas in the cell range D6:E10 to 4 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. 3 With the worksheets still grouped, in cells B11:E11, calculate the total adult and children 8 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 8 B6:C11 with the Comma Style and no decimals. AutoFit columns A:E. Add a bottom border to cells B10:E10, and then type Total in cell All. 5 On the Summary worksheet, enter a 3-D SUM function in cells B6:E10 to calculate the total 9 visitors and admissions for each category and location from Quarter1 through Quarter4. 6 Use Fill Across Worksheets to copy the formatting for cells B6:E10 from the Quarter4 4 worksheet to the Summary worksheet. Adjust column widths on the Summary worksheet, if necessary. 7 Use Fill Across Worksheets to copy the content and formatting from cells All:E11 on the 8 Quarter4 worksheet to the Summary worksheet. AutoFit columns B:E in the Summary worksheet. 8 On the LinkedSummary worksheet, in cell A5, create a linked consolidation using cells A5:E11 13 from each of the quarter worksheets. Select Top row, Left column, and Create links to source data in the Consolidate dialog box