Question

1. What do the following functions do? Explain the proper syntax with an example of each
(a) SUM
(b) AVERAGE
(c) MIN
(d) MAX​

Answer 1

$\huge\fcolorbox{black}{lime}{♡︎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)The AVERAGE function in Excel calculates the average (arithmetic mean) of a group of numbers. The AVERAGE function ignores logical values, empty cells and cells that contain text.

(c)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.

(d)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.

Answer 2

See this attachment your answer is in this.

This is correct answer it will helpful to you.