Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 71 - CodePilot V5.0 C5
P. 71

    RAPID RECALL  Tick ( ) if you know this.        3     Click on the Blank workbook.

     1.  A cell address is a combination of the column and row heading.                          SHORT SIGN
                                                                                                 To create a new
     2.  File tab opens Backstage View for tasks like New, Open, Save and Print.
                                                                                                    workbook:
                       2     Click on the New                                                         Ctrl + N
                                     option.

     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:  A new workbook will be created.

     Key  Function

     Enter key  Moves the active cell down one row   DATA TYPES IN EXCEL

     Shift + Enter key  Moves the active cell one row up
                     Data types refer to the types of values that can be stored in cells. Following are the
     Shift + Tab key  Moves the active cell one column to the left
                     data types used in Excel:
     Tab key  Moves the active cell one column to the right     Text: It includes letters, numbers

     ß [left arrow key]  Moves the active cell one column to the left   and  special characters like  !,        Text

     à [right arrow key] Moves the active cell one column to the right  @, &,%,  etc.  Example:  Orange!,       Number
                         ABC123@
     á [up arrow key]  Moves the active cell one row up                                                         Time
                          Number: It consists of digits (0–9)
     â [down arrow key] Moves the active cell one row down                Date
                         and can include decimals and
     Ctrl + Home key  Moves the active cell to the first cell, i.e., A1   signs (-, +) for calculations. Example: 10, 250, 15.6, -25.

     Ctrl + End key  Moves the active cell to the last used cell on the worksheet     Date and Time: These data types represent calendar dates and clock times. The

                         default format is dd-mm-yyyy for dates and hh:mm or hh:mm:ss for time.

                         Example: 21-06-2025, 10:30, 10:25:45.
     CREATING A NEW WORKBOOK

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

     a new workbook, follow the given steps:
                     To enter data in a worksheet, click a cell and

     1     Click on the   Each dolphin has a unique   start typing. The text or numbers will appear
     File tab.  whistle (name) just like Excel    in the  Formula  bar. Press  Enter to  move
     has a unique name for each cell.  down one cell or Tab to move right. To edit,

                     double-click the cell and type the new data.

                                                                                                 Understanding Excel   69

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