Page 21 - trackpad v5.1 class 6 flipbook
P. 21

FORMULAS AND FUNCTIONS                                                                   CHAPTER


                 IN EXCEL 2021                                                                              2




















                                                                            Topics Covered                      95%

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






                 Dear Aadya, an Excel worksheet is merely a collection of lifeless 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 2021  19
   16   17   18   19   20   21   22   23   24   25   26