OpenOffice.org 2.x Guía de usuario descargar pdf (Pagina 266)

100

101

Chapter 4: Spreadsheets in Calc

Using References in formulae

So far users have been introduced to formulae containing absolute values, absolute and

relative references and references to named ranges. Occasionally we have also mentioned the

Wizard: Functions. Here is an example of references used in formulae, with the help of the

Wizard: Functions.

Consider the example from the previous topic. Now, use the functions Wizard to calculate the

average of monthly sales for each location.

1. Position the cursor in cell B8, where the average will be displayed. Activate the Wizard:

Functions by clicking its icon on the formula bar.

2. Select the AVERAGE function. Where the category that contains this function is unknown,

simply leave the default set to all categories and repeatedly press the letter A until the

AVERAGE function is selected.

3. Click Next in the Wizard: Functions. On the right half of the Wizard, another input area

will appear where one can enter the arguments of the function.

4. Click in the input field into which values are to be entered, in this case starting with field

number 1. Enter either B3:B6 or January or use the mouse to select that range in the

sheet. To do so, simply click on the first cell, B3, hold down the mouse button and drag to

B6.

OpenOffice.org User Guide for 2.x 232

1 2 ... 261 262 263 264 265 266 267 268 269 270 271 ... 507 508

Comentarios a estos manuales

Sin comentarios

OpenOffice.org 2.x Guía de usuario Pagina 266

Comentarios a estos manuales

Relacionado con productos y manuales para Manuales de software OpenOffice.org 2.x