Ask a New Question
Menu

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

(1 point)
Responses

Filters sort information in alphabetical order.
Filters sort information in alphabetical order.

Filters create fields that describe the remaining data.
Filters create fields that describe the remaining data.

Filters make it easier to find specific information in a large database.
Filters make it easier to find specific information in a large database.

Only one filter can be applied at a time.
Only one filter can be applied at a time.

1 answer

The true statement about filters in Microsoft® Excel databases is:

Filters make it easier to find specific information in a large database.

Here’s a brief explanation for the other options:

  • Filters sort information in alphabetical order. (False: Filters do not sort data; they allow you to display only rows that meet certain criteria.)
  • Filters create fields that describe the remaining data. (False: Filters do not create new fields; they simply hide rows that do not match the filter criteria.)
  • Only one filter can be applied at a time. (False: You can apply multiple filters across different columns in Excel.)

So, the correct response is the one about making it easier to find specific information.