UpTest > Computer Skills > MS Excel 2003 Test

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
Please login to submit your answer.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24