Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 47 - 2611_SmartGPT Pro V(5.0) C-5
P. 47

    CHARTS, FORMULAS &                                                                       CHAPTER

                     FUNCTIONS IN EXCEL                                                                         3

                                      Hello Techie! What else                   Topics Covered                      95%

                                      can I do in Excel other than                  Understanding Cell Range
                                      collecting data or maintaining                Using Charts
                                      records?                                      Types of Data in Excel

                                                                                    Using Formulas to Perform Calculation
                                                                                    Order of Operation
                                                                                    Cell Referencing in Formulas and Its Types
                                                                                    References to Other Worksheets
                                                                                    Functions

                     Dear Aadya, an Excel worksheet is simply a collection of numbers and

                     text. However, when you create connections between these entries using
                     formulas, it allows you to perform calculations and get results. You can also
                     use charts to display your data in a more visual way.

                                        Really, Techie? Can I actually apply formulas in Excel to perform

                                        calculations? And what’s the point of creating charts in Excel?

                     Yes, Aadya. This chapter covers basic formulas and other key concepts.
                     Charts help turn data into visuals, making trends, comparisons, and
                     patterns easier to understand.

                     Let’s begin!

                                                                                     Charts, Formulas & Functions in Excel  45

| 42 43 44 45 46 47 48 49 50 51 52 |