Page 34 - ICT_for_JHS_3_Classical
P. 34
A cell is defined as the space where a specific row and column intersect. A cell
has a name or address. The name is comprised of two parts: the column letter
and the row number. The name of a cell is known as cell address. The cell
address identifies the location of each cell. E.g. C3, G4, A10, Z100, etc.
In the picture above, cell C3—formed by the intersection of column C and row
3—contains a dark border. It is the active cell. The active cell, or the cell that
can be acted upon. All other cells reveal a light gray border. The heavy border
around the selected (active) cell is called the cell pointer. Data and formulas are
entered into the active cells.
NB: Cell addresses starting with row numbers, like 3C, 4G, 9J, 7H, 56D. etc
are invalid cell addresses.
Cell Range
A group of cells is known as a cell range. The cell range is the addresses of the
first and last cells, separated by colon. For example, a cell range that included
cells C8, D8, E8 and F8, would be written as C8:F8. Likewise, E5, E6, E7, E8
and E9, would be written as E5:E9 as seen below.
Moving around the worksheet
To move a around a worksheet:
Activate any cell: point to a cell with the mouse and click.
Move the pointer one cell to the left, right, up, or down with the
keyboard arrow keys.
Moving between worksheets:
