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 is Power Query primarily used for?

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

5. 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.

 
 

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

 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

10. How do you refresh data in Power Query?

 
 
 

11. What is the M language in Power Query?

 
 
 
 

12. Where does Power Query store its transformation steps?

 
 
 
 

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

 
 
 
 

14. 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?

 
 
 
 
 
 

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

 
 
 
 

16. How can you remove duplicates in Power Query?

 
 
 
 

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

 
 
 
 

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

 
 
 
 

19. 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?

 
 
 
 

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

 
 
 
 

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