Office 2013 For Dummies by Wallace Wang

Author:Wallace Wang
Language: eng
Format: epub, pdf
Publisher: John Wiley and Sons, Inc.
Published: 2013-02-07T16:00:00+00:00

Figure 9-17: Define a scenario name, the cells you want to change, and any comments you want to include.

5. Click in the Scenario Name text box and type a descriptive name for your scenario, such as Worst-case or Best-case.

6. Click in the Changing Cells text box.

7. Click a cell in your spreadsheet that you want to display different data. If you want to choose multiple cells, hold down the Ctrl key and click multiple cells.

8. Click in the Comment text box and type any additional comments you want to add to your scenario, such as any assumptions your scenario made.

9. Click OK.

The Scenario Values dialog box appears, as shown in Figure 9-18.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.