Page 267 - Trackpad IT-402_Class-IX
P. 267
w Rows: Rows are accessed horizontally on a worksheet and are identified by numbers 1, 2, 3, 4, …. written on the
left side of the worksheet. Each sheet has a maximum of 1,048,576 (2 power of 20) rows and 1024 (2 power of
10) columns, i.e., from A to AMJ.
w Columns: Columns are accessed vertically on a worksheet and are identified by alphabets A, B, C, …, Z, AA, AB, AC,
…., AZ, BA to BZ, CA, to CZ, and so on written on the top of each worksheet.
w Cell: The intersection of a row and column is called a cell. Each cell in a spreadsheet is referred to by an address
which is formed by a combination of the column alphabet first and the row number later. For example, the D5
address refers to a cell formed by the intersection of the D column and the 5th row. A cell can have any data like
text, numbers, formulas, etc.
w Active Cell: The currently selected cell is called an active cell. The name of the active cell is displayed in the Name
Box and is always highlighted with a black thick border.
w Cell Range: A group of continuous cells selected with a mouse or keyboard is known as a cell range. Any data such
as text, numbers, and formulae can be entered in a cell range.
• Cell range can be classified into three types:
w Row Range: The selection of cells done row-wise horizontally will form a row range. In the given figure, the row
range starts from cell D5 to cell H5. It is represented as D5:H5.
w Column Range: The selection of cells done column-wise vertically will form a column range. In the given figure,
the column range starts from cell C3 to cell C10. It is represented as C3:C10.
w Row and Column Range: When a selection of cells covers both rows and columns, it forms a grid of selected cells.
In the given figure, the selection covers cells starting from C3 to F7. This selection or the cell range is represented
as C3:F7.
Electronic Spreadsheet 267

