WorksheetsPower BI 1 Quiz
Total questions: 14
Worksheet time: 7mins
Name
Class
Date
1.
What is the main role of Power BI?
a)
Create dynamic websites
b)
Clean data only
c)
Prepare, explore, visualize, and share data
d)
Replace Excel for all uses
2.
Which built-in Power BI tool allows data cleaning and transformation?
a)
Power Query
b)
Power Pivot
c)
Excel Connect
d)
Query Wizard
3.
Which function is used to combine two tables by rows in Power BI?
a)
Merge
b)
Append
c)
Pivot
d)
Join
4.
Which Power BI visualization is most appropriate for time variation?
a)
Treemap
b)
Bar chart
c)
Pie chart
d)
Line chart
5.
Why use slicers in a Power BI dashboard?
a)
To add graphic styles
b)
To let the user filter data dynamically
c)
To export visuals
d)
To speed up loading
6.
Which feature allows you to explore a chart by different hierarchy levels?
a)
Split
b)
Drill-down
c)
Tooltips
d)
Bookmarks
7.
Which element allows saving a filtered view in Power BI?
a)
Bookmark
b)
Theme
c)
Matrix
d)
Slicer
8.
Which chart type is useful to visually compare a hierarchy?
a)
Line chart
b)
Table
c)
Treemap
d)
Pie chart
9.
When should the ‘Merge’ feature in Power BI be used?
a)
When changing data types
b)
When displaying geographic maps
c)
When joining two tables by a common key
d)
When creating a KPI
10.
What is the benefit of creating a relational model in Power BI?
a)
Reduce the number of displayed rows
b)
Improve visual style
c)
Avoid data duplication and simplify multi-table analysis
d)
Increase file sizes
11.
Which chart type is best suited to display data broken down by region and time?
a)
Line chart
b)
Bar chart
c)
Area chart
d)
Pie chart
12.
Select all components that belong to the Power BI object model.
a)
Reports
b)
Dashboards
c)
Semantic Models
d)
Workspaces
13.
What is the role of bookmarks in Power BI?
a)
Save background themes across multiple reports
b)
Enable exporting of visuals to Excel
c)
Save filters, slicers, sort order for navigation or presentation
d)
Create animations between visuals
14.
What’s the purpose of the 'Column From Examples' feature in Power Query?
a)
Automatically merge two datasets
b)
Sort columns alphabetically
c)
Use AI to create transformation rules from example input
d)
Apply DAX formulas directly in Power Query
100 %
