Question

select the correct answer from each drop - down menu. which formulas return true, if the value in cell b4 is 12 and the value in c4 is 29? and return true, if the value in cell b4 is 12 and the value in c4 is 29. =xor(b4>12,c4=9) =and(b4=12,c4<9) =xor(b4=12,c4<9)

Explanation:

Step1: Analyze =XOR(B4>12,C4 = 9)

Given \(B4 = 12\), \(B4>12\) is \(False\). Given \(C4=29\), \(C4 = 9\) is \(False\). \(XOR(False,False)=False\)

Step2: Analyze =AND(B4 = 12,C4 < 9)

Given \(B4 = 12\), \(B4 = 12\) is \(True\). Given \(C4 = 29\), \(C4<9\) is \(False\). \(AND(True,False)=False\)

Step3: Analyze =XOR(B4 = 12,C4 < 9)

Given \(B4 = 12\), \(B4 = 12\) is \(True\). Given \(C4 = 29\), \(C4<9\) is \(False\). \(XOR(True,False)=True\)

Answer:

=XOR(B4 = 12,C4 < 9)