20050401
2. Press
2
(EDIT)
3
(CELL).
• This will enter the edit mode, which is indicated by
the cell contents in the edit box changing to flush
left. The input cursor also will appear to the left of
the first character of the edit box.
3. Edit the data in the edit box.
4. After everything is the way you want, press
w
.
• If “Auto Calc” is turned on (page 1-7-5), all of the formulas in the spreadsheet will be
re-calculated when you press
w
.
• To cancel data input, press
J
. This will return the cell contents to what they were
before you started editing them.
k
k
k
k
k
Inputting a Formula
A formula is an expression that the
S
•
SHT
mode calculates and evaluates when you input it,
when data related to the formula is changed, etc.
A formula always starts with an equal sign (=), and can contain any one of the following.
• Values
• Mathematical expressions
• Cell references
• Calculator built-in function commands (page 2-4-1)
•
S
•
SHT
mode commands (page 9-5-1)
If “Auto Calc” is turned on (page 1-7-5), formulas are calculated dynamically whenever
related values are changed, and the latest result is always displayed in the spreadsheet.
The following shows a simple example where a formula in cell B5 calculates the average of
the values in cells B1 through B3.
9-4-3
Inputting and Editing Cell Data
Summary of Contents for fx-9860G AU PLUS
Page 1: ...fx 9860G AU User s Guide E http edu casio com ...
Page 2: ...Important Please keep your manual and all information handy for future reference ...
Page 27: ...20050401 1 1 Keys 1 1 1 Keys ...
Page 335: ...20050401 u u u u u Input Example u u u u u Results 6 5 25 Tests ...
Page 361: ...20050401 Calculation Result Output Example p F distribution probability 6 7 15 Distribution ...
Page 435: ...20050401 8 8 2 Program Library egcw w ww w ...
Page 437: ...20050401 8 8 4 Program Library Example 1 Example 2 fw baw bf w fw baw ca w ...
Page 439: ...20050401 8 8 6 Program Library wba wb w w d ...
Page 441: ...20050401 8 8 8 Program Library dw fcde wfcde wfcde fcde w daw w 20070101 ...
Page 443: ...20050401 8 8 10 Program Library b awaw bwaw aw x d w ...
Page 590: ...CASIO COMPUTER CO LTD 6 2 Hon machi 1 chome Shibuya ku Tokyo 151 8543 Japan SA0701 E ...