Ab$olute Reference$

An absolute cell reference is used when you want a cell reference to stay fixed on a specific cell.
This means that as a formula or function is copied and pasted to other cells, the cell references in the formula or function do not change.

That is what we used in our activity.

To have only one formula for many cells and gets the correct or the answer that you want, we use the dollar sign ($) to express the absolute reference.

Example is B$6 which means that only the column of the formula can change following the pattern.