Microsoft Excel Excel Power Query 2

Question 1

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?

Accepted Answer

Merge Queries

Answer

Merge performs a join between two queries on matching key columns.

Question 2

Which join kind in Merge Queries keeps all rows from the first table and only matching rows from the second?

Accepted Answer

Left Outer

Answer

Left Outer preserves every row of the first (left) table.

Question 3

A column imported as text contains values like 1,234.50 that must be summed. What should you do in the Power Query Editor?

Accepted Answer

Use Replace Values to remove commas and change the data type to Decimal Number

Answer

Numeric text must be cleaned of separators and converted to a numeric data type.

Question 4

Which Power Query feature lets you combine all CSV files in a folder into a single table with one query?

Accepted Answer

From Folder with Combine Files

Answer

The Folder connector plus Combine Files builds a sample transform and applies it to every file.

Question 5

In the Power Query Editor, which command adds a column that increments 1, 2, 3, and so on for each row?

Accepted Answer

Index Column

Answer

Index Column creates a sequential numeric column starting from 0 or 1.

Excel Practice Test