Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 53 - 2611_SmartGPT Pro V(5.0) C-5
P. 53

    PURE
                         Excel follows BEDMAS rule for doing mathematical calculations.                       FACT

                     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.

                     COPYING A FORMULA
                     There are two methods to copy a formula:

                     Using the Fill Handle

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

                     Step 2:  Drag the fill handle over the cell or cells in which                  Alt    +    =
                             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.

                             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.

                          Tick ( ) if you know this.

                          ▶  Excel makes calculations easier.
                          ▶   We can apply all types of mathematical operations like addition, subtraction,
                             multiplication and division in Excel.

                                                                                     Charts, Formulas & Functions in Excel  51

| 48 49 50 51 52 53 54 55 56 57 58 |