An Excel Function That Looks Up Values in a Table

question 60

Multiple Choice

An Excel function that looks up values in a table array arranged as vertical columns is the ________ function.

• A)COLUMN
• B)VLOOKUP
• C)HLOOKUP
• D)MATCH

---

Definitions:

Sociobiology

The scientific study of the biological aspects of social behavior in animals and humans.

E. O. Wilson

An influential American biologist who was a leading researcher in sociobiology, biodiversity, and the importance of ants and other small creatures in ecosystems.

N. Tinbergen

Nikolaas Tinbergen was a Dutch biologist and ornithologist who won the Nobel Prize in Physiology or Medicine for his discoveries concerning social behavior patterns in animals.

Altruistic Behavior

Behavior in which one individual helps another, seemingly at its own risk or expense.