Creating Scenarios

graphics/microsoft47.gif

Because some worksheet data is constantly evolving, the ability to create multiple scenarios lets you speculate on a variety of outcomes . For example, the marketing department might want to see how its budget would be affected if sales decreased by 25 percent. Although it's easy enough to plug in different numbers in formulas, Excel allows you to save these values and then recall them at a later time. The ability to create, save, and modify scenarios means a business will be better prepared for different outcomes to avoid economic surprises .

Create and Show a Scenario

graphics/one_icon.jpg

Click the Tools menu, and then click Scenarios.

graphics/tow_icon.jpg

Click Add.

graphics/three_icon.jpg

Type a name that identifies the scenario.

graphics/foure_icon.jpg

Type the cells you want to modify in the scenario, or click the Collapse Dialog button, use your mouse to select the cells , and then click the Expand Dialog button.

graphics/five_icon.jpg

If you want, type a comment.

graphics/six_icon.jpg

Click OK.

graphics/seven_icon.jpg

Type values for each of the displayed changing cells.

graphics/eight_icon.jpg

Click OK.

graphics/nine_icon.jpg

Click Close.

graphics/11inf08.jpg

graphics/11inf09.jpg

graphics/11inf10.jpg

Show a Scenario

graphics/one_icon.jpg

Click the Tools menu, and then click Scenarios.

graphics/tow_icon.jpg

Select the scenario you want to see.

graphics/three_icon.jpg

Click Show.

graphics/foure_icon.jpg

Click Close.

graphics/11inf11.jpg

Did You Know?

You can create a scenario summary report . Click the Tools menu, click Scenarios, click Summary, click the Scenario Summary option, and then click OK. A scenario summary worksheet tab appears with the report.



Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net