Logical tests
Write 7 independent logical tests (TRUE/FALSE) on one employee's record: empty cells, text comparisons, thresholds and LEFT/RIGHT — 7 guided steps, no fill-down.
Write the logical test in cell G2
1 / 7
Email missing?
=D2=""
Write the logical test in cell G3
2 / 7
Is a man?
=B2="Male"
Write the logical test in cell G4
3 / 7
Different from "Male"?
=B2<>"Male"
Write the logical test in cell G5
4 / 7
Salary < 2000? [excellab id="testslogiques-q4"]
=C2<2000
Write the logical test in cell G6
5 / 7
Postal code = 69001?
=E2="69001"
Write the logical test in cell G7
6 / 7
Postal code starts with 69?
=LEFT(E2,2)="69"
Write the logical test in cell G8
7 / 7
Email ends with "@xyz.com"?
=RIGHT(D2,8)="@xyz.com"
Your score is
Restart
