Page 57 - iPrime_V2.2_class7
P. 57

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, ... and
                 so on up to 10,48,576.
                 Column

                 The vertical divisions in a worksheet are called columns. There are 16,384 columns in an Excel
                 worksheet. Columns are labelled with letters from left to right along the top edge of the worksheet
                 as A, B, C, D, ... and so on up to XFD.
                 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 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 a worksheet has an address which is called a cell address. A cell
                 address is a combination of the column heading and the row heading. For example, a cell in the

                 second row of column A has the cell address as A2.

                          Tech Funda



                       A cell range in Excel refers to a group of two or more cells. There are two types:
                       Contiguous Cell Range, where cells are next to each other and specified with a colon
                       (e.g., A1), and Non-Contiguous Cell Range, where cells are not adjacent and specified
                       with commas (e.g., A1, B1, C3).



                 Active Cell

                 The currently selected cell that appears highlighted with a dark black 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( ).
                 Workbook

                 An Excel file is called a workbook. It is a collection of different worksheets. By default, a workbook
                 contains only one worksheet, Sheet1, that can be increased as per the requirement.

                     TYPES OF DATA

                 While working in Excel, the following types of data can be entered.
                   Numbers:  Numbers  include  the  digits  (0–9)  and  their  various  combinations.  All  types  of
                   calculations can be done on numbers. By default, Excel aligns numbers to the right.

                                                                                  Spreadsheets—An Introduction     55
   52   53   54   55   56   57   58   59   60   61   62