Page 49 - KEC Khaitan C6 Flipbook
P. 49

ADVANCED FEATURES                                                                        CHAPTER


                 OF EXCEL                                                                                A4
















                    LEARNING OUTCOMES                                                                            95%

                    The student will be able to:
                       understand the SUM() function.
                       understand the IF() function.
                       sort data in excel.
                       filter data in excel.
                       understand conditional formatting.


                 In the previous class, we learned that Excel is a spreadsheet software used to work with numbers,
                 text, formulae and charts. Excel is used when there is a need to handle large sets of data that
                 require various calculations and in-depth analysis. Since we have already learned how to work
                 with formulae and functions present in the application. Let’s recall some functions and also learn
                 some more useful features of Excel.



                           SUM()


                 The SUM() function calculates the total of a given set of values. To use the SUM() function, follow
                 the given steps:

                                               2  Click on the Formulas tab.



                   3  Click on the Insert
                   Function command.






                                                                                                        1  Select
                                                                                                       the cell.












                                                                                         Advanced Features of Excel  47
   44   45   46   47   48   49   50   51   52   53   54