Case-Based Critical Thinking QuestionsCase 12-1Sheng has been asked to provide data from the Inventory database of a regional auto parts store to the store's regional manager. He has been given specific requirements to narrow the data based on the information the manager needs. Sheng will apply filters to the tables in the Inventory database to provide his manager with the requested information.
Sheng needs to determine which vendors provide the most options for floor mats that are compatible with the specific car model. To do this, he will apply a filter that is based on multiple selection criteria and that sorts the records that are selected by vendor name alphabetically.  Which type of filter will Sheng apply to the datasheet?

A. Advanced Filter/Sort
B. AutoFilter
C. Filter by Form
D. Filter by Selection


Answer: A

Computer Science & Information Technology

You might also like to view...

What is the value of the following?

floor(4.999) + ceil(2.0) a. 6.999 b. 7.0 c. 6.0 d. 8.0

Computer Science & Information Technology

The text that appears alongside a CheckBox is referred to as the

a) CheckBox label b) CheckBox name c) CheckBox value d) CheckBox data

Computer Science & Information Technology

There are four types of data that can be entered into a Calc worksheet

Indicate whether the statement is true or false

Computer Science & Information Technology

Which option would allow a smartphone to be backed up to a remote server?

A) iOS B) iOS Manager C) App Manager D) iCloud

Computer Science & Information Technology