Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 17 - 2617_JSSPS_C-6
P. 17

    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                                                                   Hintbot

                     Step 1:  Select the cell that contains the formula, then position the
                             mouse pointer over the lower-right corner of the cell until           To calculate the sum
                             the black cross (+) appears.                                          of adjacent cells: press

                     Step 2:  Drag the fill handle over the cell or cells in which you want to    the Alt + = keys together
                             copy the formula, then release the mouse button.                     after selecting the cells.
                     Using Copy and Paste
                     Step 1:  Select the cell that contains the formula, and click on the
                             Copy command.
                     Step 2:  Select the cell or cells that you want to copy.
                             a.  To copy the formula and any formatting, click on the Paste command.

                             b.  To copy the formula only, on the Home tab, click on the drop-down arrow of the Paste
                                command and select Paste Special, and then select Formulas and click on the OK button.

                              Topic Flashback                                                21 st  Century   #Technology Literacy
                                                                                                 Skills  #Flexibility
                            Write T for True and F for False.
                            a.  Excel makes calculations easier.
                            b.   We can apply all types of mathematical operations like addition, subtraction,
                               multiplication and division in Excel.
                            c.  A formula always begins with an equal (=) sign.

                     ORDER OF OPERATION

                     When performing calculations using a formula, Excel follows certain rules of precedence:
                        Excel calculates expressions within parentheses (.... , ....) first.
                        Excel calculates multiplication and division before addition and subtraction.
                        Excel calculates consecutive operators with the same level of precedence from left to right.
                     For example, the formula = 10 + 10 * 2 gives a result of 30 as Excel multiplies 10 by 2 and then adds 10.

                     However, the formula =(10 + 10)*2 produces a result of 40. This is because Excel calculates the expression
                     (10 + 10) within the parentheses first. It then multiplies by 2.
                     If you are unsure of the order in which Excel calculates, use parentheses, even if the parentheses aren’t
                     necessary. Parentheses also make your formulas easier to read.

                                       Envision  your  favourite  tech  personality  as a Gizmo  Gadget.  How  would  you  paint  their
                                       portrait in Excel?

                                                                                 Charts, Formulas & Functions in Excel  15

| 12 13 14 15 16 17 18 19 20 21 22 |