Power Query practice: The Power Query Paradigm & ETL Architecture

Chapter 1 · 5 questions · free to solve

Question 1 · easy
What is Power Query for?
Which sentence best describes what Power Query does?
Solve it in your browser
Question 2 · easy
E, T and L
Power Query is an ETL tool. What does ETL stand for?
Solve it in your browser
Question 3 · easy
Finding it in Excel
In Excel for Microsoft 365, where do you start a Power Query from a table in your workbook?
Solve it in your browser
Question 4 · easy
Your first step: remove a column
The Orders query is open. The Notes column is not needed. Select its header and use Home ▸ Remove Columns (or right-click ▸ Remove). Then press Check.
Solve it in your browser
Question 5 · easy
Time travel with Applied Steps
What happens when you click an earlier step in the Applied Steps pane?
Solve it in your browser

These questions are free.

Make a free account to solve them, with instant checking and an AI tutor for hints.

What is Power Query for?