Power Query Quiz

What is the primary function of Power Query in Power BI?

• To create visualisations

• To import and transform data

• To manage user permissions

• To generate reports

Which of the following is NOT a step you can perform in Power Query?

• Remove duplicates

• Merge queries

• Create dashboards

• Filter rows

In Power Query, what is the purpose of the 'Append Queries' feature?

• To combine multiple queries into one

• To remove null values

• To change data types

• To create calculated columns

Which language is used to create custom functions in Power Query?

• DAX

• M

• SQL

• Python

What does the 'Group By' feature in Power Query allow you to do?

• Sort data in ascending order

• Aggregate data based on a specific column

• Filter data by date

• Split columns

How can you remove rows with errors in Power Query?

• Use the 'Remove Errors' option

• Use the 'Replace Values' option

• Use the 'Split Column' option

• Use the 'Group By' option

What is the result of using the 'Pivot Column' feature in Power Query?

• It converts rows into columns

• It merges two tables

• It removes duplicate rows

• It filters data by a specific value

Which of the following is a valid data source for Power Query?

• Microsoft Excel

• Google Sheets

• Notepad

• Microsoft Word

What does the 'Unpivot Columns' feature do in Power Query?

• It converts columns into rows

• It merges multiple queries

• It removes null values

• It changes data types

In Power Query, what is the purpose of the 'Conditional Column' feature?

• To create a new column based on conditions

• To remove duplicate columns

• To filter data by date

• To split columns