Importing Data from an External Database into Excel Using Microsoft

question 6

Multiple Choice

Importing data from an external database into Excel using Microsoft Query is a three-step process. What are the steps?

• A) Delete missing observations, use Microsoft Query to define a query, and return the data to Excel.
• B) Define the source, use Microsoft Query to define a query, and return the data to the original, external database.
• C) Define the sources, use Microsoft Query to define a query, and return the data to Excel.
• D) Open Excel, use Microsoft Query to define a query, and return the data to Excel.

---

Definitions:

Country Selection

Asset allocation in which the investor chooses among investments in different countries.

Stock Selection

An active portfolio management technique that focuses on advantageous selection of particular stocks rather than on broad asset allocation choices.

Political Risk

Possibility of the expropriation of assets, changes in tax policy, restrictions on the exchange of foreign currency for domestic currency, or other changes in the business climate of a country.

Expropriation

The act of a government taking privately owned property, usually for public use or in the public interest, potentially with compensation.