Microsoft Office Tutorials and References
In Depth Information
Defining an alternative data set
6 Click OK to open the Scenario Values dialog box.
7 In the value field, enter 13.2 , and then click OK . The Scenario Values dialog box
closes, and the Scenario Manager dialog box opens again.
8
If necessary, drag the Scenario Manager dialog box to another location on the
screen so that you can view the entire table.
9
In the Scenario Manager dialog box, click Show . Excel applies the scenario,
changing the value in cell C5 to $13.20 , which in turn increases the value in cell E8 to
$747,450,000.00 .
10
In the Scenario Manager dialog box, click Close .
Search JabSto ::




Custom Search