Asked by Melissa Wilkerson on Jun 04, 2024
Verified
The score of a student in two subjects are inserted in B2 and C2 cell and the passing score for each subject is 60.which of these functions will you insert in D2 cell to get FALSE as the result if the student has passed and TRUE as the result if the student has failed?
A) =IF(B2>=60, C2>=60)
B) =NOT(OR(B2>=60, C2>=60) )
C) =OR(B2>=60, "Pass", "Fail")
D) =AND(B2>=60, "Pass", "Fail")
Conditional Logic
A form of logic used in programming and mathematics that performs different actions or outcomes based on whether a specified condition is true or false.
Passing Score
The minimum score required on a test or examination to be considered as having passed or achieved the required standard.
- Understand how to apply logical functions (IF, AND, OR, NOT) to execute decision-making processes within cells based on specified criteria.
Verified Answer
LL
Laurel LockardJun 04, 2024
Final Answer :
B
Explanation :
The NOT function is used to reverse the logical value of an input. The OR function checks if any of the conditions are true, so if either score is greater than or equal to 60, the student has passed. By reversing the output with NOT, we get TRUE if the student has failed and FALSE if the student has passed.
Learning Objectives
- Understand how to apply logical functions (IF, AND, OR, NOT) to execute decision-making processes within cells based on specified criteria.