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

100

101

Chapter 4: Spreadsheets in Calc

Addressing by Name

A neat way of making the references to cells and cell ranges in formulae legible is to give the

ranges names. For example, name the range A1:B2 as Start then in the formula simply enter

=SUM(Start). Following the insertion or deletion of rows and columns OpenOffice.org

also correctly assigns the ranges identified by name. Remember, range names cannot contain

any spaces.

For example, it is much easier to read a formula for sales tax if written as = Amount *

Tax_rate instead of = A5 * B2. In this case, cell A5 would be named as Amount and

cell B2 as Tax_rate.

In order to specify range names, follows these steps:

1. First highlight the area to be named.

2. Select Insert > Names > Define, or use the Ctrl + F3 key combination.

3. Enter the name for the first area.

4. Click Add.

Other cell ranges can also be named in this dialogue by entering the desired name in the

field and then selecting the respective cells. Use the Define Names dialogue to define

names for formulae or parts of formulae needed more often.

5. Close the dialogue with OK.

Recognizing Names as Addressing

OpenOffice.org can correlate names with areas for the most part automatically, as long as the

row and column coordinates are entered. Refer to the following graphic.

OpenOffice.org User Guide for 2.x 229

1 2 ... 258 259 260 261 262 263 264 265 266 267 268 ... 507 508

Comentarios a estos manuales

Sin comentarios

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

Comentarios a estos manuales

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