beautypg.com

Apple Numbers '08 User Manual

Page 6

background image

6

Contents

86

Performing Instant Calculations

87

Adding a Quick Formula

87

Performing a Basic Calculation Using Column Values

88

Performing a Basic Calculation Using Row Values

88

Removing a Formula

88

Using the Formula Editor

89

Adding a New Formula with the Formula Editor

89

Editing a Formula with the Formula Editor

90

Using the Formula Bar

90

Adding a New Formula with the Formula Bar

91

Editing a Formula with the Formula Bar

91

Using Cell References

91

Adding Cell References to a Formula

92

Copying or Moving Formulas with Cell References

93

Applying a Formula Once to Cells in a Column or Row

93

Handling Errors and Warnings

94

Using Operators

94

Performing Arithmetic Operations

95

Understanding the Arithmetic Operators

96

Understanding the Comparison Operators

96

Using Functions

Chapter 6

98

Using Charts

98

About Charts

101

Adding a Chart

102

Editing Charts

103

Changing the Plotting Orientation

103

Changing the Data Plotted in a Chart

103

Adding Data to a Chart

104

Adding Data to a Chart from Multiple Tables

104

Removing Data from a Chart

105

Replacing a Data Series

105

Deleting a Chart

105

Moving a Chart

105

Changing a Chart from One Type to Another

106

Formatting General Chart Attributes

106

Using a Legend

107

Using a Chart Title

107

Resizing a Chart

107

Rotating Charts

108

Adding Labels and Axis Markings

108

Showing Axes and Borders