Exam 15: Excel 2013 : Analyzing Table Data

-In the accompanying figure,which number points to field values?

You can print a filtered table.

Icon sets let you visually communicate relative cell values by adding icons to cells based on the values they contain._________________________

-In the accompanying figure,what does item 1 point to?

-In the accompanying figure,what function has been applied to the groups?

When specifying criteria in the Custom AutoFilter dialog box,use the ____ wildcard to specify any series of characters.

Before you can add subtotals to table data,you must convert it to a(n)____ and then sort it.

After extracting table data,what button do you use to display the original table again?

And and Or are logical conditions.

When you generate subtotals,all levels of detail show in a(n)____.

The V in the VLOOKUP function stands for ____________________.

When using the Advanced Filter command,a criteria range is not entered into a dialog box.

-In the accompanying figure,the criteria in rows 3 and 4 would be considered a(n)____ condition.

-In the accompanying figure,which number points to a sort option?

-In the accompanying figure,why is the term FALSE chosen in item 4?

When you specify a complicated set of search criteria,it is a good idea to filter it in place rather than extract it.

What happens if you insert invalid data in a cell?

In a filtered table,the matching row numbers are ____.

Greater than and less than are logical conditions.

-In the accompanying figure,the criteria in row 3 would be considered a(n)____ condition.