Exam 15: Excel 2013 : Analyzing Table Data

Which of the following does NOT appear in the AutoFilter list menu?

-In the figure above,what are numbers 1-4 referred to as?

The HLOOKUP function searches horizontally ____ of the table until the matching value is found.

To clear a filter,click the ____.

You can filter records based on information in a specific field.

The menu that appears when you click a filter list arrow includes data from that column.

-In the accompanying figure,which item points to the location of the value you want to search for?

When you define the criteria range and the copy-to location in the Advanced Filter dialog box,Excel automatically creates which two range names?

To specify a long list of valid entries you can type them ____ and then type the list range in the Source text box.

You often create subtotals with the ____ function.

-In the accompanying figure,which number points to an AutoFilter list arrow?

When you create a table,Excel automatically generates a ____ next to each column header that you can use to filter records.

Use the ____________________ function when you want to find the position of an item in a range.

When you ____ data,you place a copy of the filtered table in a range you have specified in the Advanced Filter dialog box.

List and describe the steps necessary to generate subtotals in a table.

When specifying criteria in the Custom AutoFilter dialog box,use the ? (question mark)wildcard to specify a series of characters._________________________

-In the accompanying figure,what is the full criteria range to include criteria for all fields in two criteria rows?

In the Data Validation dialog box,clicking List from the ____ list arrow allows you to type a list of specific options.

-In the accompanying figure,which number points to an advanced filtering option?

With the data validation feature,you can restrict data to all of the following EXCEPT ____.