Page 17 - Digicode_AI_class_5
P. 17

We have learnt about Word and 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.

            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 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.
               Auto Fill: Entering data in a series using Auto Fill 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.


                                                                               Introduction to Excel 2016  15
   12   13   14   15   16   17   18   19   20   21   22