Working with Lists Answers

15 verified answers2 views
1
Free Preview

Which button in the Sort & Filter gallery of the Data tab would sort the text into alphabetical order?

A
Sort Smallest to Largest
B
Sort A to Z
C
Sort First to Last
D
Sort Newest to Oldest
2
Free Preview

Click the tab.

A
Formulas
B
Data
C
Insert
D
View
4

What is the definition of filtering data?

A
to delete data that does not fit criteria from worksheet
B
to organize data that fits criteria
C
to remove data that does not fit criteria from display
D
to alphabetize data based on criteria
5

Select .

A
any cell in the data block
B
the first cell in the worksheet
C
all cells in the worksheet
D
the last cell in the worksheet
6

What are some tips to keep in mind when sorting data? Check all that apply.Remember that data will change when sorted.Remember that data will not change when sorted.Rows and columns can be sorted.Only one row or column can be sorted at once.Multiple criteria can be used to sort data.Sorting cannot be undone.

A
Remember that data will change when sorted.
B
Remember that data will not change when sorted.
C
Rows and columns can be sorted.
D
Only one row or column can be sorted at once.
E
Multiple criteria can be used to sort data.
F
Sorting cannot be undone.
7

Click the tab.

A
Formula
B
Insert
C
Data
D
Review
11

What is the best location for the criteria range when filtering data?

A
immediately above the data you wish to sort
B
immediately below the data you wish to sort
C
immediately to the left of the data you wish to sort
D
immediately to the right of the data you wish to sort
12

Which option is an appropriate database function syntax?

A
DSUM(A4:D8,“Unit Cost”,A1:B2)
B
=SUMA4:D8,“Unit Cost”,A1:B2)
C
=DSUM(A4:D8“Unit Cost”A1:B2)
D
=DSUM(A4:D8,“Unit Cost”,A1:B2)
13

What is the purpose of the Subtotal feature?

A
summarizes data for analysis
B
copies the headings to the Clipboard
C
performs calculations
D
groups data by levels
14

What does an outline do?

A
combines data from different worksheets
B
copies the headings to the Clipboard
C
performs calculations
D
groups data by levels
15

In the group, click to access the Subtotal dialog box.

A
Get & Transform Data
B
Queries & Connections
C
Sort & Filter
D
Outline

Did you find these answers helpful?