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:
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:

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)
Related Questions

Q82: The RATE function returns the periodic rate

Q85: Database functions do not require a Criteria

Q91: Match each of the following terms to

Q92: Match each of the following functions to

Q93: Match each of the following terms to

Q95: Match each of the following terms with

Q96: Match each of the following functions to

Q97: Match each of the following terms to

Q98: Associate the following functions with its corresponding

Q99: Match the following functions with their categories

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