Question

Your friend is having good knowledge of Mathematics. He is already using different functions like Max, Min, Sum, and Average. (a) How can we use these functions in MS Excel ? (b) What are the advantages of using these functions?

Answer 1

Answer:

For Max, =max(cell:other cell)

For Min, =min(cell:other cell)

For Sum, =sum(cell:other cell)

For Average, =average(cell:other cell)

Explanation:

Hope it is helpful!