Page 59 - TP_iPlus_V2.1_Class7
P. 59

Spreadsheets—An



                    Introduction
                                                                                              5













                         Learning Outcomes


                              Features of Excel 2016                             Starting Excel 2016

                              Components of Excel 2016 Window                    Types of Data

                              Creating a New Workbook                            Entering Data in the 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.

                  i +  FEATURES OF EXCEL 2016

                 Excel provides several features which make it the first choice for professionals to quickly perform
                 extensive 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.
                                                                    Info Byte
                 •  Auto-Calculation: Data is automatically
                    recalculated  in  the  worksheet  if  any       The  first  electronic  spreadsheet  software
                    change is made in a single cell.                was released in 1979. It was called VisiCalc.




                                                                                                                  57
                                                                                  Spreadsheets—An Introduction
   54   55   56   57   58   59   60   61   62   63   64