Case-Based Critical Thinking Questions Case 8-1 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

Case-Based Critical Thinking Questions Case 8-1 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 evaluates whether cell G2 contains the value "FT" AND whether cell M2 is greater than or equal to 1. Since G2 contains "PT" and not "FT", the formula will return FALSE. The value of M2 (2) is not relevant to the evaluation of the formula.

Case-Based Critical Thinking Questions Case 8-1 Evaluate the Formula =AND(G2="FT",M2>=1)based