Scenarios

<< Click to Display Table of Contents >>

Scenarios

FreeOffice: The Scenario feature is not included in SoftMaker FreeOffice.

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

Scenarios can be used to observe how the calculations in a worksheet change when the values in specific cells are altered. This enables you to perform all kinds of "what-if" analysis.

Example: What effect on the total costs of a loan will it have when the duration is varied between 24, 36 and 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

See the following pages for more information.