In the Reference $C14, ____

Multiple Choice

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