viii
Using Lists & Spreadsheet.................................................. 171
Getting started with tables........................................................171
Before you begin .................................................................175
Navigating in a spreadsheet ...............................................175
Inserting a cell range into a formula..................................176
Methods of entering data...................................................178
Entering a math expression, text, or spreadsheet
formula...........................................................................179
Working with individual cells ....................................................180
Creating absolute and relative cell references ..................180
Inserting items from the Catalog .......................................181
Deleting the contents of a cell or block of cells ................182
Copying a cell or block of cells ...........................................183
Filling adjacent cells ............................................................184
Sharing a cell value as a variable........................................185
Linking a cell to a variable..................................................185
Preventing name conflicts...................................................186
Working with rows and columns of data..................................187
Selecting a row or column ..................................................187
Resizing a row or column....................................................187
Inserting an empty row or column.....................................188
Deleting entire rows or columns ........................................188
Copying rows or columns....................................................189
Moving a column.................................................................190
Sorting data ................................................................................191
Sorting a range of cells in a column...................................191
Sorting a rectangular region ..............................................192
Sorting entire columns........................................................193
Generating columns of data ......................................................194
Creating column values based on another column...........195
Generating a list of random numbers................................196
Generating a numerical sequence......................................196
Creating and sharing spreadsheet data as lists.........................198
Sharing a spreadsheet column as a list variable................198
Linking to an existing list variable......................................201
Inserting an element in a list ..............................................201
Deleting an element from a list..........................................201
Graphing spreadsheet data........................................................202
Capturing data from Graphs & Geometry.................................204
Capturing data manually ....................................................204
Capturing data automatically.............................................206
Creating function tables.............................................................207
Showing and Hiding function tables..................................208
Generating a function table ...............................................209
Adding a function table from Graphs & Geometry...........210
To Next Page
Loading...
Need help?
General
Weight and Dimensions
