[tex]computer[/tex]

1. Cell reference

a. Address of the cell
b. Column letter and row number of the cell
c. Constant data
d. Example: A8

2. Cell referencing

a. Finds the data you want to use in a formula
b. Means giving cells a label or an address
c. Has three types : relative , absolute and mixed
d. Means computing for formulas in a given cell

3. Relative referencing

a. Copies the original formula exactly
b. Referring to cells using only their column and row labels
C. Cell addresses will be changed relative to the row and column to where they are
moved.
d. E5=C5+D5 will become E6=C6+D6 when copied from cell E5 to E6.

4. Absolute referencing

a. Means that the formula will not change even after you copy it to another cell
b. Used when you want to copy a formula to another cell and you want the cell
references to change.
C. Copies the original formulas exactly
d. Uses dollar signs before the column and row of both cells.

5. Mixed Referencing

a. Used when you want to either the row or column to be absolute
b. Uses dollar sign on either a row or column
C. E5=C$5+$D5 will become E7=C$5+$D7 when moved from cell E5 to E7.
d. Does not use dollar sign​