Your worksheet has the Filter feature turned on. The Filter arrows on two columns labeled Name and Town have Funnel symbols on them. How can you alter the display to show the data filtered by Town but not by Name?

1 point

Use the Clear option in the Filter group in the Data Ribbon.



Use the Clear Filter option on the Filter menu in the Name column.



Use the Clear Filter option on the Filter menu in the Town column.
Your worksheet has the Filter feature turned on. The Filter arrows on two columns labeled Name and Town have Funnel symbols on them. How can you alter the display to show the data filtered by Town but not by Name?

1 point

Use the Clear option in the Filter group in the Data Ribbon.



Use the Clear Filter option on the Filter menu in the Name column.



Use the Clear Filter option on the Filter menu in the Town column.