Question Details

If the cell B1 contains the formula = $A$1, which of the following statements is true

A There is a relative reference to cell A1
B There is an absolute reference to cell A1
C Further changes in value of A1 will not affect the value of B1
D Further changes in value of B1 will affect the value of A1

Option B: There is an absolute reference to cell A1

152

Discussion


No comments yet. Be the first to comment!

WhatsApp Support