Apple Keynote Guide de l'utilisateur télécharger pdf (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 dierent numerical format:

When a decimal number doesn't t in a cell, the number is rounded. For example, Â

1.77777777777777777777 becomes 1.77777777777778.

When a whole number doesn't t in a cell, the number is displayed using scientic Â

notation. For example, 77777777777777777777 becomes 7.777778E+19.

Scientic 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 t, 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 dierent types of data are sorted in ascending or

descending order.

174 Chapter 10 Using Tables

1 2 ... 169 170 171 172 173 174 175 176 177 178 179 ... 246 247

Pas de commentaire

Apple Keynote Guide de l'utilisateur Page 174