Home » Casio Manuals » Calculators » Casio FX-9860GII-L-IH » Manual Viewer

Casio FX-9860GII-L-IH User Guide - Page 460

Using Cell References, Does

View all Casio FX-9860GII-L-IH manuals

Add to My Manuals
Save this manual to your list of manuals

Page 460 highlights

9-4-5 Inputting and Editing Cell Data k Using Cell References A cell reference is a symbol that references the value of one cell for use by another cell. If you input "=A1+B1" into cell C2, for example, the Spreadsheet will add the current value of cell A1 to the current value of cell B1, and display the result in cell C2. There are two types of cell references: relative and absolute. It is very important that you understand the difference between relative and absolute cell references. Otherwise, your spreadsheet may not produce the results you expect. Relative Cell References A relative cell reference is one that changes according to its location on the spreadsheet. The cell reference "=A1" in cell C2, for example, is a reference to the cell located "two columns to the left and one cell up" from the current cell (C2, in this case). If we copy the contents of cell C2 and paste them into cell D12, for example, the cell reference will change automatically to "=B11", because B11 is two columns to the left and one cell up from cell D12. Be sure to remember that relative cell references always change dynamically in this way whenever you move them using copy and paste. Important! When you copy a relative cell reference from the edit box, it is copied to the clipboard as text and pasted "as-is" without changing. If "=A1" is in cell C2 and you copy "=A1" from the edit box and paste it into cell D12, for example, D12 will also be "=A1". Absolute Cell References 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. This cell reference: $A$1 $A1 A$1 Does this: Always refers to column A, row 1 Always refers to column A, but the row changes dynamically when moved, as with a relative cell reference 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 → $A$1 $A1 → $A12 A$1 → B$1 20050401

Section	Page
BEFORE USING THE CALCULATOR FOR THE FIRST TIME...	3
Quick-Start	5
Quick-Start	6
TURNING POWER ON AND OFF	6
USING MODES	6
BASIC CALCULATIONS	7
REPLAY FEATURE	8
FRACTION CALCULATIONS	9
EXPONENTS	10
GRAPH FUNCTIONS	11
DUAL GRAPH	13
DYNAMIC GRAPH	14
TABLE FUNCTION	16
Precautions when Using this Product	17
Precautions when Connecting to a Computer	17
Handling Precautions	18
Contents	20
Getting Acquainted — Read This First!	24
Chapter 1 Basic Operation	26
1-1 Keys	27
1-2 Display	30
1-3 Inputting and Editing Calculations	35
1-4 Option (OPTN) Menu	51
1-5 Variable Data (VARS) Menu	53
1-6 Program (PRGM) Menu	57
1-7 Using the Setup Screen	58
1-8 Using Screen Capture	63
1-9 When you keep having problems…	64
Chapter 2 Manual Calculations	66
2-1 Basic Calculations	67
2-2 Special Functions	73
2-3 Specifying the Angle Unit and Display Format	81
2-4 Function Calculations	83
2-5 Numerical Calculations	95
2-6 Complex Number Calculations	108
2-7 Binary, Octal, Decimal, and Hexadecimal Calculations with Integers	113
2-8 Matrix Calculations	118
Chapter 3 List Function	140
3-1 Inputting and Editing a List	141
3-2 Manipulating List Data	149
3-3 Arithmetic Calculations Using Lists	157
3-4 Switching Between List Files	162
Chapter 4 Equation Calculations	163
4-1 Simultaneous Linear Equations	164
4-2 Quadratic and Cubic Equations	166
4-3 Solve Calculations	168
4-4 What to Do When an Error Occurs	170
Chapter 5 Graphing	171
5-1 Sample Graphs	172
5-2 Controlling What Appears on a Graph Screen	180
5-3 Drawing a Graph	190
5-4 Storing a Graph in Picture Memory	199
5-5 Drawing Two Graphs on the Same Screen	200
5-6 Manual Graphing	206
5-7 Using Tables	214
5-8 Dynamic Graphing	230
5-9 Graphing a Recursion Formula	238
5-10 Changing the Appearance of a Graph	248
5-11 Function Analysis	256
Chapter 6 Statistical Graphs and Calculations	278
6-1 Before Performing Statistical Calculations	279
6-2 Calculating and Graphing Single-Variable Statistical Data	283
6-3 Calculating and Graphing Paired-Variable Statistical Data	287
6-4 Performing Statistical Calculations	301
6-5 Tests	311
6-6 Confidence Interval	336
6-7 Distribution	347
Chapter 7 Financial Calculation (TVM)	369
7-1 Before Performing Financial Calculations	370
7-2 Simple Interest	372
7-3 Compound Interest	374
7-4 Cash Flow (Investment Appraisal)	378
7-5 Amortization	381
7-6 Interest Rate Conversion	384
7-7 Cost, Selling Price, Margin	385
7-8 Day/Date Calculations	386
Chapter 8 Programming	388
8-1 Basic Programming Steps	389
8-2 PRGM Mode Function Keys	391
8-3 Editing Program Contents	393
8-4 File Management	397
8-5 Command Reference	401
8-6 Using Calculator Functions in Programs	419
8-7 PRGM Mode Command List	431
8-8 Program Library	434
Chapter 9 Spreadsheet	444
9-1 Spreadsheet Overview	445
9-2 File Operations and Re-calculation	449
9-3 Basic Spreadsheet Screen Operations	452
9-4 Inputting and Editing Cell Data	456
9-5 S.SHT Mode Commands	477
9-6 Statistical Graphs	481
9-7 Using the CALC Function	487
9-8 Using Memory in the S.SHT Mode	491
Chapter 10 eActivity	496
10-1 eActivity Overview	497
10-2 Working with eActivity Files	505
10-3 Inputting and Editing eActivity File Data	508
10-4 Using Matrix Editor and List Editor	528
10-5 eActivity File Memory Usage Screen	530
Chapter 11 System Settings Menu	531
11-1 Using the System Settings Menu	532
11-2 System Settings	533
11-3 Version List	535
11-4 Reset	537
Chapter 12 Data Communications	539
12-1 Connecting Two Units	540
12-2 Connecting the Unit to a Personal Computer	541
12-3 Performing a Data Communication Operation	542
12-4 Data Communications Precautions	547
12-5 Image Transfer	550
12-6 Add-ins	553
12-7 MEMORY Mode	554
Appendix	571
1 Error Message Table	572
2 Input Ranges	576
3 Specifications	579
4 Key Index	581
5 P Button (In case of hang up)	584

Match case Limit results 1 per page

20050401

9-4-5

Inputting and Editing Cell Data

Using Cell References

A cell reference is a symbol that references the value of one cell for use by another cell. If

you input “=A1+B1” into cell C2, for example, the Spreadsheet will add the current value of

cell A1 to the current value of cell B1, and display the result in cell C2.

There are two types of cell references: relative and absolute. It is very important that you

understand the difference between relative and absolute cell references. Otherwise, your

spreadsheet may not produce the results you expect.

Relative Cell References

A relative cell reference is one that changes according to its location on the spreadsheet.

The cell reference “=A1” in cell C2, for example, is a reference to the cell located “two

columns to the left and one cell up” from the current cell (C2, in this case). If we copy the

contents of cell C2 and paste them into cell D12, for example, the cell reference will

change automatically to “=B11”, because B11 is two columns to the left and one cell up

from cell D12.

Be sure to remember that relative cell references always change dynamically in this way

whenever you move them using copy and paste.

Important!

When you copy a relative cell reference from the edit box, it is copied to the clipboard as

text and pasted “as-is” without changing. If “=A1” is in cell C2 and you copy “=A1” from

the edit box and paste it into cell D12, for example, D12 will also be “=A1”.

Absolute Cell References

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.

This cell reference:

Does this:

$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

→

$A$1

$A1

→

$A12

A$1

→

B$1