Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 61 - 2610_Springdales_C-5
P. 61

    Formula Bar: It displays the contents of the active cell. You can also type or edit data and
                       formulas in the formula bar.

                        Name Box: It displays address of the active cell. It is present on the left side of the formula
                       bar.

                             Topic Flashback                                                    21 st  Century   #Technology Literacy
                                                                                                    Skills  #Critical Thinking
                           Match the following:

                           1.  Row header                     a.  Address of the active cell
                           2.  Column header                  b.  Displays content of active cell

                           3.  Sheet tab                      c.  Row numbers
                           4.  Name box                       d.  Column labels

                           5.  Formula bar                    e.  Displays number of worksheets in a workbook

                    CHANGING THE ACTIVE CELL

                    To change the active cell in a worksheet, you can either use the keyboard or the mouse pointer.
                    When working with a mouse, just click on the cell you want to make active. Given below are the
                    keys and their functions to change the active cell in a worksheet.

                      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

                                                                                            Introduction to Excel 2019  59

| 56 57 58 59 60 61 62 63 64 65 66 |