In this exercise you are required to create a scenario on the current worksheet.
|
Opening the Add Scenario dialog box
|
Saving a scenario named Worst Prices
|
#task 0101
Open the Add Scenario dialog box.
|
choose Tools - Scenarios
|
Click Add
|
You have completed this task sucessfully.
|
You have not completed this task sucessfully.
|
#task 0102
Save a scenario named "Worst Prices", using cells B13:B16 as variables. Change the value of the variable B_Growth to 1% and accept all other values, and the default Comment and Protection.
|
type Worst Prices in the name field
|
double - click the Changing cells field
|
type B13:B16 in the Changing cells field
|
click OK
|
double - click the second field
|
type 1%
|
click OK
|
click Close
|
You have completed this task sucessfully.
|
You have not completed this task sucessfully.
|
#exercise 02
In this exercise you are required to create a report for printing.
|
Creating a report with Report Manager
|
#task 0103
Create a report called "1997 Prices". The report should contain two sections, both from the worksheet called Prices, and showing a view called Prices. One section should show a best-case scenario; the other a worst-case scenario.
|
choose View-Report Manager
|
type 1997 Prices at the Report Name field
|
select Prices in the Sheet drop-down list
|
click Prices in the View drop-down list
|
select Best Prices in the Scenario drop-down list
|
click Add
|
select Worst Prices in the Scenario drop-down list
