To Find and Retrieve Data from a Vertical Lookup Table

question 34

Multiple Choice

To find and retrieve data from a vertical lookup table in the most efficient way, create a simple worksheet that contains related data, and organize this data in ____ to form the vertical lookup table.

• A) columns
• B) rows
• C) either a or b
• D) neither a nor b

---

Definitions:

Prospectus

A document that companies issue to potential investors, detailing the financial performance and risks involved in an investment offering.

Securities

Financial instruments that represent an ownership position in a publicly-traded corporation (stock), a creditor relationship with a governmental body or a corporation (bond), or rights to ownership as represented by an option.

Net Worth

The total value of all assets owned by an individual or entity minus any liabilities or debts, representing the owner's equity in those assets.

Insider Trading

The illegal or legal trading of a public company's stock or other securities by individuals with access to nonpublic information about the company.