Page 31 - TP_Pluse_V2.2_Class_6
P. 31

Notice that when the cell C1 is selected, the Formula bar shows the formula you just typed.
                   What appears in the cell is the result.
                    When a formula is typed and used in a cell it is displayed in the formula bar.

                 The elements of a formula are:
                    References: A cell or a range of cells that you want to use in your calculation.
                   Operators: Symbols (+, -, *, /, ^, %, etc.) that specify the calculations to be performed.
                   Constants: Numbers or text values that do not change.



                                                            Tech Hint

                    To calculate the sum of adjacent cells: press the Alt + = keys together after selecting the cells.




                      Copying a Formula

                 There are two methods to copy a formula:
                 Using the Fill Handle

                 Step 1:  Select the cell that contains the formula, then position the mouse pointer over the lower-right

                         corner of the cell until the black cross (+) appears.
                 Step 2:  Click and drag the fill handle over the cell or cells to which you want to copy the formula, then

                         release the mouse button.
                 Using Copy and Paste

                 Step 1:  Select the cell that contains the formula, and on the Home tab, click Copy.

                 Step 2:  Select the cell or cells that you want to copy it to.
                         (a)  To copy the formula and any formatting, on the Home tab, click Paste.

                         (b)   To copy the formula only, on the Home tab, click on drop-down arrow of Paste tool and
                             select Paste Special in the Paste Special dialogue box, and then select Formulas and

                             click on OK button.


                         Let’s CatCh uP

                   State whether these statements are True or False.

                   1.  Excel makes calculations easier.                                                ___________

                   2.   We can apply all types of mathematical operations like addition,
                      subtraction, multiplication and division in Excel.                               ___________

                   3.  The input of =25+B2 will give an error message.                                 ___________







                                                                                              More on Excel 2016   29
   26   27   28   29   30   31   32   33   34   35   36