High School

Select the correct answer.

What is the output of the formula =XOR(120<102;83=83;51<24)?

A. TRUE
B. FALSE
C. 83
D. 24
E. 120

Answer :

The output of the formula =XOR(120<102;83=83;51<24) is true

Calculating the output of the formula

from the question, we have the following parameters that can be used in our computation:

=XOR(120<102;83=83;51<24)

The above operation is a XOR operation

The rule of the XOR operation is that

  • If at least one of the operands is true, the result will be true
  • If none of the operands is true, the result will be false

So, we have

120 < 102 = False

83 = 83 = True

51 < 24 = False

This can then be rewritten as

=XOR(False, True, False)

When evaluated using the XOR rule, we have

=XOR(False, True, False) = true

Hence, the output of the formula is true

Read more about excel formula at

https://brainly.com/question/30790882

#SPJ1