When worksheets are grouped, what you do to one worksheet happens to the other worksheets in the group. To save yourself time and ensure consistency, you will group the Quarter 1-4 worksheets and then create formulas and complete formatting. 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 referencing to the appropriate rates in the Rates worksheet. Leave the worksheets grouped.	1.6
3	With the worksheets still grouped, in cells B11:E11, calculate the totals of the columns.
4	With the worksheets still grouped, format cells B6:C11 with the Comma style and no decimals. Format cells D11:E11 with the Accounting Number Format. AutoFit columns A:E. Apply the Total cell style to cells B11:E11. Type Total in cell A11. Ungroup the worksheets.
5	3-D references allow formulas and functions to use data from cells and cell ranges across worksheets. 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.
6	To save yourself time in formatting the Summary worksheet, use the Fill Across Worksheets feature to copy the formatting for cells B6:E10 from the Quarter1 worksheet to the Summary worksheet.