QUESTION 1

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

	a.	Or
	b.	extract
	c.	copy-to
	d.	And

1 points

QUESTION 2

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

	a.	Or
	b.	extract
	c.	copy-to
	d.	And

1 points

QUESTION 3

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

1 points

QUESTION 4

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

	a.	1
	b.	2
	c.	3
	d.	4

1 points

QUESTION 5

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

	a.	1
	b.	2
	c.	3
	d.	4

1 points

QUESTION 6

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

	a.	1
	b.	2
	c.	3
	d.	4

1 points

QUESTION 7

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

	a.	1
	b.	2
	c.	3
	d.	4

1 points

QUESTION 8

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

	a.	1
	b.	2
	c.	3
	d.	4

1 points

QUESTION 9

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

	a.	Conditions
	b.	Properties
	c.	Arguments
	d.	Functions

1 points

QUESTION 10

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

	a.	Filter
	b.	Clear
	c.	Reverse Filter
	d.	Revert

1 points

QUESTION 11

And and Or are logical conditions.

True

False

1 points

QUESTION 12

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

	a.	two
	b.	three
	c.	one
	d.	blue

1 points

QUESTION 13

Greater than and less than are logical conditions.

True

False

1 points

QUESTION 14

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

True

False

1 points

QUESTION 15

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.

1 points

QUESTION 16

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

	a.	extract
	b.	response
	c.	conditional
	d.	criteria

1 points

QUESTION 17

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

	a.	data from the column where the AutoFilter list arrow is
	b.	row numbers
	c.	sort options
	d.	advanced filtering options

1 points

QUESTION 18

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

	a.	table
	b.	list
	c.	worksheet
	d.	range

1 points

QUESTION 19

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.	Data and Copy-To
	c.	Data and Extract
	d.	Criteria and Extract

1 points

QUESTION 20

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

	a.	list arrow
	b.	search button
	c.	plus sign
	d.	criteria button

1 points

Click Save and Submit to save and submit. Click Save All Answers to save all answers.