Deck 15: Excel 2013 : Analyzing Table Data

Question 1

You can print a filtered table.

Answer 1

True

Question 2

Greater than and less than are logical conditions.

Answer 2

False

Question 3

To clear a filter,click the ____.

A) Clear button in the Sort & Filter group
B) Sort & Filter button and click Clear
C) Sort & Filter button and click All
D) Either A or B.

Answer 3

A

Question 4

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

A) sort options
B) row numbers
C) advanced filtering options
D) data from the column where the AutoFilter list arrow is

Question 5

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

A) Tour
B) Depart Date
C) Number of Days
D) Seat Capacity

Question 6

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

A) Sort
B) Criteria
C) AutoFilter
D) Subtotal

Question 7

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

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

Question 8

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

Question 9

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

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

Question 10

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

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

Question 11

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

A) criteria button
B) list arrow
C) plus sign
D) search button

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

And and Or are logical conditions.

Question 17

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

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

Question 18

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

Question 19

Subtotals can be used in an Excel table.

Question 20

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

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

Question 21

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

A) two
B) three
C) one
D) blue

Question 22

When performing an advanced filter,you specify ____ conditions by placing the criteria in the same row.

A) And
B) Or
C) And and Or
D) All

Question 23

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

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

Question 24

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

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

Question 25

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

A) extract
B) conditional
C) criteria
D) response

Question 26

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

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

Question 27

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

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 28

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

A) first cell
B) left-most column
C) right-most column
D) first row

Question 29

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

A) A2:D4
B) A1:D4
C) B3:C3
D) B3:C4

Question 30

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

A) Criteria and Copy-To
B) Criteria and Extract
C) Data and Copy-To
D) Data and Extract

Question 31

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

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

Question 32

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

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

Question 33

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

A) across the upper row
B) across the bottom row
C) in the left-most column
D) in the right-most column

Question 34

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

A) Table locator
B) Search button
C) Advanced Filter command
D) Filter by Selection command

Question 35

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

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

Question 36

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

A) range
B) worksheet
C) table
D) list

Question 37

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

A) extract
B) delete
C) find
D) None of the above.

Question 38

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

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

Question 39

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

A) Properties
B) Functions
C) Conditions
D) Arguments

Question 40

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

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

Question 41

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

A) data configuration
B) arguments
C) data validation
D) data specification

Question 42

You often create subtotals with the ____ function.

A) VALUE
B) ADD
C) MULTIPLY
D) SUM

Question 43

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

A) whole numbers
B) decimal numbers
C) text
D) invalid entries

Question 44

When you issue the Subtotal command,clicking the 2 outline symbol shows only subtotals and the ____________________ total.

Question 45

What happens if you insert invalid data in a cell?

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

Question 46

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

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

Question 47

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

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

Question 48

The V in the VLOOKUP function stands for ____________________.

Question 49

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

A) on a new sheet
B) in the formula bar
C) in another workbook
D) elsewhere in the worksheet

Question 50

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) TRUE
B) CLOSEST
C) NEAR
D) FALSE

Question 51

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

A) DCOUNT
B) DTOTAL
C) DSUM
D) COUNTDATA

Question 52

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

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

Question 53

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

Question 54

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

A) Allow
B) Values
C) Restrict
D) Valid

Question 55

The Advanced Filter command allows you to search for data using And and Or ____________________ conditions.

Question 56

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

A) Group
B) Subtotals
C) Summarize
D) Summary

Question 57

Explain two benefits of using the Excel data validation feature.

Question 58

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

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

Question 59

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

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

Question 60

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

Question 61

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._________________________

Question 62

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

Question 63

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

Question 64

When specifying criteria in the Custom AutoFilter dialog box,use the * (asterisk)wildcard to represent any single character._________________________

Question 65

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._________________________