Page 56 - iPro_trackGPT_V5_Class7
P. 56

Row and Column Heading

                  The row heading is the grey number (1, 2, 3, etc.) at the beginning of each row in the worksheet.
                  In contrast, the column heading is the grey letter (A, B, C, etc.) at the top of each column. Row
                  headings range from 1 to 1,048,576, while column headings range from A to XFD.
                  Cell

                  The intersection of a row and a column is known as a cell. In an Excel worksheet, a cell appears
                  as  a  rectangular  box.  Each  cell  has  a  unique  address,  known  as  the  cell  address,  which  is  a
                  combination of the column heading and the row heading. For instance, a cell in the second row
                  of column A is addressed 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.

                     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 is used to enter the date in different formats. The default format of date in
                     Excel is mm/dd/yy. Time is used to enter time in either hh:mm or hh:mm:ss format. By default,
                     Excel aligns dates and times to the right.

                     CREATING A NEW WORKBOOK

                  To create a new workbook in Excel 2021, follow the given steps:


                           1  Click on the File tab.






                                                                                               3  Click on the
                                                                                              Blank workbook.





                                      2  Click on the
                                     New option.

                  A new workbook will be created.



                    54    TrackGPT iPRO (V5.0)-VII
   51   52   53   54   55   56   57   58   59   60   61