Understanding+relative+and+Absolute+cell+references

Understanding relative and Absolute Cell reference

 * ====Use a relative cell reference when you want to preserve the relationship to the formula locations.====
 * ====Calculations are performed based on cell relationship.====
 * ====When a formula is copied, the cell reference changes to preserve the relationship of the formula to the referenced cells.====
 * ====The excell default====
 * ====Use an absolute cell reference when you want to preserve the exact cell address in a formula====
 * Reference does not change even if the formula is copied to another location.
 * Created by placing a dollar sign ($) before both the column letter and the row number for the cell's address

Using a mixed cell reference:

 * A mixed cell reference combines both relative and absolute cell referencing, For example: when you copy a formula, you may want to change the row reference but to keep the column reference
 * ====It is created by using the F4 function button====