Multiple choice general knowledge

The cell reference fro a range of cells that starts in cell B1 and goes over to column G and down to row 10 is……

  1. B1-G10

  2. B1.G10

  3. B1:G10

  4. B1;G10

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Excel uses a colon (:) to specify ranges. The format is always top-left cell:bottom-right cell. For a range starting at B1 and extending to G10, the correct notation is B1:G10.