Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions