Evaluate the formula =AND(G2="FT",M2=1) based upon the information provided.
-What value is returned assuming that G2 contains the value PT and M2 contains the value 2?
A)TRUE
B)FALSE
C)PT
D)PT, 2

Question

Evaluate the formula =AND(G2="FT",M2>=1) based upon the information provided.
-What value is returned assuming that G2 contains the value PT and M2 contains the value 2?
A)TRUE
B)FALSE
C)PT
D)PT, 2

Quizplus · Accepted Answer

The formula requires that G2 contains "FT" and M2 is greater than or equal to 1. Since G2 contains "PT" instead, the formula will return FALSE. The values in M2 do not matter in this case.

Evaluate the Formula =AND(G2="FT",M2>=1) Based Upon the Information Provided