An excel user should use a relative cell reference when it is important to preserve the relationship to the formula location. When you create a formula that references other cells, excel does not normally "record" the exact cell address. Instead, it looks at the at the relationship that cell has to the other cell containing the formula.
