Scribd
Upload
11 views3 pages

Understanding Absolute vs Relative References

This document contains two examples showing the difference between absolute and relative cell references in a spreadsheet. The first example is a graph with two equations plotted, where changing the constants in the equations results in both lines shifting together when using relative references, but only one line shifts when using absolute references. The second example is a table where changing the row number in a relative reference formula causes the result to change in every row, but it remains the same in an absolute reference formula.

Uploaded by

gudasan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
11 views3 pages

Understanding Absolute vs Relative References

This document contains two examples showing the difference between absolute and relative cell references in a spreadsheet. The first example is a graph with two equations plotted, where changing the constants in the equations results in both lines shifting together when using relative references, but only one line shifts when using absolute references. The second example is a table where changing the row number in a relative reference formula causes the result to change in every row, but it remains the same in an absolute reference formula.

Uploaded by

gudasan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Absolute References versus Relative references

m m
1 0.4 15
c c
0 2
10
x y1 y2
-10 -10 -2
-9 -9 -1.6 5
-8 -8 -1.2
-7 -7 -0.8
y1
-6 -6 -0.4 0
y2
-5 -5 0 -15 -10 -5 0 5 10 15
-4 -4 0.4
-3 -3 0.8 -5
-2 -2 1.2
-1 -1 1.6
-10
0 0 2
1 1 2.4
2 2 2.8 -15
3 3 3.2
4 4 3.6
5 5 4
6 6 4.4
7 7 4.8
8 8 5.2
9 9 5.6
10 10 6
### 2018
### 1985
33
6

Column1 Column2
1 45
1 76
1 654
2 34534
2 67
2 563
3 342
3 65
3 34563
4 7343
4 98
4 34563

You might also like