Exam 15: Excel 2013 : Analyzing Table Data

_______ is the database function used to total values in a table.

Which Excel feature provides a quick and easy way to group and summarize a range of data?

You can apply conditional formatting to table cells in the same way that you can format a range of worksheet data.

When specifying criteria in the Custom AutoFilter dialog box,use the ____ wildcard to specify a single character.

Which Excel feature allows you to specify what data users can enter in a range of cells?

-In the accompanying figure,which item points to the column you wish to search?

Explain two benefits of using the Excel data validation feature.

To find records for employees whose salary is greater than $60,000 and whose gender is female,use the ____.

Criteria on ____ line(s)indicates an Or condition.

The data from a column that appears in a filter list arrow cannot be used as search criteria.

The VLOOKUP function searches vertically down the ____ of the table,then reads across the row until the matching value is found.

Excel's VLOOKUP function searches vertically down the far left column of a table,then reads across the row to find the value in the column you specify._________________________

-In the accompanying figure,how many records will be selected if only row 3 is included in the criteria range?

The Excel ____ feature lets you manipulate data so that it meets selected criteria and only shows the data you want.

To use advanced filtering,you must define a(n)____ range.

-In the accompanying figure,which field is currently used as the sort field?

-In the accompanying figure,which item points to the range name of table to search?

If you want to find the closest possible match,what do you enter in the Range_lookup text box in the Function Arguments dialog box?

A(n)column range is a cell range containing one row of labels and at least one additional row underneath the row of labels that contains the criteria you want to match._________________________

When you extract data,you place a copy of a filtered ____ in a range that you specify in the Advanced Filter dialog box.