Power Query practice: Schema Hygiene & Column Selection
Chapter 2 · 5 questions · free to solve
Question 1 · easy
Choose the columns you need
Solve it in your browserKeep only OrderID, Product and Qty, in that order. Ctrl+click the three headers, then Home ▸ Choose Columns.
Question 2 · medium
Remove Columns or Choose Columns?
Solve it in your browserNext month's export will gain a new column you don't need. Which step keeps your result unchanged?
Question 3 · easy
Rename columns
Solve it in your browserRename Qty to
Quantityand UnitPrice toUnit Price. Double-click a header to rename it.Question 4 · easy
Move a column to the front
Solve it in your browserMake Rep the first column. Select it, then Transform ▸ Move ▸ To Beginning.
Question 5 · easy
Duplicate a column
Solve it in your browserMake a copy of the Product column. Select it, then Add Column ▸ Duplicate Column.
These questions are free.
Make a free account to solve them, with instant checking and an AI tutor for hints.
Start free