What does the $ symbol do when placed before a column letter in a cell reference, such as $A1?
-
A
Locks the column so it doesn't change when the formula is copied
-
B
Locks both the row and column
-
C
Locks the row so it doesn't change
-
D
Converts the value to currency format