

McqMate
Q. |
If the cell B1 contains the formula = $A$1, which of the following statements is true |
A. | There is a relative reference to cell A1 |
B. | There is an absolute reference to cell A1 |
C. | Further changes in value of A1 will not affect the value of B1 |
D. | Further changes in value of B1 will affect the value of A1 |
Answer» B. There is an absolute reference to cell A1 |
View all MCQs in
Microsoft Excel (MS Excel)No comments yet