Page 57 - iPlus_Ver_2.0_class_7
P. 57

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 very important for those who maintain accounts for sales, bills,

                 or do mathematical calculations as it is used to create electronic spreadsheets using the data.

                  i +  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 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.






                                                                                                                  55
                                                                                  Spreadsheets—An Introduction
   52   53   54   55   56   57   58   59   60   61   62