By default cell reference is ____.
Answer & explanation
Correct answer: option 2
The correct answer is Option 2:Relative
By default cell reference is relative; which means that as a formula or function is copied and pasted to other cells, the cell references in the formula or function change to reflect the new location.