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

Inserting items from the Catalog

Page 107 highlights

À Formula containing a cell reference entered in cell D4 Á Result of formula (3*12=36) You can refer to a rectangular block of cells in a formula by entering the location of the upper-left cell and the lower-right cell, separated by a colon. For example, =mean(B1:C5)*1. creates a result that is the mean of all cells in the block bounded by columns B through C and rows 1 through 5. To force the results of an expression to a decimal approximation, you multiply by "1." ÀÁ À Formula that refers to a rectangular block of cells Á Result of formula References such as C4 and C4:E11 are relative references. These references describe a cell in relation to other cells. Lists & Spreadsheet keeps track of relative cell references. It adjusts each reference automatically when you copy or move the cell containing the reference to another location in the spreadsheet. If you need a reference that always refers to a cell in a specific location in the spreadsheet, use an absolute reference. To create an absolute cell reference, type a $ symbol before the column letter and row number. The $ symbol is available in the Symbol Palette (/k). For example, type $C$4 to create an absolute reference to the cell in column C, row 4. Lists & Spreadsheet does not adjust absolute references in a formula when you copy or move the cell containing the reference. Inserting items from the Catalog You can use the Catalog to insert system functions and commands, symbols, and expression templates into a cell formula. Using Lists & Spreadsheet 99

  • 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

Using Lists & Spreadsheet
99
À
Formula containing a cell reference entered in cell D4
Á
Result of formula (3*12=36)
You can refer to a rectangular block of cells in a formula by entering the
location of the upper-left cell and the lower-right cell, separated by a
colon.
For example,
=mean(B1:C5)*1.
creates a result that is the mean of all cells
in the block bounded by columns
B
through
C
and rows
1
through
5
. To
force the results of an expression to a decimal approximation, you
multiply by “1.”
À
Formula that refers to a rectangular block of cells
Á
Result of formula
References such as
C4
and
C4:E11
are
relative
references. These
references describe a cell in relation to other cells. Lists & Spreadsheet
keeps track of relative cell references. It adjusts each reference
automatically when you copy or move the cell containing the reference
to another location in the spreadsheet.
If you need a reference that always refers to a cell in a specific location in
the spreadsheet, use an
absolute
reference. To create an absolute cell
reference, type a $ symbol before the column letter and row number. The
$ symbol is available in the Symbol Palette (
/k
).
For example, type $C$4 to create an absolute reference to the cell in
column C, row 4. Lists & Spreadsheet does not adjust absolute references
in a formula when you copy or move the cell containing the reference.
Inserting items from the Catalog
You can use the Catalog to insert system functions and commands,
symbols, and expression templates into a cell formula.
Á
À