When is it appropriate to use an absolute reference?
when the information in a formula always relates to the same cell
when the information in a formula changes to relate to the cells next to the specified location
when the value of a specified cell must remain a positive number
when the value of a specified cell must be the same as the value of the cell immediately preceding it
