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.