Working with Lists Answers

12 verified answers4 views
192118
Free Preview

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

Answers:
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
192119

Get & Transform DataQueries & Connections✔ Sort & FilterData Tools

A
Get & Transform Data
B
Queries & Connections
C
✔ Sort & Filter
D
Data Tools
192120

✔ SortFilterAdvancedOutline

A
✔ Sort
B
Filter
C
Advanced
D
Outline
192121

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

Answers:
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
192122

Get & Transform DataQueries & Connections✔ Sort & FilterData Tools

A
Get & Transform Data
B
Queries & Connections
C
✔ Sort & Filter
D
Data Tools
192123

Sort by ColorSearchEquals✔ Text Filters

A
Sort by Color
B
Search
C
Equals
D
✔ Text Filters
192124

What are the required components of a database function? Check all that apply.

A
=
B
D in front of the command
C
a single argument
D
range
E
field
F
criteria
192128

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

Answers:
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

Did you find these answers helpful?