Owner manual

Using Predened Quick Formulas
An easy way to perform a basic calculation using values in a range of adjacent
table cells is to select the cells and then add a quick formula. In Numbers, this is
accomplished using the Function pop-up menu in the toolbar. In Keynote and Pages,
use the Function pop-up menu in the Format pane of the Table inspector.
Sum: Calculates the sum of numeric values in selected cells.
Average: Calculates the average of numeric values in selected cells.
Minimum: Determines the smallest numeric value in selected cells.
Maximum: Determines the largest numeric value in selected cells
Count: Determines the number of numeric values and date/time values in selected cells.
Product: Multiplies all the numeric values in selected cells.
You can also choose Insert > Function and use the submenu that appears.
Empty cells and cells containing types of values not listed are ignored.
Here are ways to add a quick formula:
To use selected values in a column or a row, select the cells. In Numbers, click Function m
in the toolbar, and choose a calculation from the pop-up menu. In Keynote or Pages,
choose Insert > Function and use the submenu that appears.
If the cells are in the same column, the result is placed in the rst empty cell beneath
the selected cells. If there is no empty cell, a row is added to hold the result. Clicking
on the cell will display the formula.
If the cells are in the same row, the result is placed in the rst empty cell to the right
of the selected cells. If there is no empty cell, a column is added to hold the result.
Clicking on the cell will display the formula.
To use m all the values in a column’s body cells, rst click the column’s header cell or
reference tab. Then, in Numbers, click Function in the toolbar, and choose a calculation
from the pop-up menu. In Keynote or Pages, choose Insert > Function and use the
submenu that appears.
The result is placed in a footer row. If a footer row doesn’t exist, one is added. Clicking
on the cell will display the formula.
18 Chapter 1 Using Formulas in Tables