Page 59 - TP_Prime_v2.2_Class_5
P. 59

Step 4:   A Format Cells dialog box appears. Select Date  option in the Category
                           section. A list of formats is displayed.


                  2


                                                                                3


                                                                                                  Soft Hint                 INTRODUCTION TO EXCEL 2016

                  1                   4
                                                                                           To apply the default

                                                                                5         time and date format:
                                                                                                   Ctrl +
                                                                                               Shift + # or

                                                                                             Ctrl + Shift + @
                                                                                6                                         57



                 Step 5:  Choose the format you want.

                 Step 6:  Click OK button.

                            You can see a preview of the active cell in the Sample box with the format

                           you have selected.


                  Changing Cell Contents



                 When you enter the data in a cell, you can change it. The process of changing the

                 data either partially or completely is known as editing. Cell contents can be edited in
                 two ways.

                 1.  Replacing cell contents

                 2.  Using the formula bar


                   Replacing Cell Contents


                 You can replace the contents of a cell by the following steps:

                 Step 1:   Go to that cell or click on it to make it the active cell.

                 Step 2:   Start typing the new data. The previous data will be automatically replaced
                           by the new data.
   54   55   56   57   58   59   60   61   62   63   64