Page 65 - TP_Pluse_V2.2_Class_5
P. 65

Selecting Multiple Cells

                 To select a group of cells which are not next to each other, click on
                 the first cell. Now, keeping the Ctrl key pressed click on the other
                 cells to select. All the selected cells will be highlighted.


                      Selecting the Whole Worksheet

                 To select the whole worksheet, click the Select All triangle. This

                 button is present above row 1.
                                                Select All




                                      Tech Hint

                                  To select the entire
                                  worksheet: Ctrl + A







                         Let’s CatCh uP

                   Short answer question.

                   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?             ___________________




                        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:

                 Step 1:  Select the cell where you want to edit the date or time.
                 Step 2:  Click on Home tab.

                 Step 3:  Click on the Number format dialog box launcher.

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


                                                                                  Editing Cell Contents in Excel 2016  63
   60   61   62   63   64   65   66   67   68   69   70