VLOOKUP Searches for a Matching Value in the Leftmost Column

question 102

Multiple Choice

VLOOKUP searches for a matching value in the leftmost column of the table, and then retrieves the value ____.

• A) in the same row but in another column that you specify
• B) in the same column but in another row that you specify
• C) anywhere in the table
• D) in the same row, in the very next column

---

Definitions:

Radiocarbon Dating

A method of measuring the decay rate of carbon isotopes in organic matter to determine the age of organic materials such as wood and fiber.

Earliest-Known Sculptures

The oldest discovered artworks in the medium of sculpture, dating back to prehistoric times and serving various cultural and religious purposes.

BCE

Before Common Era, a non-religious alternative to BC (Before Christ), used in the Gregorian calendar to denote years before the birth of Jesus.

Neolithic Construction

Refers to structures built during the Neolithic era, around 12,000 years ago, including monumental stone buildings and megalithic sites.