Question

1. What is the purpose of filters in a database? (32 points)
Filters allow you to see only the records that meet specific criteria.
Filters delete unnecessary data.
Filters create charts based on specific criteria.
Filters put data in alphabetical or numeric order.

2. Which of the following is true about filters in Microsoft® Excel databases? (1 point)
Filters sort information in alphabetical order.
Filters create fields that describe the remaining data.
Filters make it easier to find specific information in a large database.
Only one filter can be applied at a time.

3. What happens when a filter is applied to a database? (1 point)
All records that don’t meet the criteria are removed from view.
All records that don’t meet the criteria are permanently removed from the database.
Some records are permanently removed from the database.
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? (1 point)
The Sort feature must be applied first.
The filters must be applied in order from left to right.
Filters are used for numeric data and the Sort feature is used for text data.
Filters and the Sort feature can be applied in any order.

Answer 1

1. Filters allow you to see only the records that meet specific criteria.A filter is used when you need a data with specific criteria. It will make the data search faster but you need to specify the criteria to makes the filter works. It wasn't supposed to make a graph. It also won't put the data in alphabetical order since it was the sort function. 
2. Filters make it easier to find specific information in a large database.A filter will exclude data that doesn't meet the criteria. This will makes finding a specific information easier. Multiple filters can be applied to a database. Filter doesn't make a new field. It also won't put the data in alphabetical order since it was the sort function. 

3. All records that don’t meet the criteria are removed from view.Other data will not be changed since filter function is to search, not to changes the data. The filter will not delete the database that was not shown. It only changes the view based on the data that you need by hiding other data. 

4. Filters and the Sort feature can be applied in any order.
There is no specific order in which where you should apply the filter that you need. Sorting after or before the filters should have the same result. Filter and sort can be used in both numeric or text data.

Answer 2

Answer:

Filters allow you to see only the records that meet specific criteria.A filter is used when you need a data with specific criteria. It will make the data search faster but you need to specify the criteria to makes the filter works. It wasn't supposed to make a graph. It also won't put the data in alphabetical order since it was the sort function.  

2. Filters make it easier to find specific information in a large database.A filter will exclude data that doesn't meet the criteria. This will makes finding a specific information easier. Multiple filters can be applied to a database. Filter doesn't make a new field. It also won't put the data in alphabetical order since it was the sort function.  

3. All records that don’t meet the criteria are removed from view.Other data will not be changed since filter function is to search, not to changes the data. The filter will not delete the database that was not shown. It only changes the view based on the data that you need by hiding other data.  

4. Filters and the Sort feature can be applied in any order.

There is no specific order in which where you should apply the filter that you need. Sorting after or before the filters should have the same result. Filter and sort can be used in both numeric or text data.

Explanation: