Query Editor interface in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to load data from an Excel table named 'SalesData' in Query Editor.

Excel

let Source = Excel.CurrentWorkbook(){[Name=[1]]}[Content] in Source

Drag options to blanks, or click blank then click option'

A'SalesData'

B"SalesData"

CSalesData

DSales_Data

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting to put the table name in quotes

Using single quotes instead of double quotes

Using an incorrect table name

The table name must be a text string in quotes inside the record selector.

2fill in blank

medium

Complete the code to filter rows where the 'Region' column equals 'West' in Query Editor.

Excel

FilteredRows = Table.SelectRows(Source, each [Region] [1] "West")

Drag options to blanks, or click blank then click option'

A=

B==

Cis

Dequals

Attempts:

3 left

💡 Hint

Common Mistakes

Using '==' instead of '='

Using 'is' or 'equals' which are not valid operators here

In Query Editor's M language, the equality operator is a single equals sign '='.

3fill in blank

hard

Fix the error in the code to rename the column 'OldName' to 'NewName' in Query Editor.

Excel

RenamedColumns = Table.RenameColumns(Source, [1])

Drag options to blanks, or click blank then click option'

A{{"OldName", "NewName"}}

B["OldName", "NewName"]

C{"OldName", "NewName"}

D("OldName", "NewName")

Attempts:

3 left

💡 Hint

Common Mistakes

Using single curly braces instead of double

Using square brackets instead of curly braces

Not wrapping the pair in a list

The second argument must be a list of lists, so double curly braces are needed around the pair.

4fill in blank

hard

Fill both blanks to add a new column 'Total' that sums 'Price' and 'Tax' columns in Query Editor.

Excel

AddedColumn = Table.AddColumn(Source, [1], each [Price] [2] [Tax])

Drag options to blanks, or click blank then click option'

A"Total"

B+

C-

D"Sum"

Attempts:

3 left

💡 Hint

Common Mistakes

Using a name without quotes

Using '-' instead of '+'

Using an incorrect column name

The new column name must be a text string, and the operator to add numbers is '+'.

5fill in blank

hard

Fill all three blanks to create a list of values from the 'Name' column where 'Age' is greater than 30 in Query Editor.

Excel

FilteredList = Table.Column(Table.SelectRows(Source, each [[3]] [2] 30), [1])

Drag options to blanks, or click blank then click option'

A"Name"

B>

C<

D"Age"

Attempts:

3 left

💡 Hint

Common Mistakes

Using List.Select on the Name column directly with _ > 30 (wrong logic)

Wrong order of blanks

Using '<' instead of '>'

Not using quotes around column names

We first filter the table rows where Age > 30 using Table.SelectRows, then extract the 'Name' column as a list using Table.Column.