Question:Which of the following statements are true if the cell B1 contains the formula =$A$1?
A The value of cell B1 contains the same number of characters as the value of cell B2.
B 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.
C There is a relative reference to cell A1 so the formula will change each time it is copied to other cells.
D The value of cell B1 is equal to the value of the function in cell A1.
+ AnswerB D
+ Report