The following tests your answers for the tutorial for the week:

Please complete the complex criteria per question below by entering the missing formula, or part of a formula.

a.1.

a.2.

a.3.

a.4.

a.5.

a.6.

The following question refers to the extra filter exercises that you received in this lesson.

This is the correct simplex criteria for Question 2 (from extra examples):

Complete the complex criteria formula below that will generate the same output as the above simplex criteria.

The following tests your answers for the tutorial for the week:

Please complete the criteria per question below by entering the missing information and providing the quantity of records that was included in the output after the filter was executed.

A-1

Quantity of output records:

A-2

Quantity of output records:

A-3

Quantity of output records:

A-4

Quantity of output records:

A-5

Quantity of output records:

A-6

Quantity of output records:

Complete the sentences by selecting the correct words.

When criteria are entered next to one another (like example 2), it functions as an

When criteria are entered in different rows (like example 3), it functions as an  

When you have to include criteria that specify a value between two values, you will always use a 

How many records were included in the output of example 5? .

Please enter the criteria for example 1 (Q1) in the cells below:

Please indicate if the following statements are true or false:

1. The heading in the criteria must be exactly the same as the header in the database, otherwise the filter will not work. 
   True

   False
2. The requirement entered below the header must be exactly the same as it is entered in the database, otherwise the filter will not produce the required output. 
   True

   False

How many records were included in the output of example 1 after the filter was performed? 

Complete the following sentence by filling in the correct word:

When activating the filter, while selecting the database, totals must be

When executing a filter, you should preferably always copy the output to another location.

There can be duplicate headers in a database when a filter will be applied to it. (e.g. two columns have the same heading)

There are three components in a filter. Match the correct description of each next to the term.

Is the following statement TRUE or FALSE?

Another word for "specified requirements" is