Question

test content
page 7 of 10
question 7
if a2=75 and b2=92, what does this return?
=and(a2>60,b2>90)
true
false

Explanation:

Step1: Evaluate A2>60

Given \( A2 = 75 \), check if \( 75>60 \). Since \( 75>60 \) is true.

Step2: Evaluate B2>90

Given \( B2 = 92 \), check if \( 92>90 \). Since \( 92>90 \) is true.

Step3: Evaluate AND function

The AND function returns TRUE only if all its arguments are TRUE. Both arguments (A2>60 and B2>90) are TRUE, so AND returns TRUE.

Answer:

TRUE