Apple Keynote '08 Bedienungsanleitung Seite 135

  • Herunterladen
  • Zu meinen Handbüchern hinzufügen
  • Drucken
  • Seite
    / 204
  • Inhaltsverzeichnis
  • LESEZEICHEN
  • Bewertet. / 5. Basierend auf Kundenbewertungen
Seitenansicht 134
Chapter 7 Using Formulas and Functions in Tables 135
Heres a formula that adds the values in nine cells of the first column: SUM(A2:A10).
There is one argument, A2:A10. The colon means the function should use the values
in cells A2 through A10.
Adding a Quick Formula
An easy way to perform a basic calculation using values in a range of adjacent table
cells is to add a quick formula using the Quick Formula pop-up menu on the Format
pane of the Table Inspector.
You can also choose Insert > Function and use the submenu that appears.
Here are operations you can perform using the Quick Formula pop-up menu or
submenu:
m Choose one of the following to perform calculations using values in the selected cells.
Empty cells and cells containing values that aren’t mentioned are ignored.
Sum: Totals numeric values in the cells.
Average: Calculates the arithmetic mean of numeric values in the cells.
Min: Determines which numeric value in the cells is the smallest.
Max: Determines which numeric value in the cells is the largest.
Count: Determines how many of the values in the cells are numeric or date/time
values.
Product: Multiplies all the numeric values in the cells.
m Choose Insert > Function > More Functions to open the Function Browser. See “Using
Functions” on page 143 for details about this tool.
m Choose Formula Editor to open the Formula Editor. See “Using the Formula Editor” on
page 137 for instructions.
Seitenansicht 134
1 2 ... 130 131 132 133 134 135 136 137 138 139 140 ... 203 204

Kommentare zu diesen Handbüchern

Keine Kommentare