Apple Pages '08 - Manual (Page 191)

Chapter 9 Using Formulas and Functions in Tables 191
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.
4 The values in the Unit Price and the Cost column are displayed using a number format.
To see the number format settings, close the Formula Editor by clicking outside the
table. Then click the table, click the Unit Price cell in the second row, click Inspector in
the toolbar, select the Table Inspector, and then click Format.
See “Formatting Cell Values” on page 178 for instructions for using formatted numbers.
Columns are referenced
alphabetically.
Rows are referenced
numerically.
This is cell B2.
The comma is used as the
thousands separator.
A $ is displayed
in front of numbers
in the cells.
Numbers are displayed
using two decimal places.