Excel Functions (AutoSum, Average, Max, Min)

What function is used to calculate the total sum of numbers in Excel?

• SUM

• TOTAL

• ADD

• COUNT

How do you find the average of a group of numbers in Excel?

• MEAN

• SUM/NUMBER

• MEDIAN

• AVERAGE

Which function returns the maximum value from a set of numbers in Excel?

• UPPER

• HIGHEST

• MAX

• LARGE

What function do you use to find the minimum value in a range of numbers in Excel?

• MIN

• LOWEST

• SMALLEST

• LESS

How can you count the number of entries in a list of numbers in Excel?

• LENGTH

• COUNT

• NUMBER

• SUM

What is the result of using the AVERAGE function on the numbers 84, 92, and 78 in Excel?

• 84

• 84.6667

• 85

• 251.6667

Which of the following is not a function mentioned in the lesson?

• SUM

• DIVIDE

• AVERAGE

• MAX

What feature allows you to quickly calculate the total, average, max, min for all of the columns in Excel?

• AutoFill

• FastCompute

• QuickCalc

• SpeedSum

What is the maximum number from the list 43, 17, 26, and 35?

• 26

• 35

• 43

• 17

What is the correct syntax to use the SUM function in Excel?

• =TOTAL

• TOTAL=

• SUM=

• =SUM