Dan Is Manipulating Data in a Table Santaining Resards on Samputer

question 52

Multiple Choice

Dan is manipulating data in a table santaining resards on samputer equipment purchases for the past year. Each resard in the table santains the date purchased, the type of samputer equipment, the vendor's name, the sast of the equipment, and the department in which the equipment is installed. The resards were originally entered in order by month of purchase. Dan sends you an e-mail asking how he can rearrange the table's resards to see all the purchases from each vendor in date order within each department. He also wants to know a quick way to get the data back into its original order, whenever necessary. To rearrange the data, you suggest that Dan create a custom sort by setting the ____.

• A) purchase date field as the major sort key, the vendor field as the intermediate sort key, and the department field as the minor sort key
• B) vendor field as the major sort key, the department field as the intermediate sort key, and the purchase date field as the minor sort key
• C) purchase date field as the major sort key, the department field as the intermediate sort key, and the vendor as the minor sort key
• D) department field as the major sort key, the vendor field as the intermediate sort key, and the purchase date field as the minor sort key

---

Definitions:

Variable Manufacturing Overhead

Costs in the production process that vary with the level of output, such as utilities for machinery.

Fixed Manufacturing Overhead

The total of all costs that remain constant regardless of the level of production or sales, in the context of manufacturing operations.

Direct Labor-Hours

The total number of hours worked by employees directly involved in the manufacturing process.

Manufacturing Departments

Specific areas within a manufacturing facility where distinct stages of production are carried out.