Page 79 - iPlus_Ver_2.0_class_7
P. 79

i +  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.





                    To Sum Up


                          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.

                          AutoFill 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.





                                                           Exercise


                                                       Section A (Objective)
                 A.  Tick (3) the correct option.

                     1.  Which of the following formatting elements are included on the Home tab?

                        a. Text wrap                                    b. Cell style

                        c. Merging cells                                d. All of these

                     2.  Which operation takes place when you press the Ctrl + Z key combination?
                        a. Undo                                         b. Redo

                        c. Cut                                          d. Copy





                                                                                                                  77
                                                                                          More on Spreadsheets
   74   75   76   77   78   79   80   81   82   83   84