Page 72 - iPro_trackGPT_V5_Class7
P. 72

Boost Bits

                   Excel follows the 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.


                  You can also use cell addresses to perform calculations in the following way:







                  Notice that when cell C1 is selected, the Formula bar shows the formula you just typed.
                  You can also calculate the sum of adjacent cells by pressing the Alt+= keys together after
                  selecting the cells.
                     What appears in the cell is the result.

                     What appears in the formula bar is the formula, which is used to get the result.
                  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
                     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 that result 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.






                        The contents of a cell can be moved or copied to other cells.
                        Row height and column width can be changed.
                        You can specify a column width of 0 to 255 and a row height of 0 to 409.
                        Two or more cells can be merged into one cell.
                        Auto Fill feature automatically fills a series of data in your worksheet.
                        Formulas in Excel begin with an equal (=) sign.
                        A cell or a range of cells that you want to use in your calculation is called a reference.
                        Excel calculates consecutive operators with the same level of precedence from left to right.




                    70    TrackGPT iPRO (V5.0)-VII
   67   68   69   70   71   72   73   74   75   76   77