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

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