Apple Keynote 3 - Manual (Page 111)

Chapter 5 Creating Tables 111
Following are guidelines for using basic formulas in tables. See “Operators and
Functions for Advanced Users” on page 118 for information about working with more
advanced formulas.
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 Quick 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 Quick Formula pop-up menu.
Keynote places the formula and its result in the first empty cell below the selected
cells. If there is no empty cell, Keynote 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 quick formula.
To perform a basic calculation using row values:
1 Select a range of adjacent cells in a row.