An absolute reference fixes a row and a column with the $ sign and stays identical when copied. A mixed reference fixes only one of the two. The F4 key toggles between the forms. It is used to point to a single rate or parameter.
Example
=B2*$F$1 keeps the rate in cell F1 when the formula is copied.