Page 32 - TP_Pluse_V2.2_Class_6
P. 32

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
                   The first spreadsheet           precedence from left to right.
                   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
                         computer.               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.




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

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

                   have upto 1024 fonts.                Formulas in Excel begin with an equal (=) sign.
                    A cell can have upto                Excel calculates expressions within parentheses ‘(‘ , ’)’ first.
                     32,767 characters.




                  30    Plus (Ver. 2.2)-VI
   27   28   29   30   31   32   33   34   35   36   37