Have an account?
Skip to Content
Build your own quiz
Suggestions for you
12 questions
Show Answers
See Preview
- 1. Multiple Choice
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*")
- 2. Multiple Choice
the countif function uses 2 arguments
False
True
- 3. Multiple Choice
The first argument in countIf function is criteria
True
False
- 4. Multiple Choice
The asterisk symbol replaces:
one letter
two letters
Four letters
Many letters
- 5. Multiple Choice
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
- 6. Multiple Choice
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")
- 7. Multiple Choice
Show all names starting with a
=COUNTIF(D5:D13,"a")
=COUNTIF(D5:D13,"?a")
=COUNTIF(D5:D13,"a?*")
=COUNTIF(D5:D13,"a*")
- 8. Multiple Choice
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?")
- 9. Multiple Choice
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?")
- 10. Multiple Choice
show blank cells
=COUNTIF(D5:D13,"")
=COUNTIF(D5:D13," *")
=COUNTIF(D5:D13," ?")
=COUNTIF(D5:D13,"<>"&"")
- 11. Multiple Choice
show all non blank cells
=COUNTIF(D5:D13,"")
=COUNTIF(D5:D13,"*")
=COUNTIF(D5:D13,"?")
=COUNTIF(D5:D13,"<>"&"")
- 12. Multiple Choice
=countblank(C2:D3) counts blank cells
False
True
- Answer choicesTagsAnswer choicesTags