Calc Guide

To delete a scenario, right-click the name in the Navigator and choose
Delete.
To edit a scenario, including its name and comments, right-click the
name in the Navigator and choose Properties. The Edit Properties
dialog is the same as the Create Scenario dialog (Figure 226).
Figure 227: Scenarios in the Navigator
Tracking values in scenarios
To learn which values in the scenario affect other values, choose Tools
> Detective > Trace Dependents. Arrows point to the cells that are
directly dependent on the current cell.
Using other “what if” tools
Like scenarios, Data > Multiple Operations is a planning tool for
“what if” questions. Unlike a scenario, the Multiple Operations tool
does not present the alternate versions in the same cells or with a
drop-down list. Instead, the Multiple Operations tool creates a formula
array: a separate set of cells showing the results of applying the
formula to a list of alternative values for the variables used by the
Chapter 9 Data Analysis 281