Microsoft Excel Excel Power Query

Question 1

In Excel, which ribbon tab contains the Get & Transform Data group used to launch Power Query?

Accepted Answer

Data

Answer

Power Query connectors live in the Get & Transform Data group on the Data tab.

Question 2

Which language does Power Query use to record the steps you apply in the Power Query Editor?

Accepted Answer

M

Answer

Every applied step is written in the M formula language, visible in the Advanced Editor.

Question 3

After loading a query to a worksheet, the source CSV file receives new rows. What is the quickest way to bring those rows into Excel?

Accepted Answer

Click Refresh All on the Data tab

Answer

Refreshing re-runs the saved steps against the current source data.

Question 4

Which Power Query transformation converts multiple columns such as Jan, Feb, and Mar into two columns named Attribute and Value?

Accepted Answer

Unpivot Columns

Answer

Unpivot turns wide crosstab data into a tall, normalized list.

Question 5

In the Power Query Editor, what happens when you delete a step from the middle of the Applied Steps list?

Accepted Answer

Only that step is removed and later steps are re-evaluated

Answer

Removing a step removes only that step; subsequent steps still run and may error if they depended on it.

Excel Practice Test