Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 32 - ClickGPT V4.0 C-5
P. 32

    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.  The input of =25+B2 will give an error message.

                  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
                  UNDERSTANDING CELL RANGE
                                     portrait in Excel?

                     30     Premium Edition-V

| 27 28 29 30 31 32 33 34 35 36 37 |