Page 80 - TP_iPlus_V2.1_Class7
P. 80

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



                                    What if you could use Excel to track the books you’ve read and the books
                                    you want to read? How would you rate them and what genres would you
                                    include?







                     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 from 0 to 255 and a row height from 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 feature of Excel is used to display multiple lines of text inside a cell?
                         a. Format                                       b. Wrap Text

                         c. Autofill                                     d. Auto Text

                      2.  Which of the following is NOT an element of a formula?

                         a. References                                   b. Operators

                         c. Constants                                    d. Formatting



                    78
                         iPlus (Ver. 2.1)-VII
   75   76   77   78   79   80   81   82   83   84   85