WorksheetsPower BI MCQ Questions
Total questions: 20
Worksheet time: 10mins
When importing a CSV file, Power BI shows the first row as column names by default. Which action ensures proper column naming if the first row is not headers?
Promote headers
Rename columns manually
Change data type
Remove duplicates
If a column contains repeated values that you want to standardize, which feature in Power Query can you use?
Remove duplicates
Group by
Split column
Replace values
You notice your dataset has extra blank columns. What is the best practice to prepare the data for analysis?
Leave them as they are
Remove unnecessary columns
Promote headers
Rename columns
When should you rename columns in Power BI?
Only after creating visuals
To make the dataset more readable and understandable
It is optional and has no effect
Only for date columns
Which transformation allows you to convert rows into columns for easier analysis?
Merge queries
Append queries
Pivot
Split column
John has a table where one column shows year and month in “YYYYMM” format. He wants to create a proper date column. Which Power Query transformation should he use?
Change data type to date
Add column from examples
Split column by number of characters
Remove duplicates
Maria wants to remove all rows where the “Sales Amount” is blank. Which Power Query action should she apply?
Remove errors
Filter rows
Group by
Pivot column
A retail company’s dataset has multiple errors in the “Customer Email” column. Some emails are missing, others are duplicates. What steps should the analyst take first in Power Query?
Promote headers → Remove duplicates → Remove errors
Remove unnecessary columns → Change data type → Merge queries
Append queries → Group by → Create index
Pivot column → Split column → Rename columns
An analyst is combining sales data from three branches into one table. Which Power Query feature should they use?
Merge Queries
Append Queries
Pivot
Group By
Why is it important to set correct data types in Power Query?
To improve report design
To ensure accurate calculations and analysis
To create dashboards
To merge queries
Which data source allows Power BI to connect directly to relational tables using queries?
Web
SQL Database
Image files
You want to automatically create a sequential numbering column in Power Query. Which feature should you use?
Index Column
Conditional Column
Group By
Pivot Column
A sales manager wants to see total revenue per region. The dataset has multiple sales transactions per region. Which steps should an analyst take?
Remove duplicates → Append queries
Pivot region column → Aggregate values
Merge queries → Remove errors
Create conditional column → Change data type
When grouping data by “Product Category,” which aggregation could you apply to see total sales?
Count rows
Sum of sales
Average of sales
All of the above
A company wants to forecast customer churn. They ask, “How many customers are likely to cancel next month?” Which type of analysis is required?
Descriptive
Diagnostic
Predictive
Prescriptive
Jane wants to highlight sales above $10,000 in a new column as “High” and others as “Low.” Which Power Query action should she use?
Group By
Conditional Column
Merge Queries
Append Queries
Which Power Query M function combines two tables based on a common column?
Table.Combine
Table.Join
Table.Pivot
Table.AddColumn
Case Study – Numeric vs Text A financial analyst receives a sales dataset where the “Quantity Sold” column is imported as text. When she tries to sum it to calculate total sales, the result is incorrect. She also notices that some rows have letters accidentally typed in. What should she do in Power Query?
Change the column to Date/Time
Change the column to Number and remove invalid text rows
Keep as Text to preserve all values
Convert to Boolean
A financial analyst finds “NULL” values in a revenue column. To replace them with the average revenue, which transformation is most appropriate?
Merge Queries
Remove Errors
Replace Values
Pivot Column
A company wants to consolidate monthly sales tables for January, February, and March into a single table. Which Power Query feature should they use?
Merge Queries
Append Queries
Pivot Column
Group By
