Page 19 - Trackpad_V5_Book 7
P. 19

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 & 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.











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












               5  Select the SUM function.







                               6  Click on the OK button.                               8  Click on the OK button.






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