Question
You are given the formula of the following cells: D2: =IF(OR(AND(A2>300,B2=Purple),AND(A2 <300,C2=Monday)),PASS,FAIL) D3: =IF(OR(AND(A3>300,B3=Purple),AND(A3 <300,C3=Monday)),PASS,FAIL) D4: =IF(OR(AND(A4>300,B4=Purple),AND(A4 <300,C4=Monday)),PASS,FAIL) D5: =IF(OR(AND(A5>300,B5=Purple),AND(A5 <300,C5=Monday)),PASS,FAIL) What would be the
You are given the formula of the following cells:
D2: =IF(OR(AND(A2>300,B2="Purple"),AND(A2<300,C2="Monday")),"PASS","FAIL")
D3: =IF(OR(AND(A3>300,B3="Purple"),AND(A3<300,C3="Monday")),"PASS","FAIL")
D4: =IF(OR(AND(A4>300,B4="Purple"),AND(A4<300,C4="Monday")),"PASS","FAIL")
D5: =IF(OR(AND(A5>300,B5="Purple"),AND(A5<300,C5="Monday")),"PASS","FAIL")
What would be the results return from D2, D3, D4, and D5?
Group of answer choices
D2: FAIL; D3: PASS; D4: PASS; D5: FAIL
D2: PASS; D3: FAIL; D4: PASS; D5: FAIL
D2: FAIL; D3: FAIL; D4: PASS; D5: FAIL
D2: FAIL; D3: FAIL; D4: FAIL; D5: FAIL
D2: PASS; D3: PASS; D4: PASS; D5: PASS
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started