Question

the cell reference for cell range H2 and N56 in IT

​

Answer 1

Explanation:

A cell range in an Excel file is a collection of selected cells. This range is usually symmetrical (square), but can exist of separate cells just the same. A cell range can be referred to in a formula as well.

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. 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. That’s different from a mathematical range, in which it is a collection of values between a maximum and a minimum value.