Excel Power Query Questions 16

Think you know Excel Power Query Questions? Take this interactive MCQ quiz (about MS Excel Power Query Questions) to test your knowledge on data source in Power Query, Power Query Editor, merging queries, joins (inner, outer, anti), M language, data transformation, and more! Perfect for Excel users, Power BI analysts, and data professionals looking to master ETL (Extract, Transform, Load) techniques. Let us start with the MS Excel Power Query Questions Quiz now.

Online MS Excel Power Query Questions with Answers

Online MS Excel Power Query Questions with Answers

1. What does “Unpivot Columns” do in Power Query?

 
 
 
 

2. What happens when you disable “Load” for a query in Power Query Editor?

 
 
 
 

3. What does the “Group By” feature in Power Query allow you to do?

 
 
 
 

4. What is the purpose of the “Parameters” feature in Power Query?

 
 
 
 

5. Which of the following is NOT a data source in Power Query?

 
 
 
 

6. Where does Power Query store its transformation steps?

 
 
 
 

7. A Merge Query performs a similar functionality to some Excel functions. Which functions are they?

 
 
 
 

8. What is the M language in Power Query?

 
 
 
 

9. How can you remove duplicates in Power Query?

 
 
 
 

10. Suppose that we have two queries containing two employment data sets. Each data set has the historical employee details of two subsidiary companies of the same parent organisation. What type of join is required to find out the employees who have worked in both organisations?

 
 
 
 
 
 

11. In which Microsoft applications can Power Query be used?

 
 
 
 

12. Which Power Query feature allows combining data from multiple sources?

 
 
 
 

13. If you have a query that displays the output from a Right Anti Join, the last few characters of the M code in the formula bar will read JoinKind.RightAnti. What will happen if we edit the text in the formula bar to replace JoinKind.RightAnti with JoinKind.RightOuter and press Enter?

 
 
 
 

14. For a Merge Query to work, we do not need the column headings to match; however, we do need the values of one column in one query to relate to the values of a column in the other query.

 
 

15. What is a “Query Step” in Power Query?

 
 
 
 

16. What is Power Query primarily used for?

 
 
 
 

17. Which Power Query operation would you use to split a single column into multiple columns?

 
 
 
 

18. How can you handle errors (e.g., division by zero) in Power Query?

 
 
 
 

19. What could you do if you needed to merge three queries?

 
 
 

20. How do you refresh data in Power Query?

 
 
 

Question 1 of 20

Online Excel Power Query Questions Quiz

  • A Merge Query performs a similar functionality to some Excel functions. Which functions are they?
  • For a Merge Query to work, we do not need the column headings to match; however, we do need the values of one column in one query to relate to the values of a column in the other query.
  • Suppose that we have two queries containing two employment data sets. Each data set has the historical employee details of two subsidiary companies of the same parent organisation. What type of join is required to find out the employees who have worked in both organisations?
  • What could you do if you needed to merge three queries?
  • If you have a query that displays the output from a Right Anti Join, the last few characters of the M code in the formula bar will read JoinKind.RightAnti. What will happen if we edit the text in the formula bar to replace JoinKind.RightAnti with JoinKind.RightOuter and press Enter?
  • What is Power Query primarily used for?
  • In which Microsoft applications can Power Query be used?
  • Which Power Query feature allows combining data from multiple sources?
  • What is the M language in Power Query?
  • How do you refresh data in Power Query?
  • What does “Unpivot Columns” do in Power Query?
  • Which of the following is NOT a data source in Power Query?
  • What is a “Query Step” in Power Query?
  • How can you remove duplicates in Power Query?
  • Where does Power Query store its transformation steps?
  • What does the “Group By” feature in Power Query allow you to do?
  • Which Power Query operation would you use to split a single column into multiple columns?
  • What is the purpose of the “Parameters” feature in Power Query?
  • How can you handle errors (e.g., division by zero) in Power Query?
  • What happens when you disable “Load” for a query in Power Query Editor?

Learn about the R Programming Language

Leave a Comment

Discover more from Statistics for Data Science & Analytics

Subscribe now to keep reading and get access to the full archive.

Continue reading