Wat is die meeste aantal dae wat verloop het tussen Order Date en Ship Date op 'n enkele bestelling? (Verskaf slegs die numeriese waarde) / 

What is the most days that have elapsed between an Order Date and Ship Date on a single order? (Only supply the numerical value)

Wat is die gemiddelde aantal dae wat tussen Order Date en Ship Date verloop? Rond u antwoord af tot die naaste heelgetal en verskaf slegs die numeriese waarde. /

What is the average number of days that pass between Order Date and Ship Date? Round your answer to the nearest whole number and only supply the numerical value.

Wat is die grootse bedrag afslag wat op 'n enkele transaksie toegestaan is? (Verskaf slegs die bedrag tot twee desimale, geen R teken word verlang nie, bv. 1.23) /

What is the highest amount of discount allowed on a single transaction? (Only provide the amount to two decimals, no R sign is required, e.g. 1.23)

Hoeveel is die Unit Price van die eenheid met die kleinste eenheidsprys? (Verskaf slegs die syfer tot twee desimale sonder die R-teken bv. 1.23) /

How much is the Unit Price of the unit with the smallest unit price? (Only provide the amount to two decimals without the R-sign e.g. 1.23)

Wat is die totale bedrag van al die "Sales"? /

What is the total amount of all Sales?

Wat is die waarde wat in sel E1001 staan? /

What is the value in cell E1001?

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?