Test yourself
Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.
You want to find out the students with the 10 lowest grades, so you:
Average all the scores and then compare the scores to the average.
Use the Low Values function.
Use a Top Values query, and set the number of records to 10 in ascending sort order.
In a query, dates should be surrounded with _____.
Quotation marks.
Brackets.
Number signs (#).
What will the following expression find?
Between 10 and 20
All records whose values are between 10 and 20, including 10 and 20.
All records whose values are between 10 and 20, but not including 10 and 20.
Only those records whose total value is between 10 and 20, including 10 and 20.
