Power Query Editor Quiz

What is the main purpose of Power Query Editor in PowerBI?

• Creating complex visualizations

• Cleaning, transforming, and loading data

• Designing dashboards

• Performing data analysis

What feature in Power Query Editor enables you to combine two tables based on a common column?

• Merge Queries

• Append Queries

• Group By

• Pivot Column

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

• Filter rows

• Add a calculated column

• Create a new page

• Change column data types

What does "Remove Duplicates" do in Power Query Editor?

• Deletes all data from the query

• Removes rows with repeated values in a specific column

• Merges two identical queries

• Transforms text to uppercase

In Power Query Editor, what is the purpose of the "Applied Steps" pane?

• To preview the results of your transformations

• To show a record of all the transformations applied to the data

• To display visualizations of the transformed data

• To create new calculated columns

How can you undo a specific transformation step in Power Query Editor?

• Delete the entire query

• Right-click the step in the "Applied Steps" pane and select "Delete"

• Use the undo button in PowerBI

• Reload the data from the source

What happens when you use "Append Queries" in Power Query Editor?

• Joins two tables side by side

• Combines the rows of two tables

• Creates a new query from two different sources

• Filters out unnecessary data from both queries

Which of the following actions can you perform using the Transform tab in Power Query Editor?

• Split columns

• Remove tables

• Add tables to reports

• Publish data

What file formats can Power Query Editor import data from?

• CSV, Excel, JSON

• Only CSV and Excel

• Only Excel

• CSV, JSON, but not Excel