Which of the Following Is True of Power Query

question 32

Multiple Choice

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.

---

Definitions:

Mechanically Held

Describes devices or components that are kept in position through mechanical means rather than magnetic or adhesive forces.

Electrician

A skilled tradesperson who installs, maintains, and repairs electrical power systems and equipment.

Pilot Device

A device used to control or manipulate the operation of electrical machines through minor input adjustments.

Two-wire Motor

A motor that operates with a simple on-off control, requiring only two wires for operation.