# 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

The value of cell B1 is copied only once, further changes in value of A1 will not effect the value of B1