Manual

Creating Notes .................................................................. 81
Changing the Appearance of a Spreadsheet ............................................ 82
Adjusting Column Width and Row Height .......................................... "82
Changing Alignment ............................................................. 83
Using Different Text Styles ........................................................ 84
Working with Formulas .............................................................. 85
Entering Formulas ..................... : ......................................... 85
Using References in Formulas ..................................................... 86
Using Operators in Formulas ...................................................... 88
' Using Built-in Functions in Formulas ............................................... 88
Spreadsheet's Built-in Functions ................................................... 91
Editing the Spreadsheet ............................................................. 93
Editing the Contents of a Cell ...................................................... 93
Copying and Moving Information .................................................. 94
Inserting and Deleting Rows and Columns .......................................... 96
Filling a Range of Cells with Incremental Values ..................................... 97
Options for Spreadsheet Formulas ................................................... 98
Showing and Hiding Formulas .................................................... 98
Naming Cells and Ranges ......................................................... 98
Controlling Automatic Recalculation .............................................. 100
Using Iteration and Circular References ............................................ 101
Charting in Spreadsheet .. ; ......................................................... 102
What Is a Chart? ................................................................ 102
Types of Charts ................................................................. 103
Creating-Charts ..................... .._.. .... . ....................................... 108
Changing the Type Of Chart .......... "_ " 108
Manipulating Charts ............................................................ 109
Resizing and Moving a Chart ..................................................... 109
Changing Chart Properties and Attributes .......................................... 110
Deleting a Chart ................................................................ 110
Using a Chart in Another Program ................................................ 110
Adding Titles and a Legend ...................................................... 111
Changing Markings ............................................................. 112
Changing Marker Shapes ........................................................ 114
Using Additional Spreadsheet Features ..................... . ........................ 114
Sorting ........................................................................ 11.4
Creating Number and Date Formats ............................................... 116
Using Rulers ................................................................... 117
Adding Graphics ...................... ...: ...................................... 117
Locking Titles .................................................................. 118
Using Spreadsheet with Other Programs ........................................... 118
Printing and Faxing ................................................................ 119
Setting Page Setup Options ....................................................... 119
Printing and Faxing Spreadsheets and Charts ....................................... 120
Contents iii