In the following project, you will perform What-IF Analysis to calculate budget information for your University’s Valentine’s Day formal.
For the purpose of grading the project you are required to perform the following tasks:
Download and open the file named exploring_e06_grader_h1.xlsx, and then save the file asexploring_e06c1Dance_LastFirst, replacing LastFirst with your name.
Use Goal Seek to achieve a $0 balance by changing the Ticket Price per Person.
Beginning in cell E3, complete the series of substitution values ranging from 200 to 500 at increments of 20 students vertically down column E
Enter cell references to the Total Income, Total Expenses, and Balance formulas (in that order) for a one-variable data table in cells F2, G2, and H2 respectively.
Apply custom number formats to make the formula references appear as the following: F2- Revenue, G2 –Expenses, H2 – Balance.
Create a one-variable data table for the range E2:H18 using the Number of Attendees as the column input cell. Format the results with Accounting Number Format with two decimal places.
Copy the Number of Attendees substitution values from the one-variable data table (in cells E3:E18), and then paste the values starting in cell E22.
Type $50 in cell F21 and complete the series of substitution values from $50 to $100 at $10 increments.