SUM, AVERAGE, MAX and MIN Functions in Excel

What does the =MAX(A1:A5) function do?

• Finds the average of the numbers in A1 to A5

• Finds the smallest number in A1 to A5

• Finds the largest number in A1 to A5

• Adds all the numbers in A1 to A5

Which function would you use to find the smallest value in a set of numbers?

• =LARGE()

• =MIN()

• =LOWEST()

• =SMALL()

What will =SUM(10, 20, 30) return?

• 70
• 50
• 60
• 90

Which formula correctly calculates the average of the values in cells A1 through A4?

• =AVERAGE(A1:A4)
• =AVERAGEIF(A1:A4,">0")
• =SUM(A1:A4)/4
• =MEAN(A1:A4)

Which of the following is the correct syntax for the MAX function?

• MAX(A1-A10)

• =MAX(A1:A10)

• =MAXIMUM(A1:A10)

• =MAXIMUM(A1-A10)

What does =AVERAGE(5, 10, 15) return?

If cells A1 = 5, A2 = 3, A3 = 8, what does =MIN(A1:A3) return?

Which function adds all the values in a range?

• AVERAGE

• MAX

• SUM

• MIN

If B1 = 6, B2 = 12, and B3 = 18, what will =AVERAGE(B1:B3) return?

Which function returns the largest number from the given arguments?

• =MIN(10, 20, 5)

• =AVERAGE(10, 20, 5)

• =MAX(10, 20, 5)

• =SUM(10, 20, 5)