User Guide

6 Contents
111 Chapter 5: Working with Table Styles
111 Using Table Styles
112 Applying Table Styles
112 Modifying Table Style Attributes
113 Copying and Pasting Table Styles
113 Using the Default Table Style
114 Creating New Table Styles
114 Renaming a Table Style
114 Deleting a Table Style
115 Chapter 6: Using Formulas in Tables
115 The Elements of Formulas
116 Performing Instant Calculations
117 Using Predened Quick Formulas
11 8 Creating Your Own Formulas
119 Adding and Editing Formulas Using the Formula Editor
120 Adding and Editing Formulas Using the Formula Bar
121 Adding Functions to Formulas
12 3 Handling Errors and Warnings in Formulas
123 Removing Formulas
123 Referring to Cells in Formulas
125 Using the Keyboard and Mouse to Create and Edit Formulas
12 6 Distinguishing Absolute and Relative Cell References
127 Using Operators in Formulas
127 The Arithmetic Operators
127 The Comparison Operators
128 Copying or Moving Formulas and Their Computed Values
129 Viewing All Formulas in a Spreadsheet
130 Finding and Replacing Formula Elements
131 Chapter 7: Creating Charts from Data
131 About Charts
134 Creating a Chart from Table Data
135 Changing a Chart from One Type to Another
136 Moving a Chart
137 Switching Table Rows and Columns for Chart Data Series
137 Adding More Data to an Existing Chart
138 Including Hidden Table Data in a Chart
138 Replacing or Reordering Data Series in a Chart
139 Removing Data from a Chart
140 Deleting a Chart
140 Sharing Charts with Pages and Keynote Documents
140 Formatting Charts