Page 53 - iPro_trackGPT_V5_Class7
P. 53

Spreadsheets—An                                                         5


                                 Introduction











                     Goal Glimpse

                         Features of Excel 2021                                 Starting Excel 2021

                         Components of Excel 2021 Window                        Types of Data
                         Creating a New Workbook                                Entering Data in the Worksheet

                         Saving a Workbook




                 In previous classes, we've covered Microsoft Word and Microsoft PowerPoint—Word for creating
                 and editing documents, and PowerPoint for designing impactful presentations. Now, we will
                 explore another key application in the Microsoft Office Suite: Excel. Excel is a widely used interactive
                 spreadsheet program that enables us to perform mathematical calculations, analyse data, and
                 organise information in a tabular format. With Excel, we can also create charts and graphs to present
                 data  more  effectively.  Excel  is  particularly  valuable  for  those  managing  accounts,  sales,  bills,  or
                 performing complex calculations, as it allows for the creation of electronic spreadsheets.

                    FEATURES OF EXCEL 2021
                 Excel offers a range of features that make it the first choice for professionals to efficiently handle
                 complex accounting and financial tasks, enabling them to make quick decisions. Some of them are
                 as follows:
                    Functions and Formulas:  Functions  are  built-in  formulas  in  Excel  used  for  calculating
                    percentages, interest, averages, and more. Formulas are primarily used for both simple and
                    complex calculations.
                    Formatting Features: Excel allows the use of formatting features to enhance the appearance
                    of the data.
                    Auto-Calculation: Data is automatically recalculated in the worksheet if any change is made
                    in a single cell.                                        Boost Bits
                    Fast Searching:  Excel  allows  fast  searching
                    and instant replacing of data.                     The  first  electronic  spreadsheet  software
                    Auto Fill: Excel allows entering data in a         was released in 1979. It was called VisiCalc.
                    series using Auto Fill feature.
                    Graphically View Data: In Excel, data can be displayed as charts, which make it easier to
                    understand, analyse, and compare information effectively.


                                                                                Spreadsheets—An  Introduction    51
   48   49   50   51   52   53   54   55   56   57   58