42 – Which of the following cell references in a formula should be used for making sure that a column value does not change when copied?
A. A$2
B. $A2
C. !A2
D. A!2
Answer:A
42 – Which of the following cell references in a formula should be used for making sure that a column value does not change when copied?
A. A$2 B. $A2 C. !A2 D. A!2