Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 49 - 2617_JSSPS_C-5
P. 49

    Using the Mouse
                     To select a range of cells using a mouse: First click in the
                     top left cell and drag to the bottom right cell. The range gets
                     selected. All the selected cells get highlighted. Only the active
                     cell is not highlighted.

                     Using the Keyboard
                     You can also select a range by clicking the top left cell. Then
                     keeping the Shift key pressed while using the arrow keys to
                     reach the bottom right cell of the desired range. The range
                     will be selected.

                                                      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.

                                       What if you could use Excel to track the books you’ve read and the books you want to
                                       read? How would you rate them and what genres would you include?

                     Selecting the Whole Worksheet

                     To select the whole worksheet, click the Select All triangle.
                     This button is present above row 1.

                                                   Hintbot

                                          To select the entire
                                          worksheet: Ctrl + A

                     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.

                                                                                        Introduction & Editing in Excel  47

| 44 45 46 47 48 49 50 51 52 53 54 |