Exp22_Excel_Ch09_Cumulative_Theatre | Excel Chapter 9 Cumulative - Sugarhouse District Theatre скачать в хорошем качестве

Exp22_Excel_Ch09_Cumulative_Theatre | Excel Chapter 9 Cumulative - Sugarhouse District Theatre

#Exp22_Excel_Ch09_Cumulative_Theatre #Exp22_Excel_Ch09_Cumulative #Theatre #Cumulative #Cumulative_Theatre #Ch09_Cumulative_Theatre #Excel_Ch09_Cumulative_Theatre #Exp22_Excel_Ch09 #Exp22_Excel #Excel_Ch09 Contact Me For Assignments Help WhatsApp : +923180171259 Email : myitlabmaster259@gmail.com Project Description: 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. Start Excel. Download and open the file named Exp22_Excel_Ch09_Cumulative_Theatre.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 or press OK and continue. The first column in the Template worksheet contains cells with a different font color and levels of indentation. You want to fill this formatting across the Friday, Saturday, and Sunday worksheets. Group the Template, Friday, Saturday, and Sunday worksheets. Fill the formatting for the range A5:A20. You notice that a formula is missing on worksheets. You will insert the formula simultaneously. With the worksheets still grouped, in cell E20, enter a formula to subtract the Grand Total Percentage Sold from 1. Apply Bold to the cell. The range I4:J7 displays the average number of seats sold in each section. However, two results display #DIV/0! because the template does not contain sample values in some sections. You will edit the formula to avoid the error. With the worksheets still grouped, edit cell J5 by enclosing the AVERAGEIF function within an IFERROR function. The value_if_error argument should display the text Missing data. Copy the function to the range J6:J7. Fill Without Formatting to preserve the borders. Hide the Template worksheet. 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 C20 in the Friday worksheet with the ScreenTip text Friday Seats Sold. In cell A6, insert a hyperlink to cell C20 in the Saturday worksheet with the ScreenTip text Saturday Seats Sold. In cell A7, insert a hyperlink to cell C20 in the Sunday worksheet with the ScreenTip text Sunday Seats Sold. Test the hyperlinks to ensure the work correctly. 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 C20 in the Friday worksheet. Now you are ready to insert a formula with a reference to the number of seats sold for Saturday's performance. In cell B6, insert a formula with a 3-D reference to cell C20 in the Saturday worksheet. Now you are ready to insert a formula with a reference to the number of seats sold for Sunday's performance. In cell B7, insert a formula with a 3-D reference to cell C20 in the Sunday worksheet. The next section of the Totals worksheet is designed to display total gross revenue by section. In cell B11, insert the SUM function with a 3-D reference to calculate the total Orchestra Front gross revenue (cell G9) for the Friday, Saturday, and Sunday worksheets. You are ready to insert a function to calculate the total Orchestra Back gross revenue. In cell B12, insert the SUM function with a 3-D reference to calculate the total Orchestra Back gross revenue (cell G14) for the Friday, Saturday, and Sunday worksheets.