Page 68 - TP_Plus_v4_Class4
P. 68

ENTERING DATE AND TIME


              When you enter time in a cell in Excel, it looks for the hours, minutes, seconds and am/pm. So,
              the default time format is hours : minutes : seconds AM/PM. For example, 10:28:35 AM, 8:15:00
              PM, 10:28 AM, 8 PM, etc. Excel recognises all the formats given in the examples here. Similarly,

              when you enter date, e.g. 10/4, Excel recognises it as date and displays 10-Apr in the cell.

              To change the format of date or time you entered, follow these steps:


                    2   Click on Home                         Select  Date  option in the   4
                        tab.                                  Category section.

                                                                                           Click on the Number
                                                                                           format dialog  box      3
                    Select the cell                                                        launcher.
                    where     you
                    want to edit
                    the  date  or                                                          Choose the format       5
                1
                    time.                                                                  you want.








                                                                                                                  6
                                                                                           Click on OK button.





                                                                  Hintbot


                                          To apply the default date format: Ctrl + Shift + #

                                          To apply the default time format: Ctrl + Shift + @






                                                                                         21 st
                       Double Tap                                                      Century   #Technology Literacy
                                                                                        Skills
                     Answer the following in one or two words:

                     1.  What is the shortcut to select the whole worksheet?

                     2.  Which key is used to select a range of cells?
                     3.  Which key is used to select the multiple cells?

                     4.  What is the shortcut to apply  the default time format?





                  66  PLUS (Ver. 4.0)-V
   63   64   65   66   67   68   69   70   71   72   73