Please help me
Directions
Quarter1 Quarter2 Quarter3 Quarter4 Summary Linked Park Management LLC Indiana Admission Adult Child History Museum City Zoo Park Central Splash Park Monument Visitors Adults Children 5268 3654 12556 43521 11574 14962 0 0 3368 1254 Quarter1 Quarter2 Quarter3 Quarter4 Summary Linkedsu Park Management LLC Indiana Admission Adult Child History Museum City Zoo Park Central Splash Park Monument Visitors Adults Children 3524 2984 17588 29745 15225 16854 1258 2145 4896 5214 Quarter1 Quarter2 Quarter3 Quarter4 Summary Linkeds Park Management LLC Indiana Admission Adult Child History Museum City Zoo Park Central Splash Park Monument Visitors Adults Children 6254 2254 19854 35112 16547 17853 22540 30247 2541 2152 Quarter1 Quarter2 Quarter3 Quarter4 Summary Linkeds Park Management LLC Indiana Admission Adult Child History Museum City Zoo Park Central Splash Park Monument Visitors Adults Children 8987 9651 6521 5248 2568 2214 0 0 3854 2558 Quarter1 Quarter2 Quarter3 Quarter4 Summary Linkeds Park Management LLC Indiana Visitors Adults Children Admission Adult Child History Museum City Zoo Park Central Splash Park Monument Quarter Quarter2 Quarter3 Quarter4 Summary LinkedSummary Rates Park Management LLC Indiana Visitors Admission Quarter1 Quarter2 Quarter3 Quarter4 Summary LinkedSummary Rates Park Management LLC Indiana Admission Rates History Museum City Zoo Park Central Splash Park Monument Adult Child $ 7.50 $ 4.50 $ 10.25 $ 7.50 $ 5.50 $ 3.50 $ 10.00 $ 6.00 $ 4.00 $ 2.00 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. 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 5 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 type Total in cell A11. 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. 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. 6 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. 8 On the LinkedSummary worksheet, in cell A5, create a 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. 9 Change the column width of column A to 20, hide column B, and use the AutoFit feature for columns C:F. Save the workbook. 10 In the open e04ch07Parks_grader_a1_LastFirst workbook, delete the Rates worksheet. Open the downloaded file e04ch07_grader_a1_ParkRates.xlsx. Click the Rates worksheet. Arrange the two workbooks so you can see them side by side. On e04ch07Parks_grader_a1_LastFirst, group the Quarter1 through Quarter4 worksheets. Click cell D6, and then in the Formula Bar, replace #REF!B6 with a link to cell B6 on the Rates worksheet of the e04ch07_grader_a1_ParkRates workbook. 11 In cell D6, change the cell reference $B$6 to 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. Close e04ch07_grader_a1_ParkRates. Quarter1 Quarter2 Quarter3 Quarter4 Summary Linked Park Management LLC Indiana Admission Adult Child History Museum City Zoo Park Central Splash Park Monument Visitors Adults Children 5268 3654 12556 43521 11574 14962 0 0 3368 1254 Quarter1 Quarter2 Quarter3 Quarter4 Summary Linkedsu Park Management LLC Indiana Admission Adult Child History Museum City Zoo Park Central Splash Park Monument Visitors Adults Children 3524 2984 17588 29745 15225 16854 1258 2145 4896 5214 Quarter1 Quarter2 Quarter3 Quarter4 Summary Linkeds Park Management LLC Indiana Admission Adult Child History Museum City Zoo Park Central Splash Park Monument Visitors Adults Children 6254 2254 19854 35112 16547 17853 22540 30247 2541 2152 Quarter1 Quarter2 Quarter3 Quarter4 Summary Linkeds Park Management LLC Indiana Admission Adult Child History Museum City Zoo Park Central Splash Park Monument Visitors Adults Children 8987 9651 6521 5248 2568 2214 0 0 3854 2558 Quarter1 Quarter2 Quarter3 Quarter4 Summary Linkeds Park Management LLC Indiana Visitors Adults Children Admission Adult Child History Museum City Zoo Park Central Splash Park Monument Quarter Quarter2 Quarter3 Quarter4 Summary LinkedSummary Rates Park Management LLC Indiana Visitors Admission Quarter1 Quarter2 Quarter3 Quarter4 Summary LinkedSummary Rates Park Management LLC Indiana Admission Rates History Museum City Zoo Park Central Splash Park Monument Adult Child $ 7.50 $ 4.50 $ 10.25 $ 7.50 $ 5.50 $ 3.50 $ 10.00 $ 6.00 $ 4.00 $ 2.00 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. 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 5 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 type Total in cell A11. 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. 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. 6 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. 8 On the LinkedSummary worksheet, in cell A5, create a 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. 9 Change the column width of column A to 20, hide column B, and use the AutoFit feature for columns C:F. Save the workbook. 10 In the open e04ch07Parks_grader_a1_LastFirst workbook, delete the Rates worksheet. Open the downloaded file e04ch07_grader_a1_ParkRates.xlsx. Click the Rates worksheet. Arrange the two workbooks so you can see them side by side. On e04ch07Parks_grader_a1_LastFirst, group the Quarter1 through Quarter4 worksheets. Click cell D6, and then in the Formula Bar, replace #REF!B6 with a link to cell B6 on the Rates worksheet of the e04ch07_grader_a1_ParkRates workbook. 11 In cell D6, change the cell reference $B$6 to 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. Close e04ch07_grader_a1_ParkRates
