An absolute cell reference
A) causes a potential error.
B) indicates a cell's specific location and the reference does not change when you copy the formula.
C) occurs when a formula directly or indirectly refers to the cell containing the formula.
D) contains both an absolute and a relative cell reference.

Question

Quizplus · Accepted Answer

An absolute cell reference in spreadsheet programs like Microsoft Excel locks the reference to a specific cell, so when you copy or move the formula to another cell, the reference remains the same. This is indicated by dollar signs in the cell reference, for example, $A$1.

An Absolute Cell Reference