Page 54 - iPrime_V2.2_class7
P. 54

5                                 Spreadsheets—




                                                               An Introduction










                       Chapter Profile

                          Features of Excel 2016                              Starting Excel 2016
                          Components of Excel 2016 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 2016

                  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 to use formatting features to improve the look and feel of
                     the data.
                      Auto-Calculation: Data  is automatically           Clickipedia
                     recalculated in the worksheet if any change
                     is made in a single cell.
                                                                          The first electronic spreadsheet software
                      Fast Searching: Fast searching and instant
                                                                          was  released  in 1979.  It was  called
                     replacing of data can be performed by Excel.
                                                                          VisiCalc.
                      Auto Fill: Data in a series can be entered
                     using the Auto Fill feature.
                      Graphically View Data: Data can be viewed in a graphical form as charts. The charts help to
                     understand, analyse and compare data in an effective manner.



                  52     Touchpad iPRIME (Ver. 2.2)–VII
   49   50   51   52   53   54   55   56   57   58   59