Question: which of these is an absolute cell reference?
Answer: Using Absolute Cell References. ... An absolute cell reference is a cell address that contains a dollar sign ($) in the row or column coordinate, or both. When you enter a cell reference in a formula, Excel assumes it is a relative reference unless you change it to an absolute reference.