Sheng Has Been Asked to Provide Data from the Inventory

question 44

Multiple Choice

Sheng 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

---

Definitions:

Balance Sheet

A statement that showcases a firm's assets, liabilities, and equity of shareholders at a specific time, useful for determining return rates and examining the organization's financial framework.

Contributed Capital

The total value of the cash and other assets received from shareholders in exchange for stock.

Accounting Records

Documents and books that capture all financial transactions of a business, used for tracking its financial health and compliance.

Accounting Information Processing Cycle

The series of steps followed in the accounting process to record, classify, summarize, and report a business's financial transactions.