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 DataQueries & Connections✔ Sort & FilterX Data Tools

Revolt · Accepted Answer

✔ Sort & Filter

Question 4

✔ SortX FilterAdvancedOutline

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 DataQueries & Connections✔ Sort & FilterData Tools

Revolt · Accepted Answer

✔ Sort & Filter

Question 7

Sort by ColorSearchEquals✔ Text Filters

Revolt · Accepted Answer

✔ Text Filters

Working with Lists Answers

More from this Course

TRY EDGENUITY HACKS