Excel Functions Quiz

What does the COUNTA function do in Excel?

• Counts all cells with numbers only

• Counts all non-empty cells

• Counts cells that are blank

• Counts cells with errors

Which formula will return the count of numeric entries in the range A1?

• =COUNTA(A1:A10)

• =COUNT(A1:A10)

• =SUM(A1:A10)

• =IF(A1:A10)

Which formula correctly counts the number of cells in range B1 that are greater than 50?

• =COUNTIF(B1:B10, "50")

• =COUNTIF(B1:B10, ">50")

• =COUNT(B1:B10, ">50")

• =COUNTA(B1:B10, ">50")

What will the formula =IF(A1 > 100, "High", "Low") return if the value in A1 is 75?

• "High"

• "Low"

• 100

• TRUE

What does the formula =SUMIF(A1:A10, "Apples", B1:B10) do?

• Sums all values in A1

• Sums the values in B1 where corresponding cells in A1 are "Apples"

• Counts the number of "Apples" in A1

• Returns the average of values in B1

If you want to count how many cells in B1 are greater than 10 and less than 50, which formula would you use?

What will the formula =IF(A1 > 100, "High", IF(A1 > 50, "Medium", "Low")) return if A1 is 75?

• "High"

• "Medium"

• "Low"

• "Error"

In the formula =SUMIF(C1:C10, "<100", D1:D10), what does the criteria "<100" mean?

• Sum values equal to 100

• Sum values greater than 100

• Sum values less than 100

• Count values less than 100

If you want to count how many times the word "Yes" appears in the range A1, which formula would you use?

• =COUNTIF(A1:A10, "Yes")

• =COUNTA(A1:A10, "Yes")

• =COUNT(A1:A10, "Yes")

• =SUMIF(A1:A10, "Yes")

What does the formula =SUMIF(A1:A10, "A*", B1:B10) do?

• Sums values in B1 where corresponding cells in A1 start with "A"

• Sums all values in A1

• Counts cells that start with "A"

• Sums all values in B1