CBSE-IX-Foundation percent 20of%20Information%20Technology%20.
11: MS-Excel 2007
- #2Explain any five functions that can be used in a worksheet.Ans : 1. SUM Function
This function, as clear from name, is used to add all the values provided as argument and to display the result in the cell containing function.
Argument Type All Numbers Return Type Number
Syntax = SUM(numberl, number2, )
e.g. if you want to display the sum of values of cells Al, A2, A5 and A6 in cell A9, then you need to simply type = SUM(A1,A2,A5,A6) in cell A9 and press Enter.
The sum will be displayed in cell A9. If you want to add a range of values, then provide that range in SUM function as an argument.
e.g. if you want to add values from Al to A5, then write like =SUM(A1:A5).
- If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical values or text in the array or reference are ignored.
- If any arguments are error values or if any arguments are text that cannot be translated into numbers, Excel displays an error.
2. AVERAGE Function
This function calculates the average of all the values provided as argument to this function.
Argument Type All Numbers Return Type Number
Syntax = AVERAGE(numberl, number2, )
e.g. to calculate the average of the values of range starting from Al to A5 in cell B9, you need to write = AVERAGE(A1:A5) in cell B9. - If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical values or text in the array or reference are ignored.