Review View HelpTellme e Hame Inert Pae LayoutFormas Resppyett y,Asunced | Columns-, Analysis. What-H Forecast Outline Sheet Data Tooh Project Description: You are am accomting assistamt for Downtown Theater i San Diego. The theater hasts moscals five days a week, incluing and monthly oicket saves by seaing type matinee and evening performances on Salurday. You want to analyze weekly Number of Seats Sold per Day Saturday Saturday ay Wednesday Friday Matinee Evening the.suspose of grading the project you are required to perform the following tasks: Weekly Totals Available Sunday w 15 4 Box Seats Group the four weekty worksheets. Enter a formula in cel C11 to calolate Sunday's Orchestra Front revenue, wich is hased on the number of seats sold and the price per seat. Use rate and mined cell references correctly. Copy the formula for the Sunday column to complete the Level 1 210 Balcony Level 1 1,000 in the 'ange CL5:inert a frotca, to calculate the total daly row nue. tn the H11:H15, insert a function to calculate the weekly totals for the seating categones and grand 8.000 Seating Seat Price Sunday Wednesday Friday Saturday Ms Saturday Eve Weekly Totals Front 168 Indent and bold the word Totas in cels A7 and A15 on t the grouped worksheets. 2.000 12 Box Seats Mezzanine Level 1 $ 155 4 Ralcony Level 1$ 5 In the Revenue per Day section e grouped sheets, apply Accounting Number Format with ero deomal places to the Orchestra Froet revenue (range CII:HI1) and the total revenue rowCIS:HIs). Apply the Commo gyte with 2yo deanal places to the remaning seating revenue rows (C12:H14), Apply the Single Accounting underhne (not borders) to the range Use Feomat Panter to copy the formats from cels A2:H2 to cells A10:H10. Select the ange 18 19 A1:H15 and set the column width to Autofit Ungroup the worksheets. Desplay the Week 4 worksheet and fill the formats of cels Ct and C9 from the Week 4 worksheet to the October 8.000 On the Documentation worksheet, create a hyperink from the Week 1 label to cel Al on the Week 1 workhetCreate the hyperinks from the remaining worksheet labels on the Documentation worksheet to the other worksheets. 8 7.000 emanng workshet iabel on the ein On the Week 1 worksheel, create a byperlink from cell A1 back to cell A1 on the Documentation worlkshest. Add a Screentip Click to go to the Documentation sheet. (including the penod). Geoup the weekly and Otter orksheets, and then use the Rll Across Woksbeets command to copy the link and formating to the other weeldy and summary Weck1 Week 2 Week 3 Week 4 age 101 here to search