Question

Define the given functions with syntax: (a) SUM (b) AVERAGE (c)COUNT (d) MAX (e)MIN​

Answer 1

Answer:

Sum:- Adds the values contained in the range of cells

Average:- Finds the average of number in a given range

Count:- To count the number of alls containing numeric values

Max:- To find the maximum value in the specific range

Min:- To find the minimum value in the specific range

Syntax:-

= SUM(Number 1, Number 2, ..)

= AVERAGE(Number 1, Number 2, ..)

= MAX(Number 1, Number 2, ..)

= MIN(Number 1, Number 2, ..)

= COUNT(Number 1, Number 2, ..)