Page 20 - CG_v2.1_flipBooks_class_5
P. 20

Row

                  The horizontal divisions in a worksheet are called rows. There are 10,48,576 rows in an Excel
                  worksheet. Rows are numbered from top to bottom along the left edge of the worksheet as
                  1, 2, 3, ... .

                  Column

                  The vertical divisions in a worksheet are called columns. There are 16,384 columns in an
                  Excel worksheet. Columns are labelled from left to right with letters as A, B, C, D, ... .

                  Row and Column Heading

                  The row heading is the grey-coloured number (1, 2, 3, etc.) located in front of each row in
                  the worksheet. On the other hand, the column heading is the grey-coloured letter (A, B, C,
                  etc.) located at the top of each column. The row headings range from 1 to 10,48,576 and the
                  column headings range from A to XFD.

                  Cell

                  The intersection of a row and a column is called a cell. A cell in an Excel worksheet looks like
                  a rectangular box. Every cell in the worksheet has an address, which is called a cell address.
                  A cell address is a combination of a column heading and a row heading. For example, a cell
                  in the second row of column A has the cell address as A2.

                  Active Cell

                  The currently selected cell that appears highlighted with the green border is an active cell.
                  The data is entered in an active cell.
                  Mouse Pointer

                  The mouse pointer is displayed as a block plus sign ( ), whenever we move over a cell in a

                  worksheet. Another common shape of the mouse pointer is the block arrow.
                  Cell Range

                  A cell range is a collection of two or more cells. It is of two types: Contiguous Cell Range
                  and Non-Contiguous Cell Range. Contiguous Cell Range is a collection of cells that are
                  adjacent to or next to one another. A colon (:) is used for specifying this cell range, for

                  example, A1:A6. Non-contiguous Cell Range is a collection of cells that are not adjacent
                  to one another. A comma (,) is used for specifying this cell range, for example, A1, B2, C3.
                  Workbook

                  An Excel file is called a workbook. It is a collection of different worksheets. By default, a

                  workbook contains only one worksheet, Sheet1. The number of worksheets can be increased
                  as per the requirement.







                       18    Computer Genius (V2.1)-V
   15   16   17   18   19   20   21   22   23   24   25