Page 20 - TrackpadV2.1_Class8
P. 20

In the previous class, we learnt 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 learnt 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.












                         4  Select the Math & Trig option from
                         the  Or select a category drop-down list.     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.






                   18   Trackpad (V2.1)-VII
   15   16   17   18   19   20   21   22   23   24   25