IV. What-If-Analysis (Part Two) (10%)

  1. Copy the calculation sheet to a new sheet
    and name the new sheet as "what-if-result".
  2. Type the following question at cell A18:
    What will be the unit sale price of Intro to Computers set
    if the total of profits at the cell G9 is $54321?
  3. Type the following question at cell A19:
    The unit sale price of Intro to Computers should be set _____
  4. Find the answer for the above question and
    type the answer at the location of cell A20.
    Show the answer with 2 decimal places.
Go to Next Page