Page 42 - C_GPT _V4 _class_6
P. 42

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?






                 40     CodeGPT (Ver. 4.0)-VI
   37   38   39   40   41   42   43   44   45   46   47