Page 58 - Trackpad_ipro 4.1_Class7
P. 58

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 such 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 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 a worksheet has an address, which is called a cell address. A cell
                  address is a combination of a column heading and the 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 a 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 ( ).
                  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.

                   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:A6), and Non-Contiguous Cell Range, where
                                     cells are not adjacent and specified with commas (e.g., A1, B1, C3).

                      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.
                     Text: Text includes the collection of letters, numbers, and special characters. No mathematical
                     calculation can be performed on text. By default, Excel aligns text to the left.
                     Date and Time: Date type is used to enter the date in different formats. The default format of
                     date in Excel is mm/dd/yy. Time type is used to enter time in either hh:mm or hh:mm:ss format.
                     By default, Excel aligns dates and times to the right.


                    56     iPro (Ver. 4.1)-VII
   53   54   55   56   57   58   59   60   61   62   63