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

