By default cell reference is ____.

The correct answer is Option (2) → Relative

A reference typed without any dollar sign, such as C4, is relative: when the formula is copied, the reference moves with it. That is the setting a spreadsheet uses unless the user adds $ signs to make it absolute or mixed.