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. 

+ Answer
+ Report
Total Preview: 1033

Copyright © 2024. Powered by Intellect Software Ltd