Page 19 - Chinmaya_C7_flipbook
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