Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 71 - 2629_Devagiri_C-5
P. 71

    RAPID RECALL                            Tick ( ) if you know this.

                         1.  A cell address is a combination of the column and row heading.

                         2.  File tab opens Backstage View for tasks like New, Open, Save and Print.

                            CHANGING THE ACTIVE CELL

                     To change the active cell in a worksheet, click the cell with the mouse or use the
                     keyboard keys, as listed below:

                                 Key                                           Function

                       Enter key                  Moves the active cell down one row

                       Shift + Enter key          Moves the active cell one row up

                       Shift + Tab key            Moves the active cell one column to the left

                       Tab key                    Moves the active cell one column to the right

                       ß [left arrow key]         Moves the active cell one column to the left

                       à [right arrow key] Moves the active cell one column to the right
                       á [up arrow key]           Moves the active cell one row up

                       â [down arrow key] Moves the active cell one row down
                       Ctrl + Home key            Moves the active cell to the first cell, i.e., A1

                       Ctrl + End key             Moves the active cell to the last used cell on the worksheet

                            CREATING A NEW WORKBOOK

                     A workbook in Excel refers to a file that contains one or more worksheets. To create

                     a new workbook, follow the given steps:

                             1     Click on the                                         Each dolphin has a unique
                                    File tab.                                          whistle (name) just like Excel
                                                                                     has a unique name for each cell.

                                                                                                 Understanding Excel   69

| 66 67 68 69 70 71 72 73 74 75 76 |