Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 19 views

    Absolute References Versus Relative References

    Uploaded by

    gudasan
    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.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Absolute References Versus Relative References

    Uploaded by

    gudasan
    19 views3 pages
    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.

    Original Description:

    excel training examples

    Original Title

    Excel Training Examples

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    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.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    19 views3 pages

    Absolute References Versus Relative References

    Uploaded by

    gudasan
    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.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 3

    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