Page 63 - TP_iPlus_V2.1_Class7
P. 63

#Digital Literacy
                      Let’s CatCh Up


                   Match the following:

                   1. Row header                          a. Address of the active cell
                   2. Column header                       b. Displays contents of active cell

                   3. Sheet tab                           c. Row numbers

                   4. Name Box                            d. Column letters
                   5. Formula bar                         e. Displays number sheets in worksheet



                  i +  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.

                  i +  CREATING A NEW WORKBOOK


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

                                         2  Click on the New option.






                   1  Click on the File tab.




                                                                                                  3  Click on the
                                                                                                  Blank workbook.






                 A new workbook will be created.



                                                                                                                  61
                                                                                  Spreadsheets—An Introduction
   58   59   60   61   62   63   64   65   66   67   68