Range

A range is a block of cells together, sometimes called a block. Ranges can be used in formulas and references by the first and last cell, separated by a colon. A1 to A10 are a range and is
represented as A1:A10. They are used as a sum =SUM (A1:A10), or =AVERAGE (A1:A10) for
average. Ranges are rectangular in shape. To sum all the cells from A1 to A10, B1 to B10 and
C1 to C10 the formula would be: =SUM (A1:C10).