REVIEW

1

• REVIEW
• Excel
• Absolute vs. Relative
• Address

2
Relative vs. Absolute referencing

• When you create a formula, chances are you've
  referenced another cell within your formula. 
• This cell reference can either be a relative or
  an absolute reference or a mixed reference
• Relative reference A1
• Absolute reference - A1
• Mixed reference A1 or A1

3
Relative Reference

• Relative column reference and Relative row
  reference, a cell is entered in a formula without
  using the symbol
• We've created a formula in cell D1.  Then we've
  copied this formula to cells D2, E1, and E2.  As
  you can see, the original reference to cell A1
  has been readjusted.

4
Absolute Reference

• Absolute column reference and Relative row
  reference, a cell is entered in a formula using
  symbol
• We've created a formula in cell D1.  Then we've
  copied this formula to cells D2, E1, and E2.  As
  you can see, the original formula has stayed
  intact. (Press F4 key to make a reference
  absolute)

5
Mixed reference

• Absolute and relative reference can be mixed.
• absolute column with a relative row reference,
  for example A1 freeze column
• Relative column with an absolute row reference,
  for example A1 freeze row

6
Absolute Column and Relative Row

• We've creating a formula in cell D1.  Then we've
  copied this formula to cells D2, E1, and E2. 
  This time the reference to column A remains
  static while the reference to the row is
  readjusted.

7
Relative Column and Absolute Row

• We've creating a formula in cell D1.  Then we've
  copied this formula to cells D2, E1, and E2. 
  This time the reference to the column is
  readjusted with the row remains static.

8
Multiplication Table
9
Exercise Car Payment