beautypg.com

K referencing a particular cell – Casio SERIES FX-9860G User Manual

Page 464

background image

20070201

9-4-6

Inputting and Editing Cell Data

k Referencing a Particular Cell

The following procedure shows how to reference A1 (which contains the value 3) and
perform the calculation A1

× 2.

u To reference a particular cell

1. Move the cell cursor to cell A2, and then input

!.(=).

2. Press

1(GRAB).

• This enters the Grab mode, which changes

the function menu to the function described
below. The Grab mode function menu
makes it easier to move the cursor around
the spreadsheet.

To move the cell cursor to here:

Press this key:

A specifi c cell

2(GO)

Line 1 of current column

3(TOP ↑)

Column A of current line

4(TOP ←)

Bottom line of current column

5(BOT ↓)

Column Z of current line

6(BOT →)

3. Press

f to move the cell cursor to cell A1.

4. Press

1(SET).

• This inputs the reference to cell A1.

# Instead of using the GRAB command

(

1(GRAB) in step 2), you could also type in

the necessary letter and number manually, if
you want. In place of steps 2 through 4 in the

above procedure, you could input

av(A)b

to type “A1” if you want. For more information, see
“Formula Input Example” (page 9-4-4).