Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 76 - 2620_Birla Open Mind C-5
P. 76

    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?

                      74  Premium Edition-V

| 71 72 73 74 75 76 77 78 79 80 81 |