Count and IF Formula

Count and IF Formula

Microsoft Excel 2021 -Free Course Session-1

Time limit: 0

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

Quiz complete. Results are being recorded.

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%

Would you like to submit your quiz result to the leaderboard?

Loading

Name: E-Mail:

Captcha:

captcha

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?
- What does the formula =COUNTA(A1:A10) do?
- Counts blank cells in the range A1:A10.
- Counts all non-empty cells in the range A1:A10, including text, numbers, and errors
- Counts only text values in the range A1:A10.
Correct

Incorrect
Question 2 of 25

2. Question
1 point(s)
Which of the following does the COUNT function return?
- Total number of characters
- Total number of numeric values
- Total number of blank cells
- Total number of non-numeric values
Correct

Incorrect
Question 3 of 25

3. Question
1 point(s)
What is the result of =COUNT(1, "Text", 3, TRUE, 5)?
- 3
- 5
- 4
- 2
Correct

Incorrect
Question 4 of 25

4. Question
1 point(s)
Which of the following is TRUE about the COUNT function?
- It ignores blank cells and text
- It only works on text.
- It counts logical values like TRUE/FALSE.
- It counts text and numeric values.
Correct

Incorrect
Question 5 of 25

5. Question
1 point(s)
What will =COUNT(A1:A10) do?
- Count all cells in the range A1 to A10.
- Count only numeric cells in the range A1 to A10.
- Count only text values in the range A1 to A10.
- Count blank cells in the range A1 to A10.
Correct

Incorrect
Question 6 of 25

6. Question
1 point(s)
Which formula counts only numeric values in the range B2:B20?
- =COUNT(B2:B20)
- =COUNTA(B2:B20)
- =COUNTIF(B2:B20, ">0")
- =COUNTBLANK(B2:B20)
Correct

Incorrect
Question 7 of 25

7. Question
1 point(s)
What does COUNTIF(range, criteria) do?
- Counts cells with numeric values in the range.
- Counts cells that meet the specified criteria.
- Counts blank cells in the range.
- Counts all cells in the range.
Correct

Incorrect
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?
- 3
- 2
- 4
- 5
Correct

Incorrect
Question 9 of 25

9. Question
1 point(s)
What will =COUNTIF(A1:A10, "*") do?
- Count all numeric values.
- Count all text values.
- Count all non-blank cells.
- Count all blank cells.
Correct

Incorrect
Question 10 of 25

10. Question
1 point(s)
How does the COUNTIF function treat case sensitivity?
- It is case-sensitive.
- It is not case-sensitive.
- Only considers uppercase text.
- Only considers lowercase text.
Correct

Incorrect
Question 11 of 25

11. Question
1 point(s)
What will =COUNTIF(A1:A10, "Apple") return?
- The count of cells containing "Apple" (case-sensitive).
- The count of cells containing "Apple" (case-insensitive).
- Counts numeric values in A1:A10.
- Counts blank cells in A1:A10.
Correct

Incorrect
Question 12 of 25

12. Question
1 point(s)
What does the IF function do in Excel?
- Evaluates whether a condition is TRUE or FALSE.
- b) Performs arithmetic calculations.
- c) Counts numeric values.
- Converts text to numbers.
Correct

Incorrect
Question 13 of 25

13. Question
1 point(s)
What is the syntax of the IF function?
- =IF(condition)
- =IF(condition, value_if_true, value_if_false)
- =IF(value_if_true, condition, value_if_false)
- =IF(condition, value_if_false)
Correct

Incorrect
Question 14 of 25

14. Question
1 point(s)
What will =IF(A1>5, "Yes", "No") return if A1=3?
- Yes
- No
- TRUE
- FALSE
Correct

Incorrect
Question 15 of 25

15. Question
1 point(s)
What happens if the condition in the IF function is omitted?
- Returns an error.
- Always returns the value_if_true.
- Returns FALSE.
- Returns TRUE.
Correct

Incorrect
Question 16 of 25

16. Question
1 point(s)
What will =IF(A1=10, "Equal", "Not Equal") return if A1=10?
- Equal
- Not Equal
- TRUE
- 10
Correct

Incorrect
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?
- Pass
- Fail
- Error
- None
Correct

Incorrect
Question 18 of 25

18. Question
1 point(s)
Which of these formulas correctly uses IF with OR?
- =IF(AND(A1>10, B1<5), "Pass", "Fail")
- =IF(OR(A1>10, B1<5), "Pass", "Fail")
- =IF(A1>10 OR B1<5, "Pass", "Fail")
- =IF(OR(A1>10 B1<5), "Pass", "Fail")
Correct

Incorrect
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?
- Match
- No Match
- Error
- FALSE
Correct

Incorrect
Question 20 of 25

20. Question
1 point(s)
What will =IF(OR(A1>5, A1<3), "Yes", "No") return if A1=4?
- Yes
- No
- TRUE
- FALSE
Correct

Incorrect
Question 21 of 25

21. Question
1 point(s)
How does OR in an IF statement work?
- Returns TRUE only if all conditions are TRUE.
- Returns TRUE if any condition is TRUE.
- Returns FALSE if any condition is TRUE.
- Returns an error if no conditions are met.
Correct

Incorrect
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?
- Pass
- Fail
- Error
- None
Correct

Incorrect
Question 23 of 25

23. Question
1 point(s)
Which of these correctly uses IF with AND?
- =IF(AND(A1>10, B1<5), "Pass", "Fail")
- =IF(OR(A1>10, B1<5), "Pass", "Fail")
- =IF(A1>10 AND B1<5, "Pass", "Fail")
- =IF(AND(A1>10 B1<5), "Pass", "Fail")
Correct

Incorrect
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?
- Match
- No Match
- Error
- FALSE
Correct

Incorrect
Question 25 of 25

25. Question
1 point(s)
What will =IF(AND(A1>5, A1<10), "Yes", "No") return if A1=7?
- Yes
- No
- TRUE
- FALSE
Correct

Incorrect

Login
Sign Up

Remember me Forgot Password?

I accept the Terms of Service and Privacy Policy

Subscribe to our newsletter

Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

body::-webkit-scrollbar { width: 7px; } body::-webkit-scrollbar-track { border-radius: 10px; background: #f0f0f0; } body::-webkit-scrollbar-thumb { border-radius: 50px; background: #dfdbdb }

Login

Accessing this course requires a login. Please enter your credentials below!

Username or Email Address

Password

Remember Me

Lost Your Password?