Question

what do the following functions do? Explain with proper syntax with an example of each.
(a) sum (b) average (c) max​

Answer 1

Answer:

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

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

•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

Answer:

hey

how are you

can we meet once

yov-fdej-vvh