The Function Returns a Value or Reference of the Cell

question 13

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) VLOOKUP(lookup_value, table_array, col_index_num)
• B) INDEX(array, row_num, col_num)
• C) MATCH(lookup_value, lookup_array, match_type)
• D) HLOOKUP(lookup_value, table_array, row_index_num)

---

Definitions:

Time Horizons

The timeframe within which objectives are planned to be achieved or events are expected to occur, influencing decision-making processes.

Milestone Schedule

A project management tool that outlines significant events or achievements along a project timeline.

Project Risk Management

The process of identifying, analyzing, and responding to project risks to minimize their impact.

Positive Float

The extra time available beyond a project's expected completion time, allowing for delays without affecting the deadline.