Apple Pages Guia do Utilizador descarregar pdf (Página 196)

196 Chapter 9 Using Formulas and Functions in Tables

Adding Cell References to a Formula

To insert a cell reference, you can click a cell, click a reference tab, or select a range of

cells when there’s an insertion point in the text field of the Formula Editor. You can also

insert a cell reference by typing

When you insert a cell reference by selecting cells or reference tabs, Pages adds cell

references that use header cell names if “Use header cell names as references” is

selected in the General pane of Pages preferences.

Here are ways to add a cell reference at the insertion point in the text field:

m To create a reference to a specific cell by using your mouse, click the cell.

You can also type a reference to a specific cell. Use the column letter followed by the

row number (A4) in the reference tabs or use the column name followed by the row

name (2006 Class Enrollment).

m To add a reference to a list of individual cells, click each cell. If the references are

arguments in a function, Pages automatically inserts a comma (,) between the

references, which you can replace with a different character if needed. For example, if

you’re in a location where the decimal separator is a comma, you can separate multiple

cell references using a semicolon instead of a comma.

m To add a reference to a range of adjacent cells, drag over the cells you want to add.

You can also type or click the first cell, type a colon, and then type or click the last cell.

For example B2:B5 refers to four cells in the second column. B2:C3 refers to two cells in

the second column and two cells in the third column.

m To refer to all the cells in a column, click the column’s reference tab or click its header

cell if there is one.

You can type the reference by using the column letter (C or C:C) or the column name if

there’s a header cell. For example, SUM(B) or SUM(B:B) adds all the values in the cells of

the second column.

m To refer to all the cells in a row, click the row’s reference tab or click its header cell if

there is one.

You can type the reference by using the row number (1:1) or the row name if there’s a

header cell. For example, SUM(1:1) adds all the values in the cells of the first row.

Copying or Moving Formulas with Cell References

You can copy or move a formula that contains cell references without invalidating the

references.

Here are techniques for relocating formulas:

m To move a formula to a different cell, move the formula’s cell by dragging it to another

cell.

1 2 ... 191 192 193 194 195 196 197 198 199 200 201 ... 245 246

Sem comentários

Apple Pages Guia do Utilizador Página 196