Page 276 - Trackpad IT-402_Class-IX
P. 276

The advantage of using a formula is that if a number in a cell used as a cell reference in a formula changes, then the
        result is automatically updated which you will learn later in the chapter. Functions simplify the process of calculations
        and can be used to perform simple and complex calculations. Let us now use some of the commonly used functions
        in the given worksheet:

























        •  Sum(): It returns the sum of the given values. For example, Adding up the total amount spent on shopping in the
          above worksheet can be done using different ways as given below:
          =Sum(E7;E8;E9;E10;E11)
          OR
          =Sum(E7:E11)
          OR
          =Sum(E7:E9;E10:E11)
          OR

          =Sum(E7:E10;E11)



                       Subject: To calculate sum

                       Select the cells and click on    icon on the formula bar and the sum of the cells will be automatically
                       calculated. This is another way of adding the selected cells or using the Sum function.




        •  Min(): It returns the minimum value out of the given values. Let us find the minimum price of an article in the above
          worksheet.
          =Min(D7:D11)
          OR
          =Min(D7;D8;D9;D10;D11)
          OR

          =Min(D7:D9;D10:D11)
          OR
          =Min(D7:D10;D11)





          276   Trackpad Information Technology-IX
   271   272   273   274   275   276   277   278   279   280   281