Question : A range reference consists of 2 cell addresses separated by a _______.
Option 1: colon
Option 2: comma
Option 3: full stop
Option 4: All of the above
Correct Answer: colon
Solution : A range reference consists of 2 cell addresses separated by a colon. The cell reference B1:B4 includes the cells B1, B2, B3 and B4. Hence, the correct option is 1.