Page 19 - Trackpad_V1_Book 7_Flipbook
P. 19

In the previous class, we have 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 & 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 Insert
                    Function option.



                                                                                                          1  Select
                                                                                                         the cell.













                           5  Click on Or select a category option
                          and select the Math & Trig option.            7  To calculate the average of numbers
                                                                       in cells C2 to H2, the range must be
                                                                       specified as C2:H2 in the Number1 box.













                        4  Select SUM function.






                                       6  Click OK button.                                   8  Click OK button.






                                                                                         Advanced Features of Excel  17
   14   15   16   17   18   19   20   21   22   23   24