Lesson 6: Filtering a Database quiz

1. What is the purpose of filters in a database?

A. Filters allow you to see only the records that meet specific criteria.
B. Filters delete unnecessary data.
C. Filters create charts based on specific
D. Filters put data in alphabetical or numeric order.

2. Which of the following is true about filters in Microsoft® Excel databases?

A. Filters sort information in alphabetical order.
B. Filters create fields that describe information on the remaining data.
C. Filters make it easier to find specific information in a large database.
D. Only one filter can be applied.

3. What happens when a filter is applied to a database?

A. All records that don't meet the criteria are removed from view.
B. All records that don't meet the criteria are permanently removed view.
C. some records are permanently removed from the database.
D. Records that meet the criteria are moved to the top of the database and highlighted.

4. Which of the following is true when applying both filters and the sort feature to a database?

A. The sort feature must be applied first.
B. The filters must be applied in order from left to right
C. Filters are used for numeric data and the sort feature is used for text data.
D. Filters and the sort feature can be applied in any order.

My answers:

1. Filters allow you to see only the records that meet specific criteria.
2. Filters make it easier to find specific information in a large database.
3. All records that don't meet the criteria are removed from view
4. Filters and the sort feature can be applied in any order.

Everyone who gives me the right answers gets a 🍔 and if you don't eat meat you get 🥝(kiwi) or both

correct.

You're correct.

@Tessa Yey thank you, I just took the quiz so you get...A 🍔or do you want a 🥝

ima test this

Congratulations! Your answers are correct! Here's how you can arrive at these answers:

1. The purpose of filters in a database is to allow you to see only the records that meet specific criteria. This is option A.

2. In Microsoft® Excel databases, filters make it easier to find specific information in a large database. This is option C.

3. When a filter is applied to a database, all records that don't meet the criteria are removed from view. This is option A.

4. Both filters and the sort feature can be applied in any order. This is option D.

Great job on getting the right answers! You've earned a 🍔! Enjoy your reward!