Chapter 5: working with table styles, Chapter 6: using formulas in tables, Chapter 7: creating charts from data – Apple Numbers '09 User Manual

Page 6

Advertising
background image

6

Contents

113

Reordering, Renaming, and Deleting Custom Cell Formats

114

Chapter 5: Working with Table Styles

114 Using Table Styles
115 Applying Table Styles
115 Modifying Table Style Attributes
116 Copying and Pasting Table Styles
116 Using the Default Table Style
116 Creating New Table Styles
117 Renaming a Table Style
117 Deleting a Table Style

118

Chapter 6: Using Formulas in Tables

118 The Elements of Formulas
119 Performing Instant Calculations
120 Using Predefined Quick Formulas
121 Creating Your Own Formulas
122

Adding and Editing Formulas Using the Formula Editor

123

Adding and Editing Formulas Using the Formula Bar

124

Adding Functions to Formulas

126

Handling Errors and Warnings in Formulas

126 Removing Formulas
126 Referring to Cells in Formulas
128

Using the Keyboard and Mouse to Create and Edit Formulas

129

Distinguishing Absolute and Relative Cell References

130 Using Operators in Formulas
130

The Arithmetic Operators

130

The Comparison Operators

131 Copying or Moving Formulas and Their Computed Values
132 Viewing All Formulas in a Spreadsheet
132 Finding and Replacing Formula Elements

134

Chapter 7: Creating Charts from Data

134 About Charts
137 Creating a Chart from Table Data
138

Changing a Chart from One Type to Another

139

Moving a Chart

140

Switching Table Rows and Columns for Chart Data Series

140

Adding More Data to an Existing Chart

141

Including Hidden Table Data in a Chart

141

Replacing or Reordering Data Series in a Chart

142

Removing Data from a Chart

143

Deleting a Chart

Advertising