Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 70 - CodePilot V5.0 C5
P. 70

    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.

                      68      CodePilot (V5.0)-V

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