Training Logical Test – AND and OR functions

Logical tests: AND and OR functions

Filter a client list with logical tests: simple comparisons, then AND, OR and combined conditions — 10 guided steps, from a single test to nested AND/OR filters.

1 / 10

In H2, write a logical test to check whether the person in row 2 is 35 or older.

AND/OR — Q1 · 673

2 / 10

In H2, write a logical test (AND function) to check whether the person is 35 or older AND has an income of 50000 or more.

AND/OR — Q2 · 674

3 / 10

In H2, write a logical test (AND function) to check whether the person is male AND has an income strictly greater than 60000.

AND/OR — Q3 · 675

4 / 10

In H2, write a logical test (AND function) to check whether the person is a woman with 2 children or more.

AND/OR — Q4 · 676

5 / 10

In H2, write a logical test (OR function) to check whether the person is married or in a civil partnership.

AND/OR — Q5 · 677

6 / 10

In H2, write a logical test (AND function with 3 conditions) to check whether the person is a single woman with no children.

AND/OR — Q6 · 678

7 / 10

In H2, write a logical test (AND function) to check whether the person's income is between 50000 and 70000 inclusive.

AND/OR — Q7 · 679

8 / 10

In H2, write a logical test (AND function) to check whether the person is between 30 and 40 years old inclusive.

AND/OR — Q8 · 680

9 / 10

In H2, write a logical test combining AND and OR to check whether the person is a woman under 35, single or divorced.

AND/OR — Q9 · 681

10 / 10

In H2, write a logical test combining AND and OR to check whether the person is a man over 30, married or in a civil partnership.

AND/OR — Q10 · 682

Your score is

0%

Most Viewed Posts