Review Quiz

Which function should you use to count all non-blank cells in a range?

• COUNT

• COUNTA

• COUNTIF

• AVERAGE

What is the purpose of the COUNTIF function?

• To count cells that meet a specific condition

• To count all numbers in a range

• To sum a range of numbers

• To calculate the average of a range

What does the formula =MIN(A1:A10) return?

• The largest number in A1 to A10

• The sum of A1 to A10

• The smallest number in A1 to A10

• The average of A1 to A10

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

• 25

• 30

• 35

• 40

Which function should you use to count the number of blank cells in a range?

• COUNT

• COUNTA

• COUNTBLANK

• COUNTIF

In the formula: =SUMIF(D5:D14, "Pumpkin", E5:E14), which range will be added?

• D5:D14

• "Pumpkin"

• E5:E14

• None of the above

In the formula: =SUMIF(D5:D14, "Pumpkin", E5:E14), which part represents the criteria?

• D5:D14

• "Pumpkin"

• E5:E14

• None of the above

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

• D5:D14

• "Pumpkin"

• E5:E14

• None of the above

Which function returns one value if a condition is true and a different value if the condition is false?

• AND

• OR

• IF

• SUM

XLOOKUP allows you to search for values horizontally.

• TRUE

• FALSE