Cell Referencing

In Module $3$ we learned about relative and absolute cell references. Explain the difference between the two. Give problems$/$examples dearly describing and showing if necessary, when each type of cell referencing would be appropriate to help solve a probler$($s$).$ Be thorough in your responses.