Page 33 - Plus_V2.2_C6_Flipbook
P. 33

ORDER OF OPERATION                                                           Factopedia


                 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.                                              The first spreadsheet
                                                                                              software was VisiCalc
                 For example, the formula = 10 + 10 * 2 gives a result of 30 as Excel            launched in 1979
                 multiplies 10 by 2 and then adds 10.                                          designed for Apple II

                 However, the formula =(10 + 10)*2 produces a result of 40. This is because         computer.
                 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.



                                                                                                Charles Simonyi is
                           Let’s BaCk-uP                                                        called the father of
                                                                                                 Excel software.
                       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.

                       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.
                       AutoFill  feature  automatically  fills a  series  of data  in  your

                      worksheet.                                                                A spreadsheet can
                       Formulas in Excel begin with an equal (=) sign.                         have upto 512 fonts.

                                                                                               A cell can have upto
                       Excel calculates expressions within parentheses ‘(‘ , ’)’ first.
                                                                                                32,767 characters.





                                                                                              More on Excel 2016   31
   28   29   30   31   32   33   34   35   36   37   38