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

184 Chapter 8 Creating Tables

2 Select the table, then double-click the value in the Cost cell in the first row. The

Formula Editor opens, revealing that the value is derived using a formula.

The symbol * is the multiplication operator.

3 To understand which cells B2 and C2 are, look at the reference tabs that appeared on

the table’s top and left sides when the Formula Editor opened.

The reference tabs help you quickly identify any cell in a table. In a formula, you refer

to a cell by identifying the column, then the row, creating what’s known as a cell

reference.

B2 is the cell reference for column B (Quantity), row 2. C2 is the cell reference for

column C (Unit Price), row 2. The value in row 2 of the Cost column (E2) is derived by

multiplying Quantity by Unit Price values that reside in row 2.

The formula in the Cost cell

in the first row multiplies the

values in two other cells—B2

and C2.

Columns are referenced

alphabetically.

Rows are referenced

numerically.

This is cell B2.

1 2 ... 179 180 181 182 183 184 185 186 187 188 189 ... 249 250

Sem comentários

Apple Pages Guia do Utilizador Página 184