Which of the Following Lookup Functions Returns the Relative Position

question 23

Multiple Choice

Which of the following Lookup functions returns the relative position of an item in an array that equals a specified value in a specified order?

• A) HLOOKUP(lookup_value, table_array, row_index_num)
• B) MATCH(lookup_value, lookup_array, match_type)
• C) INDEX(array, row_num, col_num)
• D) VLOOKUP(lookup_value, table_array, col_index_num)

---

Definitions:

Fabrication Department

A specialized division within a company where raw materials are converted into components or products through various processes.

Assembly Department

A segment within a manufacturing facility where components are assembled into final products or where significant assembly work takes place.

Allocation Bases

Criteria or methods used for distributing indirect costs to different products, services, or departments based on predefined factors such as labor hours, machine hours, or material costs.

Direct Labor Hours

Measures the total hours worked by employees directly involved in the production process, used for calculating labor costs and efficiency.