Working with Lists

Question 1

What are some commands found in the Sort Options dialog box? Check all that apply.sort top to bottomsort A to Zsort alphabeticallysort left to rightcase sensitive

Revolt · Accepted Answer

sort top to bottom; sort left to right; case sensitive

Question 2

Select the correct navigational path to sort data using multiple levels.

Revolt · Accepted Answer

✔ Data; Click the tab on the ribbon, and look in the gallery.: Data; Click the tab on the ribbon, and look in the gallery.: Sort & Filter; Select .: Sort

Question 3

Get & Transform Data Queries & Connections ✔ Sort & FilterData Tools

Revolt · Accepted Answer

✔ Sort & Filter

Question 4

✔ SortFilter Advanced Outline

Revolt · Accepted Answer

✔ Sort

Question 5

What steps can be used to open the Custom AutoFilter dialog box? Select any cell in the data range.

Revolt · Accepted Answer

Click the tab.: Data; In the group, click Filter.: Sort & Filter; Click and click Custom Filter. The Custom AutoFilter dialog box appears for creating custom filers.: Text Filters

Question 6

Get & Transform Data Queries & Connections ✔ Sort & FilterData Tools

Revolt · Accepted Answer

✔ Sort & Filter

Question 7

Sort by Color Search Equals ✔ Text Filters

Revolt · Accepted Answer

✔ Text Filters

Question 8

What are the required components of a database function? Check all that apply.=D in front of the commanda single argumentrangefieldcriteria

Revolt · Accepted Answer

=; D in front of the command; range; field; criteria

Question 9

What steps can be used to open the Custom AutoFilter dialog box? Select any cell in the data range.

Revolt · Accepted Answer

✔ Data; Click the tab.: Data; In the group, click Filter.: Sort & Filter; Click and click Custom Filter. The Custom AutoFilter dialog box appears for creating custom filers.: Text Filters

Working with Lists Answers

More from this Course

TRY EDGENUITY HACKS