Solved

Match Each of the Following Nested Functions to Its Correct

Question 94

Matching

Match each of the following nested functions to its correct return based on this table:
 A  B  C  D 1 Item  Color1  Color2 2 Car  Blue  Green 3 Phone  Red  Blue 4 Flower  Yellow  Pink \begin{array}{|c|l|c|l|c|} \hline & \text { A } & \text { B } & \text { C } & \text { D } \\\hline 1 & \text { Item } & \text { Color1 } & \text { Color2 } & \\\hline 2 & \text { Car } & \text { Blue } & \text { Green } & \\\hline 3 & \text { Phone } & \text { Red } & \text { Blue } & \\\hline 4 & \text { Flower } & \text { Yellow } & \text { Pink } & \\\hline\end{array}

Premises:
in D4 =IF(OR(B4="Blue",B4="Red"),A4,"else")
in D2 =IF(OR(B2="Blue",B2="Red"),A2,"else")
in D3 =IF(AND(B2="Blue",(NOT(B3="Green"),A2,"else")
in D4=IF(NOT(B4="Blue"),A3,A4
in D3=IF(AND(B3="Blue",B3="Red"),A3,A4)
Responses:
Flower
Else
An error
Car
Phone

Correct Answer:

in D4 =IF(OR(B4="Blue",B4="Red"),A4,"else")
in D2 =IF(OR(B2="Blue",B2="Red"),A2,"else")
in D3 =IF(AND(B2="Blue",(NOT(B3="Green"),A2,"else")
in D4=IF(NOT(B4="Blue"),A3,A4
in D3=IF(AND(B3="Blue",B3="Red"),A3,A4)
Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents