2
Table Of Contents
- User’s Guide
- Contents
- Welcome to Pages
- Overview of Pages
- Creating a Document Using the Pages Templates
- Formatting a Document’s Layout and Table of Contents
- Setting Page Orientation and Size
- Setting Page Margins
- Creating Columns
- Varying Column and Page Layouts
- Creating a Document With Left- and Right-Facing Pages
- Adding Headers, Footers, Page Numbers, Footnotes, and Endnotes
- Varying Document Formatting Using Section Breaks
- Adding a Repeated Background Image
- Using a Table of Contents
- Formatting Text and Paragraphs
- Working With Styles
- Working With Graphics andOther Media
- Changing Object Properties
- Creating Tables
- Adding a Table
- Using Table Cells and Borders
- Formatting Tables
- Adding Images or Background Colors
- Formatting Numbers
- Sorting Cells
- Autofilling
- Using Formulas
- A Tour of Using Formulas
- Adding a Quick Formula
- Removing a Formula
- Using the Formula Editor to Add and Edit Formulas
- Using Cell References
- Adding a Formula to Multiple Cells
- Performing Arithmetic Operations
- Using Predefined Functions
- Operators and Functions for Advanced Table Formula Users
- Defining Formulas That Use Operators
- Defining Formulas That Use Functions
- Creating Charts
- Personalizing Documents With Address Book Data
- Printing and Exporting Your Document to Other Formats
- Designing Your Own Document Templates
- Index
186 Chapter 8 Creating Tables
8 Cells E11 and E12 also contain formulas. Examine the formulas in these cells by clicking
outside the table, selecting the table, then double-clicking cell E11 or E12. Cell E11
contains a formula that computes sales tax, and cell E12 contains a formula that sums
the subtotal and the sales tax.
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 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 Formula pop-up menu.
Pages places the formula and its result in the first empty cell beneath the selected
cells. If there is no empty cell, Pages 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 formula.