Question

8) Explain the usage of MAX and AVERAGE function. *​

Answer 1

Answer:

MAX

The Microsoft Excel MAX function returns the largest value from the numbers provided. The MAX function is a built-in function in Excel that is categorized as a Statistical Function. It can be used as a worksheet function (WS) in Excel.

AVERAGE

The Microsoft Excel AVERAGE function returns the average (arithmetic mean) of the numbers provided. The AVERAGE function is a built-in function in Excel that is categorized as a Statistical Function. It can be used as a worksheet function (WS) in Excel.

Answer 2

Answer:

MAX [maximum]To function returns the largest value in a set of values.

AVERAGE function calculates the average of certain values of cells in MS-Excel.