Power QueryExercises

Working with columns quiz

Choose vs remove, renaming, ordering and stability when the schema changes.

Revise first: Choose Columns vs Remove Columns, Rename and reorder columns, Duplicate and combine columns, When a column goes missing: MissingField options

Question 1

1.Next month the export adds a column. Which step keeps your report at exactly three columns?

Question 2

2.You share a roster minus Salary and Email, and HR may add useful columns later. Which step fits?

Question 3

3.What does this return?

Table.ColumnNames(Table.SelectColumns(#table({"A", "B", "C"}, {{1, 2, 3}}), {"C", "A"}))
Question 4

4.What happens if Table.SelectColumns lists a column that doesn't exist?

Question 5

5.You rename Qty to Quantity at the end of the query. A custom column earlier uses [Qty]. Is that a problem?

Question 6

6.What does this return?

Table.ColumnNames(Table.RenameColumns(#table({"OrderID", "Qty"}, {{1, 2}}), {{"Qty", "Quantity"}}))
Question 7

7.How do you refer to a column named Order Date inside each?

Question 8

8.Which is true about column names in M?

0 of 8 answered. Unanswered questions count as wrong.