Question

it identifies the location on the worksheet ​

Answer 1

Explanation:

A reference to a specific cell or range of cells regardless of where the formula is located in the worksheet. An absolute cell reference uses a dollar sign in front of the column and row markers in a cell address.

Answer 2

Explanation:

I hope it will helps you