Page 55 - Trackpad_ipro 4.1_Class7
P. 55

Spreadsheets—An


                                 Introduction



                                                                                   Chapter
                                                                                   05








                             Your Aim

                             to learn about:
                                Features of Excel 2019                       Starting Excel 2019
                                Components of Excel 2019 Window              Types of Data
                                Creating a New Workbook                      Entering Data in a Worksheet
                                Saving a Workbook

                 We have learnt about Microsoft Word and Microsoft PowerPoint in the previous classes. We know
                 that Word allows us to create and edit documents, and PowerPoint allows us to create and edit
                 effective presentations. In this chapter, we will learn about another important application program
                 of Microsoft Office Suite, called Excel. Excel is the most commonly used interactive spreadsheet
                 program that allows us to perform mathematical calculations, analyse data, and store data in tabular
                 format. We can create charts and graphs from the data and convey more meaningful information.
                 Excel is an especially useful tool for keeping records of sales, bills, and performing mathematical
                 calculations because it can be used for creating electronic spreadsheets using the data.
                     FEATURES OF EXCEL 2019

                 Excel provides several features which make Excel the first choice for professionals to quickly perform
                 lengthy accounting and financial tasks and take immediate decisions. Some of them are as follows:
                    Functions and Formulas: Functions are the built-in formulas used for calculating percentage,
                    interest, average, etc., in Excel. Formulas are mainly used for performing simple as well as
                    complex calculations.
                    Formatting Features: Excel allows the use of formatting features to improve the look and
                    feel of the data.
                    Auto-Calculation: Data is automatically recalculated in the worksheet if any change is made
                    in a single cell.                                   Clickipedia
                    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
                    series using the Auto Fill feature.
                                                                         VisiCalc.
                    Graphically View Data:  In  Excel,  data
                    can be viewed in a graphical form as charts. The charts help understand, analyse and compare
                    data in an effective manner.



                                                                                 Spreadsheets—An Introduction    53
   50   51   52   53   54   55   56   57   58   59   60