Question

What is data filtering? Explain the way to extract data using Custom AutoFilter. ​

Answer 1

Answer:

Data filtering is the task of reducing the content of noise or errors from measured process data. It is an important task because measurement noise masks the important features in the data and limits their usefulness in practice.

•Turn on the Excel Filters

•Select the field that you want to use for your custom AutoFilter.

•Describe the AutoFilter operation.

•Describe the AutoFilter filtering criteria.

•Click OK.

Answer 2

Answer:

You can construct a custom AutoFilter. To do this, select the Text Filter command from the table menu and choose one of its text filtering options. No matter which text filtering option you pick, Excel displays the Custom AutoFilter dialog box. This dialog box enables you to specify with great precision what records you want to appear on your filtered list.

Explanation:

1Turn on the Excel Filters.

Filtering is probably already on because you’ve created a table. However, if filtering isn’t turned on, select the table, click the Sort & Filter button, and choose Filter. Or in Excel 2007 or Excel 2010, simply choose Data→Filter.

2Select the field that you want to use for your custom AutoFilter.

To indicate which field you want to use, open the filtering drop-down list for that field to display the table menu, select Text Filters, and then select a filtering option. When you do this, Excel displays the Custom AutoFilter dialog box.

3Describe the AutoFilter operation.

To describe your AutoFilter, you need to identify (or confirm) the filtering operation and the filter criteria. Use the left-side set of drop-down lists to select a filtering option. For example, the filtering option selected in the first Custom AutoFilter set of dialog boxes is Begins With. If you open this drop-down list, you’ll see that Excel provides a series of filtering options:

Begins With