Question

Which formula returns TRUE, if the value in cell B1 is less than 40 and the value in C1 is less than 100?
A.
=XOR(B1<40, C1<100)
B.
=AND(B1<40; C1<100)
C.
=IF(B1<40; C1<100;100)
D.
=AND((B1>40; C1>100)

Answer 1

Answer:

b

Explanation:

in and..both conditions must be true for returning true.

Given both conditions are true in this option.

hence true.

Answer 2

Option B is the formula that returns the result TRUE.

Given :

B1 < 40

C1 < 100

To Find :

Option statement that returns TRUE on XOR

Solution :

XOR Truth Table ( p XOR q )

p                      q                   p XOR q

-----------------------------------------------------

True   (1).         True   (1)        False (0)

True   (1)          False (0)        True   (1)    

False (0)          True   (1)        True   (1)

False (0)          False (0)        False (0)

AND Truth Table ( p AND q )

p                      q                   p AND q

-----------------------------------------------------

True   (1).         True   (1)        True   (1)

True   (1)          False (0)        False (0)  

False (0)          True   (1)        False (0)

False (0)          False (0)        False (0)

Option A :

Condition 1 - B1 < 40 is TRUE

Condition 2 - C1 < 100 is TRUE

Result - TRUE XOR TRUE = FALSE

Option B :

Condition 1 - B1 < 40 is TRUE

Condition 2 - C1 < 100 is TRUE

Result - TRUE AND TRUE = TRUE

Option C :

Condition 1 - B1 < 40 is TRUE ( Thus the second argument is returned )

Result - C1 < 100 = TRUE

Option D :

Condition 1 - B1 > 40 is FALSE

Condition 2 - C1 > 100 is FALSE

Result - FALSE AND FALSE = FALSE

Thus, the Option B formula which is AND of two conditions returns the required value TRUE.

To learn more about Bitwise Operators, visit

https://brainly.in/question/16103279

#SPJ6