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:

Portfolio

A collection of financial investments like stocks, bonds, commodities, cash, and cash equivalents, including closed-end funds and exchange traded funds (ETFs).

Market Value Weighted-Average Beta

A calculation that averages the betas of all stocks in a portfolio, weighted by their market value.

Market Index

A statistical measure that tracks the performance of a basket of specific stocks to represent a particular market or sector.

Beta

A measure of the volatility, or systemic risk, of a security or a portfolio compared to the market as a whole.