Conditional Formatting Using Both And and OR Formulas
Time limit: 0
Quiz Summary
0 of 1 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 1 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)
| Average score |
|
| Your score |
|
Categories
- Not categorized 0%
-
Dear Participant, thank you for taking the test.
- 1
- Current
- Review / Skip
- Answered
- Correct
- Incorrect
-
Question 1 of 1
1. Question
100 point(s)Match the following columns based on the data set given below:
Sort elements
- =AND(($F2="Yes"), OR($D2="Music", $D2="Theatre", ($E2="Kolkata"))
- =AND(($E2="Kolkata", $F2="No"), OR($D2="Music"))
- =AND($D2="Theatre", $F2="Yes"), OR($E2="Kolkata")
-
1. A student doing music or theatre and living in Kolkata
-
A person living in Kolkata and who is not a student or is doing Music
-
A person who is a student and is doing theatre or living in Kolkata
CorrectIncorrect
