Excel Functions Quiz

Which function is used to count the number of cells that contain any kind of data?

• COUNT

• COUNTA

• COUNTBLANK

• COUNTIF

Which of the following functions will count the number of blank cells in a range?

• COUNT

• COUNTBLANK

• COUNTA

• COUNTIF

If you want to find the average value of a range, which function should you use?

• SUM

• AVERAGE

• COUNT

• MAX

Which of the following formulas will find the largest value in a range of cells from B1 to B10?

• =LARGEST(B1:B10)

• =MAX(B1:B10)

• =HIGHEST(B1:B10)

• =BIGGEST(B1:B10)

To sum a range of cells that meet a specific condition, which function should be used?

• SUMIF

• AVERAGEIF

• COUNTIF

• SUM

If you wanted to round a number in cell A1 to two decimal places, which formula would you use?

• =ROUND(A1, 2)

• =ROUNDUP(A1, 2)

• =ROUNDDOWN(A1, 2)

• =ROUND(A1, 0)

What will the formula =LEN("Hello") return?

• 5

• 4

• 6

• 0

Which Excel function will help you find the smallest number in a given range?

• MIN

• MAX

• COUNT

• AVERAGE

If you need to check if a condition is TRUE or FALSE, which function would you use?

• IF

• AND

• OR

• NOT

Which formula would you use to calculate the sum of cells from B1 to B5?

• =SUM(B1:B5)

• =SUMIF(B1:B5)

• =TOTAL(B1:B5)

• =SUM(B1, B2, B3, B4, B5)