Basic Elements of Worksheet

Basic Elements of Worksheet:

  The following are basic elements of a worksheet.

  Columns:

     Columns in a worksheet are arranged vertically. They are identified by alphabet in the column header from A to Z, AA, AB, AC, to XFD, as shown in figure 3.8a.

Figure 3.8a Columns

  Rows:

  Rows are arranged horizontally in a worksheet. They are identified by numbers in the row header(1,2,3,4,...), as shown in figure 3.8b.

Figure 3.8b Rows

  Cell:

     The intersection of row and column in a worksheet is called the cell. The cell is the basic unit in the worksheet where the user can enter data, function or formula. The "active cell" is the cell which is currently selected. It can be identified by the black border around it, or by its cell address in the
Name Box. Figure 3.8c shown cell and active cell(C6). 

Figure 3.8c Active Cell

Cell Address or Cell Reference:

    Cell Address or Cell Reference identifies the location of a cell or group of cells in a worksheet. It consists of the column letter and row number that intersect at the cell's location. Cell references are used in formulae, functions, charts and other Excel commands. Figure 3.8c with arrow sign shows cell address of the active cell as B2.

Cell Range: 

    Selecting more than one cell is known as a cell range. Two cell references are used for a range of cells separated by a colon(:) which tells Excel to include all the cells between the start and end points. 
Figure 3.9  shwos range of cells from C4 to F7.

Figure 3.9 Cell Range