Page 43 - TP_Prime_v2.2_Class_6
P. 43

• 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 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.                          MORE ON EXCEL


                                 Let's Revisit

                 • Excel provides a lot of facilities to modify and process data.


                     You can specify a column width of 0 to 255 and a row height of 0 to 409.
                     The default column width is 8.43 characters and the default row height is 15 points.                 41


                     Combining two or more cells is known as Merging.
                     Splitting cells means to separate two cells that were previously merged.
                     To further enhance your spreadsheet, you can format a number of elements such as text,

                   numbers, colouring, and table styles.

                     You can also customise the worksheet tab.

                     Auto Fill feature automatically fills a series of data in your worksheet.

                     Formulas in Excel begin with an equal (=) sign.
                     Excel calculates expressions within parentheses ‘(‘ , ’)’ first.






                                                    Mind Drill







                    Rapid Fire


                 1.  Tick (✓) the correct option.

                     a.  Home tab includes formatting elements such as ____________.


                         (i)  Text wrap                                (ii)  Merging cells

                         (iii)  Cell style                             (iv)  All of the above
   38   39   40   41   42   43   44   45   46   47   48