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

 
 
 
 
 
 

2. How can you remove duplicates in Power Query?

 
 
 
 

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

 
 
 
 

4. What is Power Query primarily used for?

 
 
 
 

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

 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

15. What is the M language in Power Query?

 
 
 
 

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

 
 

17. Where does Power Query store its transformation steps?

 
 
 
 

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

 
 
 
 

19. How do you refresh data in Power Query?

 
 
 

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

Conditional Formatting Excel Quiz 15

Test your MS Excel skills with this 20-question Trend-Based Conditional Formatting Excel Quiz! Learn how to highlight data trends, use icon sets, color scales, and sparklines, and master custom formatting rules. Ideal for Excel users who want to visualize patterns, analyze data efficiently, and automate formatting tasks. Can you answer all questions correctly? Take the Conditional Formatting Excel Quiz now and level up your spreadsheet expertise! Let us start with the Trend-Based Conditional Formatting Excel Quiz now.

Online Trend Based Conditional Formatting Excel Quiz with Answers
Please go to Conditional Formatting Excel Quiz 15 to view the test

Trend Based Conditional Formatting Excel Quiz

  • Conditional formatting allows you to automatically apply formatting to one or more cells based on the cell value. This means that conditional formatting can automatically change the cell colour, font, border, or even show a different number of decimal places.
  • What does trend-based formatting do?
  • When applying Icon Sets, the original values still appear in the cell.
  • Which of the following methods allows us to remove conditional formatting (more than one may apply)?
  • Which would be the appropriate Conditional Formatting set if you wanted to highlight all values over 300?
  • Conditional formatting can be used to highlight duplicate values.
  • Conditional formatting by using a formula is advantageous over other conditional formatting because:
  • Excel allows us to record macros to automate difficult or repetitive procedures. Which of the following is true of recording macros?
  • What is the key difference between a sparkline and a chart in Excel?
  • Sparklines are a useful data visualisation tool for which of the following cases (more than one may apply):
  • After creating a sparkline, we can drag the fill handle to create multiple sparklines.
  • If you use the fill handle to create multiple sparklines, the sparklines will form a set of connected charts, meaning if you change one, you change all of them. It is possible to unlink sparklines if you do not wish them to behave this way.
  • Custom number formats can be accessed in which of the following ways:
  • When customising a number format:
  • When customising a number format, which character acts as the separator for specifying different formats for different types of values?
  • What type of brackets should we use when specifying colours for our custom number formats?
  • If a cell contains the value 0, what will be displayed when we apply the following custom number format: [Red]â–²;[Green]â–¼;
  • What is the primary purpose of trend-based conditional formatting in Excel?
  • Which conditional formatting option is specifically designed to show trends?
  • When using color scales for trend analysis, what does a red-yellow-green color scale typically represent?

Statistics For Data Analyst

MS Excel Dashboard MCQs 14

Are you an MS Excel pro or just getting started with dashboard creation? This 35-question MS Excel Dashboard MCQs Quiz will test your knowledge on MS Excel Dashboards. The MS Excel Dashboard MCQs Test covers the topics:

Dashboard Design Principles (layout, colors, interactivity)
PivotTables & Pivot Charts (dynamic data representation)
Slicers & Filters (making dashboards interactive)
Charts & Visualizations (best chart types for trends, KPIs)
Conditional Formatting & Excel Tables (keeping data updated)
Macros & Hyperlinks (automating dashboard actions)

Who Should Take This MS Excel Dashboard MCQs Quiz?
Data Analysts looking to refine dashboard skills
Excel Users who want to build professional reports
Students & Professionals preparing for interviews
Anyone who loves Excel challenges!

Please go to MS Excel Dashboard MCQs 14 to view the test
Online MS Excel Dashboard MCQs Quiz With Answers

Online MS Excel Dashboard MCQs with Answers

  • What are some good dashboard design principles?
  • What are some usual considerations regarding the size of a dashboard?
  • If your cells in Excel are white with a thin grey outline, one quick way to create a dashboard with a white background is to turn off the gridlines.
  • Coloured shapes are more useful placeholders of information in dashboards than colouring the background of cells, as shapes are not restricted to the column width and row height proportions.
  • When using an Align tool, such as Align Right, how does Excel determine the alignment of the elements we have highlighted?
  • You can place a chart into a dashboard by going to our PivotChart Design tab and selecting Move Chart.
  • It is important to edit or format your chart before you move into your dashboard.
  • One difference between Pivot Charts and normal charts is that you cannot edit a Pivot Chart to be linked to a different data set.
  • You can link a regular chart to a PivotTable.
  • If you want to cut/copy, and paste multiple elements, a useful tool is
  • Dragging the fill handle down to create multiple charts from one that you have already created is possible if you are using
  • One way to add interactivity to your dashboards is by adding
  • What will copying and pasting a shape to one of the columns or bars in a chart do?
  • It is not good practice to use Pivot Charts based on calculated fields to a dashboard
  • To create a slicer, you need to select
  • The number of slicers that Excel will allow us to create depends on the
  • To make your dashboard interactive, each element of your dashboard will need to have its own slicer.
  • The slicer style has to be the same style as you have chosen for your Excel worksheets to appear. For example, if your worksheet windows have grey outlines, so will your slicer.
  • If you want to link your slicer to multiple dashboard elements, you should go to:
  • How can we choose not to display the Column letters: “A, B, C…” and Row numbers “1, 2, 3…”?
  • Suppose that you place a shape to cover an entire chart. Now, what would happen if you changed the outline and fill to No Outline and No Fill, and you activate a link/hyperlink for the shape?
  • It is best practice to add a refresh button to a dashboard that contains pivots because
  • Once a dashboard has been created, it is best practice to change colours using Colors rather than Themes because:
  • When assigning macros to a dashboard, each macro can relate to only one element of the dashboard.
  • What is an Excel Dashboard?
  • Which Excel feature is most commonly used to create interactive dashboards?
  • What type of chart is best for showing trends over time in a dashboard?
  • Which tool in Excel allows users to filter dashboard data interactively?
  • What is the purpose of using Conditional Formatting in a dashboard?
  • Which Excel function is useful for summarizing data in dashboards?
  • What does a KPI (Key Performance Indicator) represent in a dashboard?
  • Which feature helps in creating mini-charts within a cell for dashboards?
  • Why is it important to avoid clutter in an Excel dashboard?
  • Which tool connects a dashboard to external data sources?
  • What is the primary benefit of using Excel Tables (Ctrl + T) as a data source for dashboards?

Summarizing Data in R Base Package