FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Range: A range is a group of cells in a spreadsheet that have been selected. If the cells are all together in a rectangular or square shape, it is an adjacent range. An adjacent range is identified by the cell reference in the upper left and lower right corners of the selection separated by a colon. (Example: A3:B5).

Detailed explanation-2: -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.

Detailed explanation-3: -A cell range in Ms Excel is a collection of chosen cells. It can be referred to in a formula. This is defined in a spreadsheet with the reference of the upper-left cell as the minimum value of the range and the reference of the lower-right cell as the maximum value of the range.

Detailed explanation-4: -Cell. A box formed by the intersection of a row and column in a worksheet or a table, in which you enter information. Cell reference. The set of coordinates that a cell occupies on a worksheet. For example, the reference of the cell that appears at the intersection of column B and row 3 is B3.

Detailed explanation-5: -cell. The rectangular shaped area on a worksheet that is created by the intersection of columns and rows. cell address. The name of the cell is determined by the name of the row and the column intersecting, such as A8. cell grid.