Page 18 - ThinkGPT_V2.1_C5_Flipbook
P. 18

We have learnt about Word and PowerPoint in the previous classes. We know that Word
                  allows  us  to  create  and  edit  documents,  while  PowerPoint  allows  us  to  create  and  edit
                  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 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.

                  Features of Excel 2016

                  Excel provides several features that make it 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 used for performing simple as               The first electronic
                     well as complex calculations.                                           spreadsheet software
                     Formatting Features: Excel allows the use of formatting               was released in 1979. It
                     features to improve the look of the data.                                was called VisiCalc.
                     Auto-Calculation: Data  is automatically recalculated  in
                     the worksheet if any change is made in a single cell.
                     Fast Searching: Fast searching and instant replacing of data.
                     AutoFill: Entering data in a series using AutoFill feature.

                     Graphically View Data: Data can be viewed in a graphical form as charts. The charts
                     help us to understand, analyse and compare data in an effective manner.

                  Starting Excel 2016

                  To open Excel 2016, follow the given steps:



                              2  Scroll to find
                             Excel 2016 and
                             click on it.











                              1   Click on  the
                             Start button.





                       16    Premium Edition-V
   13   14   15   16   17   18   19   20   21   22   23