Course quiz: Data Analysis and Visualization with Power BI :Data Analysis and Visualization with Power BI (Microsoft Power BI Data Analyst Professional Certificate) Answers 2025

Question 1 (Select all)

Effective use of report page properties means:

• ✅ The report page layout matches the viewing platform.

• ❌ The report has a single, solid color as the background.

• ✅ The name of the report page gives clear context about the content.

• ❌ All the reports are presented in a 4:3 format.

Question 2

Visual elements that benefit from conditional formatting:

• ✅ Tables and bar charts

Question 3

Why data visualizations are essential in business communication:

• ✅ They help in making data more memorable and persuasive.

Question 4

First step in creating a data visualization:

• ✅ Connecting to your desired data sources

Question 5 (Select all)

Best visuals to compare sales performance by categories:

• ✅ Column charts

• ❌ Line charts

• ✅ Bar charts

• ❌ Tables

Question 6

Best chart to track revenue/expenses over time:

• ✅ Line chart

Question 7 (Select all)

Elements used to arrange & organize visuals:

• ❌ Filters pane

• ❌ Ribbon

• ✅ Report Canvas

• ❌ Fields pane

Question 8 (Select all)

Purpose of the Ribbon:

• ✅ The ribbon allows you to save your project.

• ❌ Manipulating fields

• ❌ Applying filters

• ✅ The ribbon allows you to change your report view.

Question 9

Primary purpose of a ribbon chart:

• ✅ To visualize data that changes over time with a ranking order

Question 10 (Select all)

Dashboards:

• ❌ Only charts

• ❌ Drill-down like reports

• ✅ Present critical business data visually

• ✅ Transform data into actionable insights

Question 11 (Select all)

Combo chart capabilities:

• ❌ Real-time summaries

• ❌ Contribution to whole

• ❌ Trend lines subset

• ✅ Visually represent two interconnected data points

Question 12

WCAG ensures:

• ✅ Web content is accessible to people with disabilities

Question 13

Chart that supports markers for accessibility:

• ✅ Line chart

Question 14 (Select all)

Theme customization:

• ❌ Visual interactivity

• ❌ Data label positioning

• ❌ Filter pane settings

• ✅ Font family, size, and color

Question 15

Primary role of tooltips:

• ✅ Provide additional contextual information about data points

Question 16 (Select all)

Hierarchies enable:

• ✅ Structuring data from overview to detail

• ❌ Enhance visualization types

• ✅ Enable drill-down

• ❌ Custom filters

Question 17

Advantage of multiple visualization layers:

• ✅ Reduces complexity of the main report

Question 18

Primary purpose of sorting:

• ✅ Enhance readability and understanding of visuals

Question 19

Difference between cross-filtering & cross-highlighting:

• ✅ Cross-filtering hides unrelated data, cross-highlighting dims it

Question 20

Statistical summary:

• ✅ A comprehensive range of statistical functions used for data analysis

Question 21

Feature to condense large data:

• ✅ Data Binning

Question 22

Histogram visualizes:

• ✅ Distribution of numerical data across bins

Question 23

Why clustering is useful in scatter plots:

• ✅ Enhance interpretability of data distributions

Question 24 (Select all)

Correct axis statements:

• ✅ Continuous axes represent ordered numerical data

• ✅ Categorical axes organize distinct categories

• ❌ All axes are continuous by default

• ❌ Manual input only

Question 25

How to provide feedback on Analyze feature:

• ✅ Thumbs-up and thumbs-down options

Question 26

Why reference lines are disabled in maps:

• ✅ Scale & zoom make consistent reference lines difficult

Question 27

Dashboards help decision-makers by:

• ✅ Visualizing critical information in a consolidated manner

Question 28

Primary benefit of Q&A:

• ✅ Ask questions in plain English and get visual/numeric answers

Question 29

Export report to PDF from:

• ✅ File → Export → To PDF

Question 30

After enabling Performance Analyzer, you must:

• ✅ Generate actions (refresh/interact with report)

🧾 FINAL SUMMARY TABLE