Page 69 - Excel Data Analysis

04 537547 Ch03.qxd 3/4/03 11:50 AM Page 55

EVALUATE WORKSHEET DATA 3

You can use the options at the If you want to compare the results of all scenarios at once, you
bottom of the Add Scenario dialog can create a summary report by clicking the Summary button
box to protect your scenario. The in the Scenario Manager dialog box. When you do so, the
Prevent changes option prevents Scenario Summary dialog box opens and gives you access to
users from modifying the scenario. If two summary options. The Scenario summary lets you create a
you select Hide, users can no longer worksheet table that compares your individual scenarios. The
view the scenario when they open option generally works best when you change the same cells in
the worksheet. These options only each scenario. The Scenario PivotTable option creates a
work when you protect your PivotTable report, which is highly recommended when
worksheet. See Chapter 1 for different cells are involved in the scenario calculation. See
information on worksheet protection. Chapter 7 for more information on working with PivotTables.

8% Interest on $130,000

■ The Scenario Values dialog ■ You can click Add to ■ The Scenario Manager ■ The values designated for
box displays. display the Add Scenario dialog box opens. the scenario change in the
dialog box and create corresponding cells.
Á Type the value for each another scenario. ° Click Show to apply the
cell. scenario.
■ You can repeat steps 2 to 7
‡ Click OK.
for each scenario you want to
create.
55