OpenOffice.org OpenOffice - 3.3 Guía básica descargar pdf (Pagina 242)

100

101

Figure 240: Defining the data to be consolidated

7) Specify where you want to display the result by selecting a target range from

the Copy results to drop-down list.

If the target range is not named, click in the field next to Copy results to and

enter the reference of the target range or select the range using the mouse or

position the cursor in the top left cell of the target range. Copy results to takes

only the first cell of the target range instead of the entire range as is the case

for Source data range.

8) Select a function from the Function list. This specifies how the values of the

consolidation ranges will be calculated. The default setting is Sum, which adds

the corresponding cell values of the Source data range and gives the result in

the target range.

Most of the available functions are statistical (such as Average, Min, Max,

Stdev), and the tool is most useful when you are working with the same data

over and over.

9) At this point you can click More in the Consolidate dialog to access the

following additional settings:

• Select Link to source data to insert formulas that generate the results

into the target range, rather than the actual results (the default action). If

you link the data, any values subsequently modified in the source range

are automatically updated in the target range.

Caution

The corresponding cell references in the target range are inserted in

consecutive rows, which are automatically ordered and then hidden

from view. Only the final result, based on the selected function, is

displayed.

242 OpenOffice.org 3.3 Calc Guide

1 2 ... 237 238 239 240 241 242 243 244 245 246 247 ... 433 434

Comentarios a estos manuales

Sin comentarios

OpenOffice.org OpenOffice - 3.3 Guía básica Pagina 242

Comentarios a estos manuales

Relacionado con productos y manuales para Software OpenOffice.org OpenOffice - 3.3