Excel Functions Quiz

If you want to count all non-empty cells in a range, which function should you use?

• COUNT

• COUNTA

• COUNTIF

• AVERAGE

What does the COUNTIF function do?

• Counts cells based on a specific condition

• Counts all numbers in a range

• Sums a range of numbers

• Finds the average of a range

If you apply the formula =MIN(A1:A10), what are you looking for?

• The maximum number in A1 to A10

• The sum of A1 to A10

• The smallest number in A1 to A10

• The average of A1 to A10

What will the formula =AVERAGE(A1:A5) return if A1=10, A2=20, A3=30, A4=40, A5=50?

• 25

• 30

• 35

• 40

If you wanted to find out how many cells are blank in a range, which function would you use?

• COUNT

• COUNTA

• COUNTBLANK

• COUNTIF

In the formula: =SUMIF(D5:D14,"Pumpkin",E5:E14). Which of the following is the range of cells to be added?

• All incorect

• D5:D14

• "Pumpkin"

• E5:E14

In the formula: =SUMIF(D5:D14,"Pumpkin",E5:E14). Which of the following is the criteria?

• All incorect

• D5:D14

• "Pumpkin"

• E5:E14

In the formula: =SUMIF(D5:D14,"Pumpkin",E5:E14). Which range is where the criteria should be located?

• All incorect

• D5:D14

• "Pumpkin"

• E5:E14

Which of the following functions returns one value if a condition is true and a different value when the condition is not true?

• AND

• OR

• IF

• SUM

XLOOKUP can search for values horizontally.

• TRUE

• FALSE