Which of the Following Is True of Power Query

Which of the following is true of Power Query?

A) It has a Navigator window where you can edit the data to be imported.
B) It allows you to import data from Microsoft Access,but only if you have first created a saved query in Access.
C) It has an Editor window where you can "shape" the data you want to import,but about the only thing this Editor window lets you do is delete unnecessary rows and/or columns.
D) In its final Import Data dialog box,it's not a good idea to select "Table" and check the "Add this data to the Data Model" because this would unnecessarily create two versions of the data and increase the size of the Excel file.

Correct Answer:

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Access For Free