PowerPoint Certification Data Visualization 2 — Questions and Answers
Question 1: Which chart type is best for showing the distribution of a single continuous dataset, such as exam scores across a class?
- Histogram (Correct answer)
- Pie chart
- Scatter plot
- Waterfall chart
Correct answer: Histogram
A histogram groups continuous data into bins and displays frequency, making it ideal for showing distribution.
Question 2: In PowerPoint, which option lets you switch the rows and columns of chart data without editing the Excel worksheet?
- Edit Data
- Switch Row/Column (Correct answer)
- Select Data
- Change Chart Type
Correct answer: Switch Row/Column
The 'Switch Row/Column' button in Chart Design swaps which axis uses rows versus columns from the data sheet.
Question 3: A Waterfall chart in PowerPoint is most useful for visualizing what type of data?
- Cumulative effect of sequentially introduced positive and negative values (Correct answer)
- Geographic distribution of sales
- Correlation between two variables
- Part-to-whole relationships
Correct answer: Cumulative effect of sequentially introduced positive and negative values
Waterfall charts show how an initial value increases or decreases through a series of intermediate values to reach a final total.
Question 4: What does the 'Plot Area' refer to in a PowerPoint chart?
- The rectangular region bounded by the axes where data is plotted (Correct answer)
- The overall chart frame including the title
- The legend box showing series names
- The area outside the axes
Correct answer: The rectangular region bounded by the axes where data is plotted
The plot area is the inner region of a chart, bounded by the axes, where the actual data series are drawn.
Question 5: Which axis is typically used to display categories (such as months or product names) in a standard bar or column chart?
- Horizontal (X) axis (Correct answer)
- Vertical (Y) axis
- Secondary axis
- Depth (Z) axis
Correct answer: Horizontal (X) axis
In column/bar charts, the horizontal X-axis displays category labels while the vertical Y-axis shows the numeric values.
Question 6: When would you add a secondary vertical axis to a PowerPoint chart?
- When two data series have very different value ranges (Correct answer)
- When you want to display more than five series
- When the chart has no legend
- When the data contains negative values
Correct answer: When two data series have very different value ranges
A secondary axis allows data series with vastly different scales to be displayed together without one series being unreadable.
Question 7: Which SmartArt category in PowerPoint is most appropriate for illustrating a decision-making flowchart?
- Process (Correct answer)
- Hierarchy
- Cycle
- Relationship
Correct answer: Process
The Process category contains layouts designed to show steps, workflows, and decision paths in a sequential flow.
PowerPoint Certification Data Visualization 2
Which chart type is best for showing the distribution of a single continuous dataset, such as exam scores across a class?