Page 64 - TechPluse_C6_Flipbook
P. 64

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






                                                       Using cell addresses in formula

                  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.

                        What  appears in the  formula bar  is the  value,
                        which is a formula in this case.

                  The elements of a formula are:
                                                                                        Using cell addresses in formula
                        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 white 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 from the Edit menu, click Copy.

                  Step 2    Select the cell or cells that you want to copy it to.
                             (a)  To copy the formula and any formatting, from the Edit menu, click Paste.

                             (b)   To copy the formula only, from the Edit menu, hover the mouse pointer over Paste
                                  Special option and click on Paste Only Formula option from the sub-menu.

                      ORDER OF OPERATION


                  When performing calculations using a formula, Calc follows certain rules of precedence:
                        Calc calculates expressions within parentheses ‘(‘ , ’)’ first.

                        Calc calculates multiplication and division before addition and subtraction.

                        Calc calculates consecutive operators with the same level of precedence from left to right.
                  For example, the formula = 20 + 20 * 3 gives a result of 80 as Calc multiplies 20 by 3 and then
                  adds 20. However, the formula = (20 + 20) * 3 produces a result of 120.


               62       Premium Edition-VI
   59   60   61   62   63   64   65   66   67   68   69