Consider the following Excel sheet. What will be the output in column E? Excel…
2023
Consider the following Excel sheet. What will be the output in column E?
Excel data:
Row 1: A = 60 | B = A1 | C = 75 | D = a1 | E = IF(A1=C1,"T","F")
Row 2: A = 70 | B = A2 | C = 70 | D = A2 | E = IF(A2=C2,"T","F")
Row 3: A = 90 | B = A3 | C = 90 | D = A3 | E = IF(B3=D3,"T","F")
- A.
F F F
- B.
T T F
- C.
F T T
- D.
T T T
Attempted by 987 students.
Show answer & explanation
Correct answer: C
Correct answer: F T T
E1: A1 = 60 and C1 = 75, so A1=C1 is false. Output = F.
E2: A2 = 70 and C2 = 70, so A2=C2 is true. Output = T.
E3: B3 contains A3 and D3 also contains A3, so B3=D3 is true. Output = T.
Final output in column E: F T T