Microsoft Office Tutorials and References
In Depth Information
Defining multiple alternative data sets
6 Click OK to open the Scenario Values dialog box.
7 In the value field, enter 11.50 .
8
Click OK to close the Scenario Values dialog box and open the Scenario Manager .
9
Click Add to open the Add Scenario dialog box.
10
In the Scenario name field, enter Ground and Overnight Increase .
11
At the right edge of the Changing cells field, click the Collapse Dialog button to
collapse the Add Scenario dialog box.
12
Click cell C3 , hold down the Ctrl key, and click cell C6 . Then click the Expand Dialog
button. $C$3,$C$6 appears in the Changing Cells field, and the dialog box title
changes to Edit Scenario .
8
13
Click OK to open the Scenario Values dialog box.
14
In the $C$3 field, enter 10.15 .
15
In the $C$6 field, enter 18.5 .
16
Click OK to close the Scenario Values dialog box and open the Scenario Manager
dialog box.
 
Search JabSto ::




Custom Search