Question

what is cell range how can you apply a formula using cell range​

Answer 1

Answer:

A cell range in an Excel file is a collection of selected cells. In a spreadsheet, a cell range is defined by the reference of the upper-left cell (minimum value) of the range and the reference of the lower right cell (maximum value) of the range. Ranges can be used instead of the cell address references in calculations and formulas. You can define more than one name to the same cell or range of cells, although if you use the same name to define two different ranges then the previous name is overwritten.

Answer 2

Answer:

A cell range can be used inside a formula, for example to calculate the sum of the values within the selected cells. The notation for the sum of all values in cell range (A1:C6) is =SUM(A1:C6).