To create an absolute reference, insert ____.
A)a dollar sign before the column reference
B)a dollar sign before the row reference
C)both a.and b.
D)neither a.nor b.

Question

Quizplus · Accepted Answer

To create an absolute reference, we need to insert a dollar sign before the column reference and before the row reference. This allows us to lock the cell reference in a formula so that it always refers to the same cell, even when the formula is copied to other cells. The dollar sign before the column reference fixes the column reference and the dollar sign before the row reference fixes the row reference.

To Create an Absolute Reference, Insert ____