Filtering Data Using AUTO FILTER

This shortcut allows you to quickly apply or remove filters on a selected range of data in excel

• Ctrl + Shift + F

• Ctrl + Shift + D

• Ctrl + Shift + S

• Ctrl + Shift + L

Why is it important to include a header row in your excel worksheet when filtering data?

• To highlight the total number of rows in the dataset

• To indicate the background color of the worksheet

• To specify the font style for the data

• To identify the name of each column

What feature in excel allows you to quickly filter data based on specific criteria?

• Filtering data

• Auto filter

• Filter Menu

• Advanced filter

What happens to data in excel when the auto filter feature is applied and certain criteria are selected?

• The data is temporarily hidden if it doesn’t match the criteria

• The data is duplicated is duplicated in a separate worksheet

• The data is highlighted for emphasis

• The data is permanently deleted from the worksheet

What does clearing a filter in excel allow you to do?

• Permanently delete the filtered data from the worksheet

• Reset the filter and display all data in the worksheet

• Highlight the filtered data in a different color for emphasis

• Create a backup copy of the filtered data in separate worksheet