Excel Functions Quiz 280324

If you want to count the number of cells with numeric data in a range A1:A10, which function would you use?

• COUNT(A1:A10)

• COUNTA(A1:A10)

• COUNTBLANK(A1:A10)

• SUM(A1:A10)

Which function would return the smallest number in the range C1:C10?

• MIN(C1:C10)

• MAX(C1:C10)

• AVERAGE(C1:C10)

• COUNT(C1:C10)

What does the function COUNTBLANK(range) do?

• Counts the number of numeric values in the range.

• Counts the number of non-numeric values in the range.

• Counts the number of blank or empty cells in the range.

• Sums the numeric values in the range.

If you have a list of values in A1:A5 and you want to sum only the values greater than 50, which formula is correct?

• SUMIF(A1:A5, ">50")

• SUM(A1:A5, ">50")

• COUNTIF(A1:A5, ">50")

• AVERAGEIF(A1:A5, ">50")

If cells A1, A2, and A3 contain the numbers 3, 7, and 8 respectively, what will the formula =MIN(A1:A3) return?

• 3

• 7

• 8

• 18

How would you calculate the average value of cells in the range B1:B5?

• SUM(B1:B5)/5

• COUNT(B1:B5)

• AVERAGE(B1:B5)

• MIN(B1:B5)

You need to remove leading and trailing spaces from a text string in cell A1. Which function would you use?

• LEN(A1)

• TRIM(A1)

• MIN(A1)

• COUNTA(A1)

If cell A1 contains the value 5 and cell A2 contains the value 10, what will the formula =MAX(A1, A2) return?

• 5

• 10

• 15

• 2

What does the SUMIF function do?

• Sums up all the numbers in a range.

• Sums up numbers in a range based on a single criterion.

• Counts the number of cells that meet a certain condition.

• Returns the average of a group of numbers.

What does the LEN function return when used on the text string "Hello World"?

• 10

• 11

• 12

• The number of words in the text string.