Question

Using a $ sign before a column label ________.

Answer 1

Answer:

The alignment of the choices are off but here's the explanation for solving this question below;

Explanation:

Using a $ sign before a column label, keeps the reference to column fixed,

but allows the row reference to change. Generally, putting a dollar sign ($) before a column label or row label  puts an absolute reference to that respective column or row while keeping the other changing. For example;

In $C5, "C"  is the column reference while "5" is the row reference. Because there is $ sign before C, that column  will be fixed and the row will change