Valentinebudget | Computer Science homework help

     
1
   Download and open the file named exploring_e06_grader_Capstone2.xlsx.Rename it LastNameFirst_Assignment5__   ValentineBudget.xlsx
 
2
Use   Goal Seek to achieve a $0   balance by changing the Ticket Price per Person. 
  Hint: -Use of the correct cells in Goal Seek dialog box  -Apply Goal Seek correctly  -Correct solution
 
 
3
Beginning   in cell E3, complete the series of substitution values ranging from 200 to 500   at increments of 20   students vertically down column E. 
  Hint:   On the Home tab, in the Editing group, use the Fill tool to complete the   substitution values.  -Series begins in E3  -Correct incrementation  -Values range from 200 to 500
 
 
4
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. 
  Hint:   Create linking formulas to C20, C32, and C34. Cell references are preceded by   the =   sign.  Correct cell references to   -Total Income formula  -Total Expenses formula  -Balance formula
 
 
5
Apply   custom number formats to make the formula references appear as the following:   F2- Revenue,   G2 – Expenses,   H2 – Balance. 
  Hint: Custom number formats make formula references to  -F2- as Revenue   -G2- as Expenses  -F2- as Balance
 
 
6
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. 
  Hint:   -One-variable data table created for range E2:H18  -Number of Attendees used as column input  -Results formatted with Accounting number format  -Format has two decimal places  -Correct values in Data table
 
 
7
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. 
  Hint: -Number of Attendees from one-variable data table copied correctly  -Pasted values starts from E22
 
 
8
Type   $50   in cell F21 and complete the series of substitution values from $50 to $100 at $10   increments. 
  Hint: -Correct value in cell F21  -Correct incrementation  -Values from $50 to $100
 
 
9
Enter   the cell reference to the Balance formula (C34) in the cell E21 for a   two-variable data table, then complete the table using cell B9 as the row   input cell and B4 as the column input cell. Format the results with   Accounting Number Format with two decimal places. 
  Hint: -Cell reference to Balance formula (C34 )in cell E21  -Two-variable table completed with cell B9 as row input  -Two-variable table completed with cell B4 as column input  -Results formatted with Accounting number format  -Format has two decimal places  -Correct values in Data table
 
 
10
Apply   a Red, Accent 2, Lighter 60% fill color to the three cells closest to   break-even without creating a deficit. 
  Hint: -Correct color fill used  -Correct 3 cells highlighted
 
 
11
Apply   custom number format to cell E21 to display