Try Our Exciting Quiz on
COUNT, COUNTA, COUNTIF, and IF Logic with OR/AND!
- Only registered members can participate in this quiz. If you haven’t registered yet, don’t miss out—register now and enjoy the challenge!
- To register, simply go to the “Register” menu at the top of the page.
- Need help? Click this link to watch a complete step-by-step guide on how to register and attempt the quiz.
- The quiz consists of 25 questions, each carrying 1 mark, for a total of 25 marks.
Material:Â Download Study Material
Quiz Summary
0 of 25 Questions completed
Questions:
Information
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You must first complete the following:
Results
Results
0 of 25 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
- Not categorized 0%
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- Current
- Review
- Answered
- Correct
- Incorrect
-
Question 1 of 25
1. Question
1 point(s)What does the formula
=COUNTIFS(A1:A10, ">5", B1:B10, "<10")do?CorrectIncorrect -
Question 2 of 25
2. Question
1 point(s)Which of the following does the COUNT function return?
CorrectIncorrect -
Question 3 of 25
3. Question
1 point(s)What is the result of
=COUNT(1, "Text", 3, TRUE, 5)?CorrectIncorrect -
Question 4 of 25
4. Question
1 point(s)Which of the following is TRUE about the COUNT function?
CorrectIncorrect -
Question 5 of 25
5. Question
1 point(s)What will
=COUNT(A1:A10)do?CorrectIncorrect -
Question 6 of 25
6. Question
1 point(s)Which formula counts only numeric values in the range B2:B20?
CorrectIncorrect -
Question 7 of 25
7. Question
1 point(s)What does
COUNTIF(range, criteria)do?CorrectIncorrect -
Question 8 of 25
8. Question
1 point(s)What is the result of
=COUNTIF(A1:A10, ">5")if the range contains 1, 6, 8, 3, and 10?CorrectIncorrect -
Question 9 of 25
9. Question
1 point(s)What will
=COUNTIF(A1:A10, "*")do?CorrectIncorrect -
Question 10 of 25
10. Question
1 point(s)How does the COUNTIF function treat case sensitivity?
CorrectIncorrect -
Question 11 of 25
11. Question
1 point(s)What will
=COUNTIF(A1:A10, "Apple")return?CorrectIncorrect -
Question 12 of 25
12. Question
1 point(s)What does the IF function do in Excel?
CorrectIncorrect -
Question 13 of 25
13. Question
1 point(s)What is the syntax of the IF function?
CorrectIncorrect -
Question 14 of 25
14. Question
1 point(s)What will
=IF(A1>5, "Yes", "No")return if A1=3?Â
CorrectIncorrect -
Question 15 of 25
15. Question
1 point(s)What happens if the condition in the IF function is omitted?
CorrectIncorrect -
Question 16 of 25
16. Question
1 point(s)What will
=IF(A1=10, "Equal", "Not Equal")return if A1=10?CorrectIncorrect -
Question 17 of 25
17. Question
1 point(s)What is the result of
=IF(OR(A1>10, B1<5), "Pass", "Fail")if A1=8 and B1=3?CorrectIncorrect -
Question 18 of 25
18. Question
1 point(s)Which of these formulas correctly uses IF with OR?
CorrectIncorrect -
Question 19 of 25
19. Question
1 point(s)What will
=IF(OR(A1=5, B1=10), "Match", "No Match")return if A1=5 and B1=8?CorrectIncorrect -
Question 20 of 25
20. Question
1 point(s)What will
=IF(OR(A1>5, A1<3), "Yes", "No")return if A1=4?CorrectIncorrect -
Question 21 of 25
21. Question
1 point(s)How does OR in an IF statement work?
CorrectIncorrect -
Question 22 of 25
22. Question
1 point(s)What is the result of
=IF(AND(A1>10, B1<5), "Pass", "Fail")if A1=15 and B1=2?CorrectIncorrect -
Question 23 of 25
23. Question
1 point(s)Which of these correctly uses IF with AND?
CorrectIncorrect -
Question 24 of 25
24. Question
1 point(s)What will
=IF(AND(A1=5, B1=10), "Match", "No Match")return if A1=5 and B1=8?CorrectIncorrect -
Question 25 of 25
25. Question
1 point(s)What will
=IF(AND(A1>5, A1<10), "Yes", "No")return if A1=7?CorrectIncorrect