Excel Sample Test (Conti.)

III. What-If Analysis

1. Copy the calculations sheet to a new sheet and rename the new sheet as What-If-Data.
2. How much of the total payment will be if you change 5% of discount to 3%?
   The answer is ____________.
3. Copy the calculations sheet to a new sheet and rename the new sheet as What-If-Result.
4. How many percent of discount would be if the total final payment is $720?
   The answer is ____________. (Show 2 decimal places please)

Save the file and go to the next page.