20090601
I
Ab
s
olute Cell Reference
s
An absolute cell reference is the one that does not change, regardless of where it is located
or where it is copied to or moved to. You can make both the row and column of a cell
reference absolute, or you can make only the row or only the column of a cell reference
absolute, as described below.
Thi
s
cell reference:
Doe
s
thi
s
:
$A$1
Always refers to column A, row 1
$A1
Always refers to column A, but the row changes dynamically when
moved, as with a relative cell reference
A$1
Always refers to row 1, but the column changes dynamically when
moved, as with a relative cell reference
Let’s say, for example, that a reference to cell A1 is in cell C1. The following shows what
each of the above cell references would become if the contents of cell C1 were copied to cell
D12.
$A$1
m
$A$1
$A1
m
$A12
A$1
m
B$1
S
To input a cell reference
(1) Select the cell where you want to insert the cell reference.
(2) Tap inside the edit box.
(3) If you are inputting new data, input an equal sign (=) first. If you are editing existing
data, make sure that its first character is an equal sign (=).
•
Inputting a cell name like “A3” without an equal sign (=) at the beginning will cause
“A” and “3” to be input as text, without referencing the data in cell A3.
13-4-7
Editing Cell Contents
Incorrect cell reference (no “=” sign)
Correct cell reference
Summary of Contents for ClassPad 330
Page 11: ...20060301 20090601 ClassPad 330 ClassPad OS Version 3 04 ...
Page 277: ...20060301 3 3 10 Storing Functions 3 Tap AND Plot OR Plot ...
Page 779: ...20090601 S Graph Line Clustered C S Graph Line Stacked E 13 9 2 Graphing ...
Page 780: ...20090601 S Graph Line 100 Stacked F S Graph Column Clustered G 13 9 3 Graphing ...
Page 781: ...20090601 S Graph Column Stacked I S Graph Column 100 Stacked J 13 9 4 Graphing ...
Page 782: ...20090601 S Graph Bar Clustered K S Graph Bar Stacked 9 13 9 5 Graphing ...
