Page 61 - C_GPT _V4 _class_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