Question 1

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

Accepted Answer

A)   1
B)   2
C)   3
D)   4 D

Question 2

You can print a filtered table.

Accepted Answer

A) True 
 B)False  True

Question 3

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

Accepted Answer

A) True 
 B)False  True

Question 4

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

Accepted Answer

A)   outline symbols
B)   row numbers
C)   worksheet names
D)   view buttons

Question 5

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

Accepted Answer

A)   COUNT
B)   AVERAGE
C)   SUM
D)   TOTAL

Question 6

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

Accepted Answer

A)  ( ?) 
B)   (*) 
C)   (') 
D)   Both A and B.

Question 7

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

Accepted Answer

A)   list
B)   column
C)   range
D)   argument

Question 8

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

Accepted Answer

A)   Clear
B)   Filter
C)   Reverse Filter
D)   Revert

Question 9

And and Or are logical conditions.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A)   outline
B)   extracted table
C)   list range
D)   graph

Question 11

The V in the VLOOKUP function stands for ____________________.

Accepted Answer

The answer of The V in the VLOOKUP function stands...

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A)   Or
B)   And
C)   extract
D)   copy-to

Question 14

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

Accepted Answer

A)   1
B)   2
C)   3
D)   4

Question 15

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

Accepted Answer

A)   Because you wish to find an opposite match for the value in cell M1.
B)   Because you wish to find a false match for the value in cell M1.
C)   Because you wish to find an exact match for the value in cell M1.
D)   Because you wish to find an exact match in the table array.

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

What happens if you insert invalid data in a cell?

Accepted Answer

A)   ##Error appears in the cell.
B)   A warning dialog box appears.
C)   Invalid appears in the cell.
D)   appears in the cell.

Question 18

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

Accepted Answer

A)   red
B)   green
C)   blue
D)   yellow

Question 19

Greater than and less than are logical conditions.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A)   Or
B)   And
C)   extract
D)   copy-to

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.