Question

II)Write the use, syntax and give one example of the following Excel function :
a) Sum ( )
b) Average ( )
c) Max ( )
d) Min ( )

PLEASE ANSWER IT IMMEDIATELY :)

Answer 1

Answer:

a) Sum ( ) - It is being used for adding values in particular range of cells.

example : Sum(C4:E4)

b) Average ( ) - It is used for finding the average of a particular range of cells.

example : Average (C4:E4)

c) Max ( ) - It is used for finding the maximum value in a particular range of cells.

example : Max(C4:E4)

d) Min ( ) - It is used for finding the minimum value in a particular range of cells.

example : Min(C4:E4)

Hope it helps