WorksheetsPower Query Quiz
Total questions: 15
Worksheet time: 8mins
1. What is the main purpose of Power Query in Excel?
To create pivot tables
To get and transform data from various sources
To perform macros and VBA automation
To generate random data
2. Which of the following file types can be imported using Power Query? Choose multiple answers
Website
CSV
Excel files
3. How do you install Power Query in Excel?
It is an external software you download
It is part of the Excel ribbon in newer versions
It is included in Microsoft Word
It requires a browser extension
4. What does unpivoting columns to rows help you achieve?
Hide columns
Make a chart
Normalize data for analysis
Remove duplicate rows
5. Which of the following is not a transformation type in Power Query?
Number
Date/Time
Macro
Text
6. What is one key benefit of using Power Query?
It replaces the need for Excel formulas
It simplifies data cleaning and transformation
It eliminates the use of Excel sheets
It provides graphic design tools
7. What is the result of merging tables in Power Query?
One table with combined rows from both tables
One table with only the headers
An Excel chart
A PowerPoint slide
8. Which method can be used to remove rows with errors?
Using the conditional formatting tool
Applying a filter for error rows
Sorting alphabetically
Hiding the row manually
9. What does the “Replace Values” function in Power Query do?
Deletes all values in a column
Finds and substitutes values based on conditions
Changes column names
Filters out blank rows
10. Which feature allows you to bring together data from multiple files in a folder?
Append Queries
Data Model
Combine Files
VLOOKUP
11. What type of values can be filtered using Power Query filters? Choose multiple answers
Text
Date
Number
12. What happens when you transpose a table in Power Query?
Rows become columns and columns become rows
Data is deleted
Table is hidden
Only headers are modified
How can you make correction to your transformation steps in Power Query?
You need to plan all transformation steps beforehand because you cannot make any mistakes
CTRL Z
Delete the mistaken step(s) from the Applied Steps
Close the Query Editor window and redo the entire processes
By default, what is the maximum number of records displayed in the Query Editor?
500
1000
1500
Unlimited
What is the default join type when you merge tables in Power Query?
Inner Join
Outer Join
Left Outer
Left Anti-Join
