Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 44 - 2620_Birla Open Mind C-6
P. 44

    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 in
                                                                  the particular cell.

                           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.

                  Calculate the formulas given below based on BEDMAS and write the result.

                  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 of

                  Using the Fill Handle                                                         adjacent cells: press the
                                                                                                Alt and = 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 (+) or Fill Handle 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 done in that cell, 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.

                      42  Premium Edition-VI

| 39 40 41 42 43 44 45 46 47 48 49 |