Question

Using a custom AutoFilter, filter the Franchise Owners table to display only those records whose Tenure (Yrs) value is greater than 5.

A) Select the "Franchise Owners" table, go to the "Data" tab, click on "Filter," and then choose the "Tenure (Yrs)" column to set a custom filter greater than 5.

B) Open the "Franchise Owners" table, click on the "View" tab, and then select "Filter" to enable a custom filter for Tenure (Yrs) greater than 5.

C) Access the "Franchise Owners" table, right-click on the "Tenure (Yrs)" column, and choose "Custom Filter" to set a condition greater than 5.

D) Choose the "Franchise Owners" table, go to the "Home" tab, click on "Sort & Filter," and then select "Custom" to filter Tenure (Yrs) greater than 5.

Answer 1

Option A is the correct method to use a custom AutoFilter to filter the Franchise Owners table to display only those records whose Tenure (Yrs.) value is greater than 5.

Step-by-step explanation:

Option A is the correct method to use a custom AutoFilter to filter the Franchise Owners table to display only those records whose Tenure (Yrs.) value is greater than 5.

Select the "Franchise Owners" table.

Go to the "Data" tab.

Click on "Filter."

Choose the "Tenure (Yrs)" column.

Set a custom filter greater than 5.

By following these steps, you will be able to filter the table based on the desired condition of Tenure (Yrs.) > 5.