Question

what do you mean by range . how can you name a range .Explain​

Answer 1

Answer:

In general, a range refers to a series of values between two other values. For example, the range between 1 and 5 is 2, 3, and 4. 2. When referring to a spreadsheet, the range or cell range is a group of cells within a row or column.

Answer 2

In a spreadsheet a cell range is a collection of selected cells. Eventually separate cells can be added to this selection, then the range is called an irregular cell range. In Excel, the minimum and maximum value are included.

To name cells, or ranges, based on worksheet labels:

• Select the labels and the cells that are to be named.
• On the Ribbon, click the Formulas tab, then click Create from Selection.
• In the Create Names From Selection window, add a check mark for the location of the labels, then click OK.
• Click on a cell to see its name