<< Click to Display Table of Contents >> Scenarios

In the iOS version, the command is locked. (To unlock the command, see Welcome.)

The ribbon command Data | group Analyze | Scenario manager allows you to create and display "scenarios".

Scenarios can be used to observe how changing the values in specific cells affects the calculations in a worksheet. This enables you to perform all kinds of "what-if" analyses.

Example: How does the total cost of a loan change if the term is 24, 36 or 96 months?

In this section, you will learn everything you need to know about scenarios. The following topics are covered:

▪Creating scenarios

▪Showing scenarios

▪Managing scenarios

▪Merging scenarios

▪Creating a scenario summary

For more information, see the following pages.