Page 78 - TGPT_V5.0_C5_Flipbook
P. 78

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.  Which tab contains the Borders command?

                     2.  What is the shortcut to apply the default date format?

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







                  76  Premium Edition-V
   73   74   75   76   77   78   79   80   81   82   83