Apple Pages 2 - Manual (Page 186)

186 Chapter 8 Creating Tables
8 Cells E11 and E12 also contain formulas. Examine the formulas in these cells by clicking
outside the table, selecting the table, then double-clicking cell E11 or E12. Cell E11
contains a formula that computes sales tax, and cell E12 contains a formula that sums
the subtotal and the sales tax.
Adding a Quick Formula
The easiest way to perform a basic calculation using values in a range of adjacent
table cells is to add a quick formula using the Table Inspector’s Formula pop-up menu.
 Sum totals the values in the cells.
 Average calculates the arithmetic mean of the values in the cells.
 Min determines which value in the cells is the smallest.
 Max determines which value in the cells is the largest.
 Count determines how many of the values in the cells are numbers.
 Product multiplies all the values in the cells.
To perform a basic calculation using column values:
1 Select a range of adjacent cells in a column.
2 Click Inspector in the toolbar, click the Table Inspector button, and click Numbers.
3 Choose a formula from the Formula pop-up menu.
Pages places the formula and its result in the first empty cell beneath the selected
cells. If there is no empty cell, Pages creates a new row to hold the result.
If the column has a header cell and you want the formula to use all the values in the
column, click the header cell before choosing the formula.