OpenOffice.org 2.x Betriebsanweisung PDF herunterladen (Seite 293)

Chapter 4: Spreadsheets in Calc

Using Scenarios

Scenarios are important aids for making numbers that are dependent on each other and their

resulting calculations visible.

Modify specific basic requirements in the table and see the new result. Name a scenario,

created in this manner, and compare it with other scenarios.

Using Ready-Made Scenarios

If the samples from http://www.pathtech.org/OpenOffice.org/templates/ are installed, choose

one of the ready-made example scenarios with which to work.

1. Choose File > New > Templates and Documents and from the dialogue open the

Samples.

2. Open the spreadsheet examples to see the spreadsheet documents available.

3. Double-click the document with Recar in the name.

This is a sample spreadsheet in which several scenarios have been created.

Areas in which the scenarios that differ by initial values are located are surrounded by

frames. Select the appropriate scenario in the list box appearing at the top of every frame.

Scenarios can also be selected in the Navigator:

1. Open the Navigator with the F5 key or the Navigator icon on the Standard toolbar.

2. Click the Scenarios icon in the Navigator (the icon with the question and exclamation

marks).

In the Navigator, see the defined scenarios with the comments that were entered when the

scenarios were created.

Creating Personal Scenarios

Assuming that the spreadsheet used in the previous section is available, create a scenario by

selecting all the cells that provide the data for the scenario. For example, create an additional

scenario called High Dollar Rate using the following steps:

1. Select the cells that are already highlighted by the frame of the existing scenario.

Remember, multiple-select cells that are not contiguous, i.e. that are distributed across the

table, may also be selected. To select multiple cells, hold down the Ctrl key as each cell is

clicked. However, In this case, simply select the range F 18:F23.

2. Choose Tools > Scenarios.... The Create Scenario dialogue appears.

3. Enter High Dollar Rate as the name of the scenario and leave the other fields at

their default values.

4. Close the dialogue with OK. The new scenario is automatically activated.

OpenOffice.org User Guide for 2.x 259

1 2 ... 288 289 290 291 292 293 294 295 296 297 298 ... 507 508

Keine Kommentare

OpenOffice.org 2.x Betriebsanweisung Seite 293