COUNTIF

COUNTIF

by Adrienne Patt

Multiple Choice

The Microsoft Excel COUNTIF function: ____________

• counts the number of cells in a range, that meets a given criteria.

• Counts ONLY whole numbers in a given range.

• Counts any cell that is blank in a given range.

• Counts cells that contain text only.

Multiple Choice

The COUNTIF function is categorized as a ___________ function.

• Statistical

• Easy

• Mathematical

• Scientific

Multiple Choice

Which of the following is the correct SYNTAX of the COUNTIF FUNCTION.

• =COUNTBLANK(range)

• =COUNTA(range)

• =COUNT(range)

• =COUNTIF( range, criteria )

Multiple Choice

The COUNTIF function returns a numerical value.

• True

• False

Multiple Choice

Look at the picture to the left, which of the following is the correct formula that can be used in order for us to find out how many times the number 2000 is repeated in that set of data.

• =COUNTIF(A2:A7, "YEAR 2000")

• =COUNTIF(A2:A7)

• =COUNTIF(A2:A7, D2)

• =COUNTIF(2000)

Multiple Choice

If I wanted to find how many numbers are greater than 55, what would be the correct formula you would write?

• =COUNTIF(B2:B5,"<>" "55")

• =COUNTIF(B2:B5,">55")

• =COUNTIF(B2:B5,"< 55")

• =COUNTIF(B2:B5,"=55")

Multiple Choice

If in any case I wanted to count the number of words that consist of four characters, which of the following would be the correct formula?

• =COUNTIF(A2:A5,"@@@@")

• =COUNTIF(A2:A5,"&&&&")

• =COUNTIF(A2:A5,"****")

• =COUNTIF(A2:A5,"????")