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.
Correct Answer:

Verified
Correct Answer:
Verified
Q1: Delimited text files include a delimiter character
Q2: The data in the accompanying figure was
Q3: Using the 'Text Import Wizard' or the
Q4: ABC Manufacturing has 1630 employees. Each employee
Q5: Megan is currently working in a text
Q7: Anna is getting ready to insert a
Q8: Text files are also known as:<br>A) Excel<sup>®</sup>
Q9: Real-world datasets usually do not require any
Q10: Delimiter characters include:<br>A) dollar signs and a
Q11: Angela is importing a string of data