Test: MS Excel 2003 Test
Question 1: Prev Next
|Which of the following statements is true if the cell B1 contains the formula =$A$1|
The value of cell B1 contains the same number of characters as the value of cell B2
There is an absolute reference to cell A1 so that the formula =$A$1 can be copied to other cells without changing the reference to A1
There is a relative reference to cell A1 so the formula will change each time it is copied to other cells
Please login to submit your answer.
The value of cell B1 is copied only once, further changes in value of A1 will not effect the value of B1