CountIf Function

One of these function is not a valid Countif function

• =countif(A2:A5,"h+*")

• =countif(A2:B5,"h+*")

• =countif(A2:A5,"h*")

• =countif(A2:A5,">7*")

the countif function uses 2 arguments

• False

• True

The first argument in countIf function is criteria

• True

• False

The asterisk symbol replaces:

• one letter

• two letters

• Four letters

• Many letters

Two asterisk ** replaces

• two times the number of letter that replaces One asterisk

• Tree time the number of letter that replaces One asterisk

• Four times the number of letter that replaces One asterisk

• Its the same thing

Which one of these functions gives the result shown in the picture?

• =COUNTIF(D5:D13,"<>10")

• =COUNTIF(D5:D13,"<15")

• =COUNTIF(D5:D13,"=16")

• =COUNTIF(D5:D13,">=10")

• =COUNTIF(D5:D13,">=15")

Show all names starting with a

• =COUNTIF(D5:D13,"a")

• =COUNTIF(D5:D13,"?a")

• =COUNTIF(D5:D13,"a?*")

• =COUNTIF(D5:D13,"a*")

Show all names having 6 letters as length, as second letter h and as fifth letter g

• =COUNTIF(D5:D13,"*h*g")

• =COUNTIF(D5:D13,"*h*g*")

• =COUNTIF(D5:D13,"?h*g")

• =COUNTIF(D5:D13,"*h***g")

• =COUNTIF(D5:D13,"?h??g?")

show al address that contain ab

• =COUNTIF(D5:D13,"*a*b")

• =COUNTIF(D5:D13,"*ab")

• =COUNTIF(D5:D13,"ab*")

• =COUNTIF(D5:D13,"*ab*")

• =COUNTIF(D5:D13,"?ab?")

show blank cells

• =COUNTIF(D5:D13,"")

• =COUNTIF(D5:D13," *")

• =COUNTIF(D5:D13," ?")

• =COUNTIF(D5:D13,"<>"&"")