AnswersTX-Business Information Management BIM IWorking with Lists

Working with Lists Answers

3 verified answers2 views
1
Free Preview

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
2
Free Preview

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)
3

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

Did you find these answers helpful?

More from this Course

Assignment
9 verified answers

Working with Lists

Assignment
9 verified answers

Working with Lists

Assignment
8 verified answers

Analyzing Data

Working with Lists Answers — TX-Business…