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.

Question

Quizplus · Accepted Answer

The correct steps are to define the sources (where the external database is located), use Microsoft Query to define a query (to specify which data to import), and return the data to Excel. Option A is incorrect because deleting missing observations is not a part of the import process. Option B is incorrect because it suggests returning the data to the external database, which is not the goal of the process. Option D is incorrect because it suggests returning the data to the same Excel file without specifying the data source or query.

Importing Data from an External Database into Excel Using Microsoft