Page 60 - TP_Prime_v2.2_Class_5
P. 60

Soft Hint
                     Using the Formula Bar
                                                                                                To edit a cell:
                  You can change the data partially by clicking on the formula                      F2 key
                  bar or double-clicking the cell. The cursor appears in the

                  cell. Make the necessary changes in the cell or in the formula bar. Press Enter key or
                  click on the Enter button           on the formula bar. The cell contents are changed.         2

           Prime (Ver. 2.2)-V  Step 1:   Click  on  the  formula  bar  or  double-click  on
                  To change the data partially, follow the steps:
                                                                                                      3


                             the cell where you want to edit the data. The
                             cursor appears in the cell.

                  Step 2:   Enter the new data in the cell or the formula

                             bar.                                                                        1

          58      Step 3:   Press Enter key or click on the Enter button on
                             the formula bar. The cell data will be changed.



                                                                                                  21 st
                      Word Bank                                                                Century   #Technology Literacy
                                                                                                 Skills
                      Spreadsheet             Row                          Column                     Cell
                      Workbook                Worksheet                    Active Cell                Range



                                  Let's Revisit


                  •   Excel organises numerical data in the form of rows and columns in a tabular form.
                     Excel is also known as an electronic spreadsheet.

                  •   A spreadsheet can be defined as text and numbers that have been organised in

                     rows and columns.
                  •   The Excel 2016 window has many components such as, title bar, status bar, view

                     bar, sheet tabs, worksheet, rows and columns, cells, name box, and formula bar.

                  •   To change the active cell in a worksheet, you can either use the keyboard or the
                     mouse pointer.

                  •   A range is a rectangular section of cells which are next to each other and at least
                     one side of their border is common.

                  •   The process of changing data either partially or completely is known as editing.
                  •   Cell contents can be edited by replacing the cell contents and by using the formula

                     bar.
   55   56   57   58   59   60   61   62   63   64   65