Power QueryExercises

Data types and locale quiz

Choosing types, locale-aware conversion, and the difference between null, empty text and errors.

Revise first: Choose types deliberately: identifiers are text, Convert dates and numbers with a locale, null, empty text and errors are different things, Inspect column types and catch conversion errors

Question 1

1.Which column should be text even though it contains only digits?

Question 2

2.Text dates look like 05/03/2026 and mean 5 March. Which culture do you convert with?

Question 3

3.What does this return?

Number.FromText("1.234,5", "de-DE")
Question 4

4.What does this return?

null + 1
Question 5

5.What does this return?

"" = null
Question 6

6.You filter [Supplier] <> "". What happens to rows where Supplier is null?

Question 7

7.What does Int64.Type do to the value 2.7 when converting?

Question 8

8.Without a culture argument, how is text converted to dates?

0 of 8 answered. Unanswered questions count as wrong.