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.

Question

Quizplus · Accepted Answer

The Answer of 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.

Which of the Following Is True of Power Query