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:

Nuclear Power Plants

Facilities that generate electricity by using heat from nuclear reactions to produce steam which turns turbines.

Renewable Sources

Energy sources that are naturally replenished on a human timescale such as solar, wind, hydroelectric, and geothermal power.

Natural Radioactivity

The spontaneous emission of radiation from the nucleus of an unstable atom as a result of nuclear decay processes.

Mineral Form

A structured and naturally occurring chemical compound with a specific chemical composition and crystalline structure.