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
You have a Sales query and a Products query that share a ProductID column. Which Power Query operation adds product details to each sales row?
Answer: Merge Queries
Merge performs a join between two queries on matching key columns.
Which join kind in Merge Queries keeps all rows from the first table and only matching rows from the second?
Answer: Left Outer
Left Outer preserves every row of the first (left) table.
A column imported as text contains values like 1,234.50 that must be summed. What should you do in the Power Query Editor?
Answer: Use Replace Values to remove commas and change the data type to Decimal Number
Numeric text must be cleaned of separators and converted to a numeric data type.
Which Power Query feature lets you combine all CSV files in a folder into a single table with one query?
Answer: From Folder with Combine Files
The Folder connector plus Combine Files builds a sample transform and applies it to every file.
In the Power Query Editor, which command adds a column that increments 1, 2, 3, and so on for each row?
Answer: Index Column
Index Column creates a sequential numeric column starting from 0 or 1.
What does the Group By transformation with the Sum operation on an Amount column produce?
Answer: One row per group with the total Amount
Group By aggregates rows into one summary row per unique group value.