08
Table Of Contents
- User’s Guide
- Contents
- Welcome to the KeynoteUser’sGuide
- Keynote Tools and Techniques
- Working with a Keynote Document
- Working with Text
- Adding Text
- Selecting Text
- Deleting, Copying, and Pasting Text
- Formatting Text Size and Appearance
- Adjusting Font Smoothing
- Setting Text Alignment, Spacing, and Color
- Setting Tab Stops to Align Text
- Setting Indents
- Using Bulleted, Numbered, and Ordered Lists (Outlines)
- Using Text Boxes and Shapes to Highlight Text
- Using Hyperlinks
- Automatically Substituting Text
- Inserting a Nonbreaking Space
- Checking for Spelling Mistakes
- Finding and Replacing Text
- Working with Sound, Movies, Graphics, andOther Objects
- Selecting Objects
- Copying or Duplicating Objects
- Deleting Objects
- Moving Objects
- Modifying Objects
- Grouping and Locking Objects
- Filling Objects
- Using Shapes
- Using Media Placeholders
- Working with Images
- Using Sound and Movies
- Adding Web Views
- Making an Object a Hyperlink
- Using Motion in Slideshows
- Adding Transitions Between Slides
- Animating Slides with Object Builds
- Moving Objects on or off Slides Using Build Effects
- Animating Objects on Slides (Action Builds)
- Making Objects Fade, Rotate, Grow, or Shrink
- Animating Images Using Smart Builds
- Reordering Object Builds
- Activating Object Builds
- Creating Builds That Interleave an Object’s Parts
- Animating Specific Kinds of Objects
- Deleting Object Builds
- Using Tables
- About Tables
- Working with Tables
- Selecting Tables and Their Components
- Working with Content in Table Cells
- Working with Rows and Columns
- Working with Table Cells
- Sorting Table Cells
- Using Formulas and Functions inTables
- Using Charts
- About Charts
- Adding a Chart
- Selecting a Chart Type
- Editing Chart Data
- Formatting General Chart Attributes
- Formatting Specific Types of Charts
- Viewing, Printing, and ExportingYour Slideshow
- Customizing a Presentation for an Audience
- Rehearsing and Viewing Presentations
- Adding Presenter Notes
- Rehearsing Your Presentation
- Viewing a Presentation on Your Computer’s Display
- Viewing a Presentation on an External Display or Projector
- Viewing the Same Presentation on Two Screens
- Customizing the Presenter’s View
- Setting the Screen Refresh Rate
- Setting the Slide Size
- Configuring Video Random Access Memory (VRAM)
- Controlling Presentations
- Printing Your Slides
- Exporting a Slideshow to Other Formats
- Designing Your Own MasterSlidesand Themes
- Index
Chapter 7 Using Formulas and Functions in Tables 135
Here’s 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.