How do I do this? :(  Can you show me how to do this on the excel exercise?

 

 

Ofce 2013 – myitlab:grader – InstructionsExploring Excel Ch. 06 - H1 ProjectWhat-If AnalysisProject Description:In the following project, you will perform What-IF Analysis to calculate budget information for yourUniversity’s Valentine’s Day formal.Instructions:For the purpose o± grading the project you are required to per±orm the ±ollowing tasks:StepInstructionsPointsPossible1Download and open the ²le named exploring_e06_grader_h1.xlsx, and then savethe ²le asexploring_e06c1Dance_LastFirst, replacingLastFirstwith your name.02Use Goal Seek to achieve a $0 balance by changing the Ticket Price per Person.63Beginning in cell E3, complete the series o± substitution values ranging ±rom200to500at increments o±20students vertically down column E34Enter cell re±erences to the Total Income, Total Expenses, and Balance ±ormulas (inthat order) ±or a one-variable data table in cells F2, G2, and H2 respectively.35Apply custom number ±ormats to make the ±ormula re±erences appear as the±ollowing: F2-Revenue, G2 –Expenses, H2 –Balance.36Create a one-variable data table ±or the range E2:H18 using the Number o±Attendees as the column input cell. Format the results with Accounting NumberFormat with two decimal places.77Copy the Number o± Attendees substitution values ±rom the one-variable data table(in cells E3:E18), and then paste the values starting in cell E22.48Type$50in cell F21 and complete the series o± substitution values ±rom $50 to$100at $10increments.29Enter the cell re±erence to the Balance ±ormula (C34) in the cell E21 ±or a two-variable data table, then complete the table using cell B9 as the row input cell andB4 as the column input cell. Format the results with Accounting Number Formatwith two decimal places.710Apply a Red, Accent 2, Lighter 60% ²ll color to the cells closest to break-evenwithout creating a de²cit.2Updated: 07/18/20131E_CH06_EXPV2_H1_Instructions.docx

Valentne's Day BallInput SecTonNo. of ATendees400% ATendees Using Vale±50%Cos± per Chair Se±up$2.00Vale± Parking per Car$19.95Ca±erer's Meal Cos± per Person$20.95²icke± Price per Person$75.00LimitaTonsMaximum ATendees500Maximum Parking S±alls240Minimum ²icke± Price$50.00Maximum ²icke± Price$100.00IncomeS±uden± Club Con±ributons$8,500²icke± Revenue30,000²o±al Income$38,500ExpensesAdvertsing$3,345Ballroom Ren±al12,500Chairs/²able Se±up800Vale± Parking3,990Decoratons4,575DJ Cos±3,000Cleanup Cos±s2,500Meal Cos±8,380Contngency5,000²o±al Expenses$44,090Balance$(5,590)

Attachments:

• 1495155928-exploring_e06_grader_h1.xlsx
• 1495155929-E_CH06_EXPV2_H1_Instructions.docx