Question

Explain the following functions of MS-EXCEL with proper syntax and

example of each:

a) SUM() b) AVERAGE() c) COUNT()

d) MIN() d) IF()​

Answer 1

Answer:

a) The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three .For example: =SUM(A2:A10) Adds the values in cells A2:10.

b) Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.

c) The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers.

d) MIN will return the minimum value in a given list of arguments. From a given set of numeric values, it will return the smallest value. Unlike the MINA function, the MIN function ignores numbers, text, and logical values TRUE and FALSE and text values.

e) Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it's false. For example: =IF(A2>B2,"Over Budget","OK") =IF(A2=B2,B4-A4,"")

Hope this helps you.