Page 40 - Plus V4 with Adobe class 6
P. 40

Typing the Formula in the Formula Bar: In this way,
                                                         we can type the formula in Formula bar after selecting
                                                         the cell. After entering the formula, when we press the
                                                         Enter key from the keyboard. The result will appear.



                 Factbot

          Excel follows BEDMAS rule for doing mathematical calculations, where B stands for Brackets, E for
          Exponentiation, D for Division, M for Multiplication, A for Addition and S for Subtraction.


        Some formulas based on BEDMAS rule can be entered as:
        1.  =(8 + 5) – (2 + 3) ^ 2    2.  =(9/3) * (4 ^ 2) – 5

        The elements of a formula are:
             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.
                                                                                                 Hintbot
        Copying a Formula

        There are two methods to copy a formula:                                       To calculate the sum
        Using the Fill Handle                                                         of adjacent cells: press
                                                                                      the Alt + = keys together
        Step 1:  Select the cell that contains the formula, then position the         after selecting the cells.
                 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 click on the Copy command.
        Step 2:  Select the cell or cells that you want to copy it to.
                 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 drop-down arrow of Paste command
                     and select Paste Special, and then select Formulas and click on OK button.


                 Double Tap                                                    Century   #Technology Literacy
                                                                                 21 st
                                                                                 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.




            38  Plus (Ver. 4.0)-VI
   35   36   37   38   39   40   41   42   43   44   45