Power QueryExercises

Numbers, dates and conditional columns quiz

Rounding modes, date parts, durations and conditional logic.

Revise first: Conditional columns with if … then … else, Rounding numbers, Date parts and durations, Month starts, month ends and period keys

Question 1

1.What does this return?

Number.Round(2.5)
Question 2

2.What does this return?

Number.Round(2.5, 0, RoundingMode.AwayFromZero)
Question 3

3.What does this return?

Duration.Days(#date(2026, 3, 1) - #date(2026, 2, 1))
Question 4

4.What does this return?

Date.QuarterOfYear(#date(2026, 7, 4))
Question 5

5.What does this return?

let q = 5 in if q <= 2 then "Small" else if q <= 5 then "Medium" else "Bulk"
Question 6

6.What does this return?

let q = null in if q <= 2 then "Small" else "Other"
Question 7

7.What does this return?

Date.Day(Date.EndOfMonth(#date(2028, 2, 3)))
Question 8

8.When should you round in a calculation chain?

0 of 8 answered. Unanswered questions count as wrong.