Home » Texas Instruments Manuals » Calculators » Texas Instruments NS/CLM/1L1/B » Manual Viewer

Texas Instruments NS/CLM/1L1/B User Guide - Page 105

Navigating in a spreadsheet, Methods of entering table data

UPC - 033317190256

View all Texas Instruments NS/CLM/1L1/B manuals

Add to My Manuals
Save this manual to your list of manuals

Page 105 highlights

Navigating in a spreadsheet You can select any cell to view or edit its contents. When a spreadsheet is larger than the Lists & Spreadsheet work area, you can view different parts of the spreadsheet by: • Pressing and ¤ to move through the spreadsheet. This moves the selection from cell to cell and scrolls as necessary to keep the selected cell in view. • Using the Go To command on the Actions menu to select a specific cell. Type the cell's column letter and row number (such as G16). A column letter appears at the top of each column, and a row number appears in the left cell of each row. The top two rows and the left column of the spreadsheet remain in place as you scroll so you can more easily determine your location. À Ã Á Ä Â À Column reference Á Header or formula row Â Row reference Ã Column/list name Ä Cells Methods of entering table data The method you use to enter spreadsheet data depends on the type of data and your personal preferences. You can use different methods in combination. Using Lists & Spreadsheet 97

Section	Page
Important Information	2
FCC Statement	2
Introduction	9
The TI-Nspire™ math and science learning handheld	9
How to use this guidebook	9
Where to find more information	10
Getting Started	11
Dual Keypads	11
Changing the keypad	12
TI-Nspire™ handheld keys	13
Keyboard shortcuts	14
Initial startup	15
Replacing batteries	15
Battery Precautions	15
Additional precautions for rechargeable batteries	16
For proper disposal of used batteries	16
Adjusting the contrast	16
Turning the handheld on and off	16
Automatic Power Down	16
Turning on your TI-Nspire™ handheld for the first time	16
Choosing a language	17
Choosing a font size	17
The Home menu	18
Using the Home menu	18
The TI-Nspire™ handheld screen	19
Viewing status information	20
Viewing system settings	20
Document settings	21
Document settings Options	21
Changing document settings	22
System settings	22
Changing system settings	23
Handheld status	23
Checking available memory	24
Freeing Memory	24
Deleting items from memory	24
Using connection cables	25
USB cables	25
TI-84 Plus Mode cables	25
Backing up files to another handheld	26
Connecting two TI-Nspire™handhelds with the USB unit-to- unit cable	26
Sending a document	26
Connecting a TI-Nspire™ with TI-84 Plus Keypad to a TI-84 Plus handheld	26
Connecting the TI-Nspire™ handheld to a computer	27
Upgrading the Operating System	27
Important Operating System download information	27
Where to get Operating System upgrades	27
Backing up files to a computer	28
Resetting the memory	28
Displaying the About screen	29
Viewing Hints	29
Using the catalog	30
Opening the catalog	30
Using Wizards	31
Entering special characters	31
Entering Math expressions	31
Entering international language characters	32
Working with Documents	33
Documents	33
Page Sorter	33
My Documents	34
Creating documents	34
Creating a blank document	34
Adding an application	35
Creating a document with an application	35
Working with applications	36
Application menu	36
Using the Application menu	36
Context menu	37
Using the Context menu	37
Page Tools menu	38
Using the Page Tools menu	38
Changing the page layout	38
Choosing a standard layout	38
Creating a custom layout	40
Repositioning applications on a page	41
Swapping applications	41
Adding a problem to a document	42
Adding a page to a problem	42
Moving through pages in a document	43
Saving a document	43
Viewing and reordering pages in a document	44
Opening the Page Sorter from a document	44
Reordering pages in a problem	45
Copying a page to another problem	46
Copying a page to another document	46
Document settings	47
Changing document settings	47
Managing documents	49
Opening My Documents	49
Expanding folders	50
Expanding all folders	50
Renaming folders or documents	50
Collapsing folders	51
Creating folders	51
File and folder naming conventions	51
Duplicating documents and folders	52
Recovering deleted documents	52
Linking values on pages	53
Creating TI-Nspire™ variables	53
Special considerations for variables	55
Checking a variable’s value using the Calculator application	57
Using (linking) TI-Nspire™ variables	57
Removing a linked variable	59
Libraries	60
Program Editor	61
Sending a document to another handheld	61
Rules for sending files	61
Sending a document	61
Receiving a document	62
Canceling a transfer	62
Using Calculator	63
Getting started with the Calculator application	63
Before you begin	68
Entering and evaluating math expressions	68
Options for entering expressions	68
Entering simple math expressions	68
Controlling the form of a result	69
Inserting items from the Catalog	70
Using an expression template	71
Editing Calculator expressions	72
Positioning the cursor in an expression	72
Inserting into an expression in the entry line	72
Selecting part of an expression	73
Deleting all or part of an expression on the entry line	73
Working with the Calculator history	73
Viewing the Calculator history	73
Reusing a previous expression or result	74
Deleting an expression from the history	74
Clearing the Calculator history	75
Where to find more information	75
Using Graphs & Geometry	77
The toolbar	77
The work area	87
The graphing view	87
The plane geometry view	87
The analytic window	88
To remove the analytic window from the work area	88
Creating and manipulating axes	90
Drawing a circle	92
The entry line	93
Graphing inequalities	94
Finding points of interest: zeroes, minima, maxima	95
Animating objects	96
Animating one point on an object	96
The animation control panel	97
Resetting animation	97
Stopping animation	97
Creating a Scatter Plot	98
More Information	99
Using Lists & Spreadsheet	101
Getting started with tables	101
Navigating in a spreadsheet	105
Methods of entering table data	105
Working with individual cells	106
Creating absolute and relative cell references	106
Inserting items from the Catalog	107
Deleting the contents of a cell or block of cells	109
Copying a cell or block of cells	109
Filling adjacent cells	110
Working with rows and columns of data	111
Selecting a row or column	111
Resizing a row or column	111
Inserting an empty row or column	111
Deleting entire rows or columns	112
Copying rows or columns	112
Moving a column	113
Using Data & Statistics	115
The Tool menu	116
Working with Data & Statistics	120
Creating plots from spreadsheet data	120
Plotting data from Lists & Spreadsheet	120
Creating a split page with Data & Statistics and Lists & Spreadsheet	122
More Information	123
Using Notes	125
Getting started with the Notes application	125
The Notes tool menu	126
Before you begin	127
The Notes work area	127
Notes templates	127
Applying a Notes template	128
Using the Q&A Template	128
Using the Proof Template	128
Inserting comments	129
Formatting Notes text	129
Selecting text	129
Applying a text format	129
Inserting geometric shape symbols	130
Entering and evaluating expressions	130
Entering an expression	131
Evaluating an expression	131
Data Collection	133
Compatible sensors	133
Starting the Data Collection tool	133
Data Collection controls	134
Running an experiment and collecting data	134
Data Collection names	134
Storing collected data	135
To save temperature data	135
To save motion data	135
Appendix: Service and Support	137
Texas Instruments Support and Service	137
For general information	137
Service and warranty information	137
Service	137
Battery Precautions	137
Disposing of Batteries	138
Index	139
A	139
B	139
C	139
D	140
E	140
F	140
G	141
H	141
I	141
K	141
L	141
M	141
N	141
O	142
P	142
Q	142
R	142
S	142
T	143
U	143
V	143
W	144
X	144