Page 38 - TP_Pluse_V2.2_Class_6
P. 38

DIFFERENT WAYS TO ENTER A FORMULA


                  There are  mainly two  ways to enter a formula in a
                  worksheet:
                      Typing  the formula  directly  in  the Cell: In  this  way, the
                    formula is directly typed in the cell after typing an equal

                    sign as shown here.
                     After entering the formula in the cell, press the Enter key.
                                                                                               Formula in cell
                    When the Enter key is pressed, the result of the formula

                    appears in the cell.
                      Typing the formula in the Formula bar: In this way, we can
                    type the formula in the Formula bar after selecting the cell
                                                                                                  Output
                    as shown here.
                     After  entering  the  formula, when we press  the  Enter key
                    from the keyboard. The result will appear.



                         UNDERSTANDING CELL RANGE
                                                                                            Formula in Formula bar
                  A group of selected cells is called a cell range. The selected cells should be in continuation to form
                  a range. When a range is selected in a worksheet, a rectangular shape is formed. We can use a cell
                  range to perform a calculation on multiple cells. The address of a range is created by using the starting
                  and the ending cell addresses separated by a colon (:) sign. For example, if we have selected the cells
                  from B2 to E3, then the address of the range will be B2:E3.

                       Selecting a Range in a Worksheet

                  We can select a range by using the mouse and by using the Keyboard.
                  By using the Mouse

                  Perform the following steps to select a range by using the mouse:

                  Step 1:   Click  on the first cell from which you  want to
                          start the range.
                  Step 2:   Press and hold the left mouse button and drag
                          the mouse diagonally to select the desired range.
                  Step 3:   Release the mouse button on the cell up to which
                          you  want to  select  the  range. The range gets          Cell range selected by mouse

                          selected.

                  By using the Shift Key

                  Perform the following steps to select a range by using the Shift key:
                  Step 1:  Click on the first cell from which you want to start the range.

                  36    Plus (Ver. 2.2)-VI
   33   34   35   36   37   38   39   40   41   42   43