Matching
Match each of the following nested functions to its correct return based on this table:
Premises:
in D3 =IF(AND(B2="Blue":(NOT(B3="Green"):A2:"else")
in D2 =IF(OR(B2="Blue":B2="Red"):A2:"else")
in D4 =IF(OR(B4="Blue":B4="Red"):A4:"else")
in D3=IF(AND(B3="Blue":B3="Red"):A3:A4)
in D4=IF(NOT(B4="Blue"):A3:A4)
Responses:
Phone
Flower
Else
Car
An error
Correct Answer:
Premises:
Responses:
in D3 =IF(AND(B2="Blue":(NOT(B3="Green"):A2:"else")
in D2 =IF(OR(B2="Blue":B2="Red"):A2:"else")
in D4 =IF(OR(B4="Blue":B4="Red"):A4:"else")
in D3=IF(AND(B3="Blue":B3="Red"):A3:A4)
in D4=IF(NOT(B4="Blue"):A3:A4)
Premises:
in D3 =IF(AND(B2="Blue":(NOT(B3="Green"):A2:"else")
in D2 =IF(OR(B2="Blue":B2="Red"):A2:"else")
in D4 =IF(OR(B4="Blue":B4="Red"):A4:"else")
in D3=IF(AND(B3="Blue":B3="Red"):A3:A4)
in D4=IF(NOT(B4="Blue"):A3:A4)
Responses:
Related Questions
Q24: The _ function calculates the total future
Q37: A Truth Table is a matrix that
Q48: Which function would calculate a final value
Q55: Which database function returns the lowest value
Q59: The _ function calculates the periodic interest
Q72: What is the first argument of an
Q75: Which of these is not a capability
Q91: The _ database function will add the
Q95: Which is not an argument in an
Q98: Which function calculates the total principal through