Question

What tool should be used to remove fields and format data when importing?

A.)Power Query Editor

B.)Relationship builder

C.)3D Maps (Power Map)

Answer 1

A.)Power Query Editor

Step-by-step explanation:

Power Query editor is a Microsoft Office application, it can be utilized to remove fields and format data when importing files.

To remove fields, a user will click on the fields he wants to remove, then right-click to select Remove Columns on the menu, and under the same menu select Remove Columns from the sub-menu.

It is also used in formating data in the table created.