Question

When AutoFilter is on, clicking on the down arrow next to the column heading

a) Sorts the data in descending order.
b) Turns the AutoFilter off.
c) Automatically adjusts the column width.
d) Allows you to select criteria to apply to the filter.

Answer 1

When AutoFilter is on, clicking on the down arrow next to the column heading allows you to select criteria to apply to the filter.

Step-by-step explanation:

When AutoFilter is on and you click on the down arrow next to the column heading, it allows you to select criteria to apply to the filter. This means you can choose specific values or conditions to filter the data in that column.

For example, if you have a column with different cities and you click on the down arrow, you can choose to only show data for a specific city or cities. This helps you analyze and work with specific subsets of data.

Sorting the data in descending order, turning off AutoFilter, and automatically adjusting column width are not the functions of clicking on the down arrow next to the column heading when AutoFilter is on.