Question

What do the following functions do? Explain the proper syntax with an example of each. 1.sum
2.Average
3. Min
4. Max

Answer 1

1.SUM

This function adds values. You can add individual values, cell references or ranges or a mix of all three.

Example : =SUM(A2:A10) Adds the values in cells A2:10.

2.AVERAGE

This function calculates the average (arithmetic mean) of a group of numbers. The AVERAGE function ignores logical values, empty cells and cells that contain text.

Example : =AVERAGE(A1:A20) returns the average of those numbers.

3.MIN

It 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.

Example : =MIN(A2:A6)  Smallest of the numbers in the range A2:A6.

4.MAX

will return the largest value in a given list of arguments. From a given set of numeric values, it will return the highest value. Unlike MAXA function, the MAX function will count numbers but ignore empty cells, text, the logical values TRUE and FALSE, and text values.

Example : =MAX(A2:A6)  Largest value in the range A2:A6.

Have a Great Day Ahead :)