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.

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.

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.

4 / 10

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

5 / 10

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

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.

7 / 10

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

8 / 10

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

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.

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.

Your score is

0%

Most Viewed Posts