IV. What-If-Analysis (Part Two) (10%)
- Copy the calculation sheet to a new sheet
and name the new sheet as "what-if-result".
- 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?
- Type the following question at cell A19:
The unit sale price of Intro to Computers should be set _____
- 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