Power QueryExercises

Power Query basics quiz

Check you understand applied steps, refresh and how M expressions chain together.

Revise first: Applied steps are a recipe, not a one-off edit, Step order matters, Power Query in Excel and Power BI: same engine, different hosts, Read the M behind the Applied Steps

Question 1

1.What happens to your applied steps when you refresh a query?

Question 2

2.A step refers to #"Filtered Rows" but that step was renamed to #"Kept Complete". What do you see?

Question 3

3.Why should you group regions only after trimming and fixing their case?

Question 4

4.What does this return?

let a = 2, b = a * 3 in b + 1
Question 5

5.Which statement about Excel and Power BI is true?

Question 6

6.Which habits make a query refresh-safe? (Select all that apply.)(select all that apply)

Question 7

7.What does this return?

let Source = #table({"Region", "Qty"}, {{"North", 2}, {"South", null}, {"North", 5}, {"West", 1}}) in Table.RowCount(Source)
Question 8

8.Is M case-sensitive?

0 of 8 answered. Unanswered questions count as wrong.