Matching
Match each of the following nested functions to its correct return based on this table:
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:
Premises:
Responses:
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)
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:
Related Questions
Q83: Match each of the following terms to
Q84: The NPV function is used mostly to
Q85: This is a correct example of the
Q86: A loan amortization table is a schedule
Q87: The RATE function returns the periodic rate
Q89: The _ function calculates the cumulative interest
Q90: The _ function identifies the highest value
Q91: The _ database function will add the
Q92: The first argument of any database function
Q93: What function returns the total present value