Excel Power Query Flashcards
6 cards from real Microsoft Excel practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 Excel Power Query flashcards as text
In Excel, which ribbon tab contains the Get & Transform Data group used to launch Power Query?
Answer: Data
Power Query connectors live in the Get & Transform Data group on the Data tab.
Which language does Power Query use to record the steps you apply in the Power Query Editor?
Answer: M
Every applied step is written in the M formula language, visible in the Advanced Editor.
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?
Answer: Click Refresh All on the Data tab
Refreshing re-runs the saved steps against the current source data.
Which Power Query transformation converts multiple columns such as Jan, Feb, and Mar into two columns named Attribute and Value?
Answer: Unpivot Columns
Unpivot turns wide crosstab data into a tall, normalized list.
In the Power Query Editor, what happens when you delete a step from the middle of the Applied Steps list?
Answer: Only that step is removed and later steps are re-evaluated
Removing a step removes only that step; subsequent steps still run and may error if they depended on it.
Which option should you choose when you want a query's results available for other queries but do not want a table placed on any worksheet?
Answer: Only Create Connection
Connection-only queries exist without loading output to the workbook.