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

Working with individual cells, Creating absolute and relative cell references

Get Texas Instruments NS/CLM/1L1/B - NSpire Math And Science Handheld Graphing Calculator PDF manuals and user guides
UPC - 033317190256
View all Texas Instruments NS/CLM/1L1/B manuals
Add to My Manuals
Save this manual to your list of manuals

Page 106 highlights

• For numbers, text, and simple math expressions and formulas such as =a3¦length2, press the corresponding keys on the handheld keypad. In this example, press = A 3 r L E N G T H q. 5 ∑ • For more complex math expressions such as 1-- press k to n n=1 display the complete Catalog of system functions and commands, symbols, and expression templates. • To display only the list of templates, press / r. • To display only the list of symbols, press / k. Working with individual cells Creating absolute and relative cell references Cell references let you enter formulas that refer to spreadsheet data instead of having to duplicate it and remember to update it. When you change the contents of a referenced cell, all references to the data are updated automatically in the table. Anytime you want to update all references and formula results in the table, you can select Recalculate from the Actions menu (or press / R). Cell formulas begin with the = symbol. You refer to a cell by using its column letter and row number. Entering =3*C4 as a formula, for example, creates an expression that is 3 * the contents of the cell at column C, row 4. À Á 98 Using Lists & Spreadsheet

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
98
Using Lists & Spreadsheet
•
For numbers, text, and simple math expressions and formulas such as
=a3
¦
length
2
, press the corresponding keys on the handheld keypad.
In this example, press
=A3rLENGTHq
.
•
For more complex math expressions such as
press
k
to
display the complete Catalog of system functions and commands,
symbols, and expression templates.
•
To display only the list of templates, press
/r
.
•
To display only the list of symbols, press
/k
.
Working with individual cells
Creating absolute and relative cell references
Cell references let you enter formulas that refer to spreadsheet data
instead of having to duplicate it and remember to update it. When you
change the contents of a referenced cell, all references to the data are
updated automatically in the table.
Anytime you want to update all references and formula results in the
table, you can select
Recalculate
from the
Actions
menu (or press
/R
).
Cell formulas begin with the = symbol. You refer to a cell by using its
column letter and row number. Entering =3*C4 as a formula, for
example, creates an expression that is 3 * the contents of the cell at
column
C
, row
4
.
1
n
--
n
1
=
5
∑
Á
À