What are relative, mixed and absolute cell references?
C2, B3, and C4 in formulas above are relative cell references. Relative cell references are basic cell references that adjust and change when copied. Sometimes Other times it is necessary to keep the column or the row position (but not both) relative to the new cell location. You do so by placing a $ before the column letter (i.e. keep the column letter the same) or a $ before the row number (keep the row number the same), but not both. This is called Mixed Reference. Sometimes it is necessary to keep a certain position that is not relative to the new cell location. This is possible by inserting a $ before the column letter and a $ before the row number. This is called Absolute Reference. Copy the formula in Cell D6 to D3. What do you get in D3? Why?
