Excel Functions Quiz

What does the SUM function do in Excel?

• Adds all numbers in a selected range

• Finds the largest number in a range

• Finds the smallest number in a range

• Counts the number of cells

Which function is used to find the highest value in a range?

• AVERAGE()

• MAX()

• MIN()

• COUNT()

What does the MIN function return?

• The total of all numbers in a range

• The highest number in a range

• The lowest number in a range

• The average of a range

What is the purpose of the AVERAGE function in Excel?

• Finds the highest value in a range

• Finds the lowest value in a range

• Finds the sum of numbers in a range

• Finds the mean of numbers in a range

Which of the following is a correct formula to get the sum of cells A1 to A10?

• =ADD(A1:A10)

• =SUM(A1:A10)

• =TOTAL(A1:A10)

• =COUNT(A1:A10)

If you enter =MAX(4, 8, 2, 10, 5), what will be the result?

• 2

• 4

• 10

• 8

What will =MIN(12, 7, 19, 5, 10) return?

• 12

• 7

• 5

• 10

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

• 10

• 15

• 20

• 25

What is an absolute reference in Excel?

• A reference that changes when copied to another cell

• A reference that remains fixed when copied

• A reference that only applies to formulas

• A reference that calculates absolute values

How do you make a cell reference absolute in Excel?

• Add $ before the column and row (e.g., $A$1)

• Add # before the cell address (e.g., #A1)

• Use ABS(A1)

• Type the reference in bold