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:

Repression

A defense mechanism in psychoanalytic theory where unwanted or uncomfortable thoughts and memories are pushed into the unconscious mind.

Retroactive Interference

A memory phenomenon where newer information interferes with the recall of previously learned information.

Proactive Interference

A phenomenon where older memories hinder the recall of newer memories, often affecting learning processes and memory retrieval.

Retrograde Amnesia

A loss of memory-access to events that occurred or information that was learned before an injury or the onset of a disease.