ASSIGNMENT – 22
Use of Formula – AND
Student Examination Report
Enter the following data in Excel:
| NAME | ENGLISH | MATHS | SCIENCE | COMPUTER | PASSED THE EXAM? |
|---|---|---|---|---|---|
| AARAV | PASS | PASS | PASS | PASS | |
| RIYA | PASS | FAIL | PASS | PASS | |
| KUNAL | PASS | PASS | FAIL | PASS | |
| NEHA | PASS | PASS | PASS | PASS | |
| ROHAN | FAIL | PASS | PASS | PASS | |
| PRIYA | PASS | PASS | PASS | FAIL | |
| AMAN | PASS | PASS | PASS | PASS | |
| SIMRAN | PASS | FAIL | FAIL | PASS | |
| VIKAS | PASS | PASS | PASS | PASS | |
| POOJA | FAIL | PASS | PASS | FAIL |
Questions
Q.1 If a student passes all four subjects, display TRUE, otherwise display FALSE using the AND function.
Q.2 Find whether AARAV has passed the examination using the AND function.
Q.3 Find whether RIYA has passed the examination.
Q.4 Find whether KUNAL has passed the examination.
Q.5 Find whether NEHA has passed the examination.
Q.6 Find whether PRIYA has passed the examination.
Q.7 Find whether AMAN has passed the examination.
Q.8 Find whether SIMRAN has passed the examination.
Q.9 Find whether VIKAS has passed the examination.
Q.10 Find whether POOJA has passed the examination and count how many students have passed all four subjects.
Formula
In F2, enter:
=AND(B2="PASS",C2="PASS",D2="PASS",E2="PASS")Press Enter and then drag the formula down from F2 to F11.
Result
-
TRUE → Student passed all four subjects.
-
FALSE → Student failed in one or more subjects.
Learning Objective
After completing this assignment, students will learn how to:
-
Use the AND function.
-
Check multiple conditions at the same time.
-
Return TRUE/FALSE based on multiple criteria.
-
Apply a formula to multiple rows using the Fill Handle.