Data Visualization MCQS

Q. What is data visualization?

A
Writing code to process data
B
The graphical representation of data using charts, graphs, and dashboards
C
Storing data in a database
D
Cleaning data in Power Query
Solution:

Data visualization encodes data as visual elements — position, length, color — so patterns and trends are immediately visible.

Q. Which chart type is best for showing a trend over time?

A
Pie chart
B
Tree map
C
Line chart
D
Scatter chart
Solution:

Line charts display data points connected along a continuous axis (typically time), making them ideal for showing upward/downward trends and seasonality.

Q. What does a scatter chart show?

A
Proportions of a whole
B
The correlation or relationship between two numeric variables
C
Geographic data on a map
D
Hierarchical category sizes
Solution:

Scatter charts plot two numeric values against each other, revealing whether they are positively correlated, negatively correlated, or uncorrelated.

Q. Which Python library is most commonly used for basic data visualization?

A
NumPy
B
Pandas
C
Matplotlib
D
Scikit-learn
Solution:

Matplotlib is the foundational Python plotting library; Seaborn and Plotly build on it for more specialized or interactive visuals.

Q. What is the purpose of conditional formatting in data visualization?

A
To change the data source
B
To visually highlight cells or bars based on their value using color scales, data bars, or icons
C
To remove duplicate data
D
To create relationships between tables
Solution:

Conditional formatting applies visual cues (color, icons, data bars) based on values, helping viewers spot high/low performers at a glance.

Q. In Power BI, what is the difference between a Table and a Matrix visual?

A
A Table supports hierarchies; a Matrix does not
B
A Matrix supports row/column grouping with expandable hierarchies; a Table shows a flat grid
C
They are identical
D
A Matrix can only show numbers
Solution:

A Matrix works like a pivot table with expandable/collapsible row and column groupings, while a Table displays a flat, spreadsheet-like grid.

Q. Which of the following is NOT a common data visualization tool?

A
Power BI
B
Tableau
C
Matplotlib
D
SQL Server Management Studio
Solution:

SQL Server Management Studio is a database management tool, not a visualization tool. Power BI, Tableau, and Matplotlib are all designed for creating visual representations of data.

Q. Why does visual perception research recommend bar charts over pie charts for comparing quantities?

A
Bar charts use less ink
B
Humans judge position along a common scale (bars) more accurately than angle (pie slices)
C
Pie charts cannot show more than 5 categories
D
Bar charts load faster in dashboards
Solution:

Perceptual research (Cleveland & McGill) shows position-on-a-common-scale judgments are more accurate than angle judgments, making bar charts more precise for comparison tasks.

Q. What is IoT data visualization primarily used for?

A
Generating sales forecasts
B
Monitoring real-time sensor and device data streams on dashboards
C
Creating presentation slides
D
Writing Python code
Solution:

IoT visualization displays live sensor readings, threshold alerts, and time-series trends from connected devices, enabling real-time operational monitoring.

Q. What does a combo chart combine?

A
A pie chart and a bar chart
B
A column chart and a line chart, often on different Y-axis scales
C
Two scatter charts
D
A map and a table
Solution:

A combo chart merges columns and a line to show two related measures — for example, revenue (columns) and margin percentage (line) — making dual-metric comparisons easy.

Q. What does KPI stand for?

A
Key Performance Indicator
B
Knowledge Processing Interface
C
Key Product Index
D
Kernel Program Instruction
Solution:

KPI stands for Key Performance Indicator — a measurable value that shows how effectively a goal is being met.

Q. How many KPIs should a well-designed dashboard typically show?

A
As many as possible
B
4 to 8
C
Exactly 1
D
20 or more
Solution:

Best practice recommends 4-8 KPIs so the viewer can scan the dashboard in seconds without information overload.

Q. Where should the most important KPI be placed on a dashboard?

A
Bottom-right corner
B
Center of the page
C
Top-left area, above the fold
D
Behind a dropdown menu
Solution:

The eye naturally starts at the top-left and scans in an F-pattern, so the headline KPI should be placed there.

Q. In Power BI, what is the difference between a Dashboard and a Report?

A
They are the same thing
B
A Dashboard is a Service-only, single-page view of pinned tiles; a Report is a multi-page, interactive file authored in Desktop
C
A Report cannot be published
D
A Dashboard supports DAX; a Report does not
Solution:

Power BI Dashboards are single-page, pinned-tile views in the Service; Reports are multi-page, interactive files built in Desktop and published to the Service.

Q. What is the purpose of adding a 'last refreshed' timestamp to a KPI dashboard?

A
To fill empty space
B
To show viewers how current the data is, building trust in the number
C
To track who designed the dashboard
D
To display the creation date
Solution:

 last refreshed’ timestamp lets viewers know the data’s freshness, which is critical for decision-making — stale data can lead to wrong conclusions.

Q. Which visual type is best for showing a single metric vs. a target?

A
Line chart
B
KPI card or gauge visual
C
Scatter chart
D
Tree map
Solution:

kPI cards show a value vs. target with a trend indicator; gauges show progress on a radial dial — both are purpose-built for single-metric-vs-target display.

Q. A dashboard has 15 KPIs and requires scrolling. What should you do?

A
Add a vertical scrollbar
B
Reduce to 4-8 KPIs and move the rest to a drill-through report page
C
Make the font smaller
D
Use a pie chart for each KPI
Solution:

A dashboard should fit on one screen. Move secondary metrics to drill-through pages so the dashboard stays focused on the headline KPIs

Q. Why should green/red color be used purposefully rather than decoratively on a KPI dashboard?

A
To save ink
B
Because green/red carries implicit meaning (good/bad), so using it decoratively misleads viewers and reduces accessibility for colorblind users
C
Green is harder to render
D
red slows down dashboard load time
Solution:

Green/red triggers an instant good/bad judgment. Using it decoratively dilutes the signal and is inaccessible to colorblind viewers unless paired with an icon or label.

Q. What is the most common data visualization mistake?

A
Using too few colors
B
Choosing the wrong chart type for the data and question
C
Making charts too large
D
Using Power BI instead of Tableau
Solution:

Chart-type mismatch is the most frequent mistake — a pie chart for 12 categories or a line chart for unordered data immediately misleads viewers.

Q. Why should bar charts almost always start the Y-axis at zero?

A
To save space
B
Because viewers judge bar length, and a non-zero start exaggerates differencesPower BI requires it
C
Power BI requires it
D
it looks nicer
Solution:

Bar chart comparison relies on length perception. Starting above zero makes small differences look dramatic and large ones look trivial.

Q. What is 'chart junk'?

A
Incorrect data in a chart
B
Decorative elements (3D effects, gradients, background images) that add no information and increase cognitive load
C
A chart with too many data points
D
A chart without a title
Solution:

Chart junk refers to non-data ink — visual elements that don’t convey information but clutter the chart and can distort perception.

Q. What percentage of men have red-green color vision deficiency?

A
About 1 %
B
About 8 %
C
About 25 %
D
About 50 %
Solution:

 Approximately 8 % of men (and 0.5 % of women) have red-green color vision deficiency, making red/green-only color coding inaccessible for a significant audience.

Q. A chart is titled simply 'Revenue.' What should it say instead?

A
'Revenue'
B
Monthly Revenue by Region, Jan–Dec 2025
C
'Chart 1'
D
No title is needed
Solution:

 A descriptive title states the measure, dimension, and time period so the viewer immediately knows what they are looking at.

Q. A dashboard has 18 visuals on one page. What is the best corrective action?

A
Make each visual smaller
B
Reduce to 6-8 key visuals and move the rest to drill-through pages
C
Add a second scrollable section
D
Remove all visuals and use tables only
Solution:

Keeping 6-8 visuals avoids clutter while drill-through pages preserve access to secondary metrics for viewers who need them.

Q. How many core colors should a dashboard color theme typically use?

A
1
B
3 to 5
C
10 to 15
D
As many as there are data series
Solution:

A palette of 3-5 core colors reduces cognitive load while providing enough variation for different data series and semantic meanings

Q. Why should red and green be reserved for semantic meaning on dashboards?

A
They are the brightest colors
B
They carry inherent 'bad/good' meaning — using them decoratively dilutes the signal and harms accessibility
C
Power BI only supports red and green
D
They load faster
Solution:

Red = below target and green = above target are near-universal conventions. Using them as decoration confuses viewers and is inaccessible to colorblind users.

Q. In Power BI, how do you apply a custom color theme?

A
Edit each visual's colors individually
B
View → Themes → Browse for themes → select a JSON file
C
It is not possible
D
File → Options → Default Colors
Solution:

Custom themes are applied via View → Themes → Browse and accept a JSON file that sets dataColors, background, foreground, and other visual defaults.

Q. What contrast ratio does WCAG recommend for text on dashboards?

A
1.5:1
B
3:1
C
4.5:1
D
10:1
Solution:

WCAG AA requires at least 4.5:1 contrast between text and its background for normal-sized text, ensuring readability for viewers with low vision.

Q. A dashboard uses a 10-color palette with several similar shades. What is the risk?

A
The dashboard will crash
B
Viewers may confuse similar shades, misreading which series is which — especially on projectors or for colorblind users
C
Power BI will reject the theme
D
Similar shades improve aesthetics
Solution:

Similar shades are hard to distinguish, especially under sub-optimal viewing conditions (projectors, small screens, color vision deficiency). Fewer, more distinct colors improve accuracy.

Q. Why is a dark background theme risky for dashboards shared widely?

A
Dark themes use more ink when printed
B
Dark backgrounds require careful contrast testing — light text on dark backgrounds can reduce readability if contrast is insufficient, and projectors wash out dark themes
C
Power BI does not support dark themes
D
Dark themes are always better
Solution:

Dark themes can look polished on good screens but fail on projectors, printed copies, and for users with certain visual impairments if contrast isn’t rigorously tested.

Entri PDF Icon

Get Question Bank

Strengthen Your Practice with our comprehensive question bank.