You are an assistant to the manager of Sugarhouse District Theatre, where touring Broadway shows are performed. You created a workbook for the weekend evening performances to track the number of seats available and sold in each section of the theatre, along with gross revenue. You are ready to complete the workbook. Steps to Perform: Step Instructions Points Possible 1 Start Excel. Download and open the file named Exp19_Excel_Ch09_HOEAssessment_TicketSales.xlsx. Grader has automatically added your last name to the beginning of the filename. Note: When you open the file, Excel prompts you to fix a circular error. Click OK and continue. 0 2 The first column in the Friday worksheet contains cells with a different font color and levels of indentation. You want to fill this formatting across the Saturday and Sunday worksheets. Group the Friday, Saturday, and Sunday worksheets. Fill the formatting for the range A5:A20. 4 3 You notice that a formula is missing on three worksheets. You will insert the formula simultaneously. With the worksheets still grouped, in cell E21, enter a formula to subtract the Grand Total Percentage Sold from 1. Apply Bold to the cell. Ungroup the worksheets. 15 4 The Totals worksheet contains summary data. You will insert a hyperlink to the number of seats sold in each respective worksheet. On the Totals worksheet, in cell A5, insert a hyperlink to cell C21 in the Friday worksheet with the ScreenTip text Friday. In cell A6, insert a hyperlink to cell C21 in the Saturday worksheet with the ScreenTip text Saturday. In cell A7, insert a hyperlink to cell C21 in the Sunday worksheet with the ScreenTip text Sunday. Test the hyperlinks to ensure the work correctly. 15 5 Now you are ready to insert a formula with a reference to the number of seats sold for Friday's performance. In cell B5, insert a formula with a 3-D reference to cell C21 in the Friday worksheet. 5 6 Now you are ready to insert a formula with a reference to the number of seats sold for Saturday's performance. In cell B6, inser
RELATED QUESTIONS
RELATED TOPICS
ABOUT ANSWERBAG
Answerbag wants to provide a service to people looking for answers and a good conversation. Ask away and we will do our best to answer or find someone who can.We try to vet our answers to get you the most acurate answers.
Copyright 2023, Wired Ivy, LLC