Page 32 - Plus_V2.2_C6_Flipbook
P. 32

You can also use cell addresses to perform calculation in the following way:







                  Notice that when the cell C1 is selected in the Formula bar shows
                  the formula you just typed.                                                  Tech Hint
                     What appears in the cell is the result.                             To calculate the sum of
                      What  appears  in  the  formula bar is  the  value, which is  a   adjacent cells: press the
                    formula in this case.                                               Alt + = keys together after
                  The elements of a formula are:                                            selecting the cells.

                      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.

                       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:  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, 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.                                  __________







                  30    Premium Edition-VI
   27   28   29   30   31   32   33   34   35   36   37