i only need the formula for step 4 downtown theater sales exploring excel ch 08 eoc 517790

Downtown Theater Sales Project Description: You are an accounting assistant for Downtown Theater in San Diego. Your task is to analyze the weekly and monthly ticket sales by seating type for the fourth quarter of the year. To complete this project, you will create validation rules, locate and fix invalid data, enter and format data on grouped worksheets, create 3-D formulas, and insert hyperlinks. Additionally, you will use the Error Checking feature to locate and correct errors in the formulas. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step?Instructions?Points Possible??1?Start Excel. Download, save, and open the Excel workbook named Exploring_e08_Grader_EOC.xlsx. Click OK to acknowledge the error.?0??2?On the Week 1 worksheet, create a validation rule for the range C3:G3 so that only whole numbers that are less than or equal to 86 are accepted. Create an input message using the text Orchestra Front as the title and Enter the number of tickets sold per day. (including the period) as the message. Create an error alert using the stop style. Title the error alert Invalid Entry and enter Please enter a whole number that is less than or equal to 86. (including the period) as the message.?8??3?Circle the invalid data on the Week 1 worksheet, and then change each invalid entry to the maximum number of applicable seats.?4??4?Group the Week 1, Week 2, Week 3, and Week 4 worksheets together. In cell C11, insert a formula that will calculate Sunday’s Orchestra Front revenue, which is based on the number of seats sold and the price per seat. Modify the price per seat reference so that the column reference is absolute. Copy the formula to the range C11:G14.?9??5?With the worksheets grouped together, in cell H11, insert a formula to calculate the weekly seating totals. Copy the formula down through cell H14.?9??6?With the worksheets still grouped together, in cell C15, insert a formula to calculate the total…