Power QueryExercises

M language basics quiz

Values, let expressions, records and lists.

Revise first: M basics: let, records and lists, Identifiers, quoted names, escapes and comments, Lists in depth: build, transform, select and access, Records in depth: fields, defaults and combining

Question 1

1.What does this return?

[Name = "Ana", Age = 31][Age]
Question 2

2.What does this return?

{10, 20, 30}{1}
Question 3

3.What does this return?

List.Count({1..5})
Question 4

4.What does this return?

let x = y + 1, y = 2 in x
Question 5

5.What does this return?

#table({"A"}, {{1}, {2}})[A]
Question 6

6.What does this return?

{1, 2}{5}?
Question 7

7.What does this return?

"Q" & Text.From(3)
Question 8

8.What does the in part of a let expression do?

0 of 8 answered. Unanswered questions count as wrong.