Apple Keynote '09 - Manual (Page 174)

Working with Numbers in Table Cells
Some table operations, such as formulas and functions that perform mathematical
operations, depend on cells containing numeric values.
Here are tips for working with numbers in table cells:
In a numeric cell use only numerals (0 through 9) or one of the following characters:
m
plus sign (+), minus sign (–), left or right parenthesis ( ), forward slash (/), currency
symbol (for example, $), percent sign (%), period (.), capital E, or lowercase e.
You can apply cell formatting for numbers, as described in “
m Formatting Table Cell
Values for Display” on page 178.
To specify a negative number, precede it with the minus sign (–).
m
When you enter a number that's too large to display in a table cell, Keynote converts
the it to a different numerical format:
When a decimal number doesn't fit in a cell, the number is rounded. For example, Â
1.77777777777777777777 becomes 1.77777777777778.
When a whole number doesn't fit in a cell, the number is displayed using scientific
Â
notation. For example, 77777777777777777777 becomes 7.777778E+19.
Scientific notation displays numbers using an exponent raised by the power of 10.
The exponent is displayed following the E.
If the converted number still doesn’t fit, it’s clipped. See “Resizing Table Rows and
Columns” on page 162 for suggestions.
Sorting Data in Table Cells
You can arrange values in some or all the cells in a column in ascending or descending
order. Rows containing cells being sorted are reordered. Header cells aren’t sorted.
To sort columns of data:
1 Click Inspector in the toolbar, and then click the Table button to open the Table
inspector.
2 Click Table in the Table inspector.
3 Do either of the following:
To sort a table by reordering the cells in a column, select one of the column’s cells, Â
and then choose Sort Ascending or Sort Descending from the Edit Rows & Columns
pop-up menu.
To sort part of a table by reordering some of the cells in a column, select the cells
Â
before choosing Sort Ascending or Sort Descending.
The following table describes how different types of data are sorted in ascending or
descending order.
174 Chapter 10 Using Tables