Question

Within the autofilter selections within Excel, in order to filter out individual numbers or values, you ________."

		Uncheck the checkboxes for the values that you don t want to see in the results
		Select the radio buttons for the values that you don t want to see in the results
		Choose the ascending option for the values that you don t want to see in the results
		Choose the descending option for the values that you don t want to see in the results

Answer 1

1. On the Data tab, in the Sort & Filter group, click Filter.

2. Click the arrow  in the column header to display a list in which you can make filter choices.

Filter by selecting values or searching   

1. Selecting values from a list and searching are the quickest ways to filter. When you click the arrow in a column that has filtering enabled, all values in that column appear in a list.

2. Filters on text and numeric data by trying the many built-in test conditions, such as Equals, Does Not Equal, Contains, Greater Than, and Less Than.