Apple Pages 2 - Manual (Page 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.