In the reference $C14, ____.
A) both the column letter and the row number would be updated relative to their location
B) the column letter would not change, but the row number would be updated relative to its location
C) the column letter would be updated relative to its location, but the row number would not change
D) neither the column letter nor the row number would change

Question

Quizplus · Accepted Answer

In Excel, references with the format of C14 are relative references. This means that when the reference is copied to another location, the column letter would not change, but the row number would be updated relative to its location. For example, if C14 is copied to the cell below it, the reference would become C15.

In the Reference $C14, ____