OpenOffice.org OpenOffice - 3.2 Základní průvodce stáhnout pdf (Strana 281)

100

101

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

1 2 ... 276 277 278 279 280 281 282 283 284 285 286 ... 496 497

Komentáře k této Příručce

Žádné komentáře

OpenOffice.org OpenOffice - 3.2 Základní průvodce Strana 281

Komentáře k této Příručce

Související produkty a manuály pro Software OpenOffice.org OpenOffice - 3.2