The Function Returns a Value or Reference of the Cell

question 15

Multiple Choice

The function returns a value or reference of the cell at the intersection of a particular row and column in a given range.

• A) VLOOKUPlookup_value, table_array, col_index_num)
• B) INDEXarray, row_num, col_num)
• C) MATCHlookup_value, lookup_array, match_type)
• D) HLOOKUPlookup_value, table_array, row_index_num)

---

Definitions:

Strategic Initiatives

Actions or plans undertaken by an organization to achieve strategic goals and objectives, often involving significant resource allocation.

Innovation

The creation or introduction of something new, such as a product, service, process, or idea, that adds value or solves a problem.

Product-Development Capabilities

The ability of a company to develop new products or improve existing ones, often determining its competitive edge in the market.

Metrics

Quantitative measures used to track performance, productivity, or other relevant data.