Excel Functions

Question 1

AVERAGE Function

Answer 1

=AVERAGE(B2:B28)

Question 2

SUM Function

Answer 2

=SUM(B2:B28)
Sum is a function that allows us to sum numbers easily.

Question 3

MAX Function

Answer 3

=MAX(B2:B28)
-MAX function is used when we want to find the maximum value within a range of cells.

Question 4

MIN Function

Answer 4

=MIN(B2:B28)
-MIN function is the opposite of MAX function, and it’s used when we want to find the minimum value within a range of cells.

Question 5

MEDIAN Function