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? =xor(b4 = 12;c4<9) and return true, if the value in cell b4 is 12 and the value in c4 is 29. =and(b4 = 12,c4<9) =and(b4 = 12,c4>9) =xor(b4>12,c4<9)

Explanation:

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

• First, check \(B4 = 12\). Since \(B4 = 12\), this part is \(TRUE\).
• Then, check \(C4 < 9\). Given \(C4 = 29\), \(29<9\) is \(FALSE\).
• The XOR function returns \(TRUE\) when the number of \(TRUE\)s in its arguments is odd. Here, one \(TRUE\) and one \(FALSE\), so \(=XOR(TRUE, FALSE)=TRUE\).

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

• Check \(B4 = 12\): \(TRUE\).
• Check \(C4 < 9\): \(29<9\) is \(FALSE\).
• The AND function returns \(TRUE\) only when all its arguments are \(TRUE\). Since one argument is \(FALSE\), \(=AND(TRUE, FALSE)=FALSE\).

Step 3: Analyze =AND(B4 = 12,C4 > 9)

• Check \(B4 = 12\): \(TRUE\).
• Check \(C4>9\): \(29 > 9\) is \(TRUE\).
• The AND function with both \(TRUE\) arguments: \(=AND(TRUE, TRUE)=TRUE\).

Step 4: Analyze =XOR(B4>12,C4 < 9)

• Check \(B4>12\): \(12>12\) is \(FALSE\).
• Check \(C4 < 9\): \(29<9\) is \(FALSE\).
• The XOR function with two \(FALSE\)s: \(=XOR(FALSE, FALSE)=FALSE\).

Answer:

A. =XOR(B4 = 12,C4 < 9), B. =AND(B4 = 12,C4 > 9)