Power Query practice: Schema Hygiene & Column Selection

Chapter 2 · 5 questions · free to solve

  1. Question 1 · easy

    Choose the columns you need

    Keep only OrderID, Product and Qty, in that order. Ctrl+click the three headers, then Home ▸ Choose Columns.

    Solve it in your browser
  2. Question 2 · medium

    Remove Columns or Choose Columns?

    Next month's export will gain a new column you don't need. Which step keeps your result unchanged?

    Solve it in your browser
  3. Question 3 · easy

    Rename columns

    Rename Qty to Quantity and UnitPrice to Unit Price. Double-click a header to rename it.

    Solve it in your browser
  4. Question 4 · easy

    Move a column to the front

    Make Rep the first column. Select it, then Transform ▸ Move ▸ To Beginning.

    Solve it in your browser
  5. Question 5 · easy

    Duplicate a column

    Make a copy of the Product column. Select it, then Add Column ▸ Duplicate Column.

    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.

Start free