Page 21 - Trackpad_V2.1_Class6
P. 21

FORMULAS AND FUNCTIONS                                                                   CHAPTER


                 IN EXCEL 2016                                                                              2




















                                                                            Topics Covered                      95%

                                                                                Data Types in Excel 2016
                                 Hello Techie! What else can I do in            Operators in Excel 2016
                                 Excel  other  than  collecting data            Operators Precedence
                                 or maintaining records?                        Ways to Enter a Formula in Excel 2016
                                                                                Cell Range
                                                                                Cell Reference
                                                                               Functions






                 Dear Aadya, an Excel worksheet is merely a lifeless collection of numbers and text
                 until you define some kind of relationship among the various entries. We do this by
                 applying formulas that perform calculations and produce results.











                                  Really, Techie? Can I really apply formulas in Excel and perform calculations?









                 Yes, dear Aadya. This chapter will take you through some formula basics, including
                 construction of simple arithmetic formulas and many other important concepts.
                 Let’s begin!








                                                                                 Formulas and Functions in Excel 2016  19
   16   17   18   19   20   21   22   23   24   25   26