Using a $ sign before a column label .
A) keeps the reference to both the row and column fixed
B) keeps the reference to the row fixed, but allows the column reference to change
C) keeps the reference to column fixed, but allows the row reference to change
D) allows both the row and column references to change

Question

Quizplus · Accepted Answer

Using a $ sign before a column label in a cell reference keeps the column reference fixed while allowing the row reference to change when copying the formula to another cell.

Using a $ Sign Before a Column Label