Rilynn0
contestada

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.

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 class=

Respuesta :

D

Step-by-step explanDAdadadad

Answer:

Pretty sure the Answer is:

=XOR(B4=12;C4<9) and =AND(B4=12;C>9) return TRUE, if the value in cell B4 is 12 and the value in C4 is 29.

Step-by-step explanation:

An =XOR function returns TRUE if any of the clauses in it are true, while an =AND function returns true only if both are true. Therefore, since in =XOR(B4=12;C4<9) B4 does equal 12, since this is an =XOR function. =AND(B4=12;C>9) is correct because B4 = 12 and C4 is greater than 9.

Hope this made some sense...

Mark brainliest if it helped!

Q&A Education