PowerPoint Certification Data Visualization 3 — Questions and Answers
Question 1: In a PowerPoint combo chart, what is the purpose of assigning one series to a 'Line' type while another remains 'Clustered Column'?
- To visually separate the series and make trend comparison easier (Correct answer)
- To remove the legend
- To merge two separate slides
- To apply 3-D rotation automatically
Correct answer: To visually separate the series and make trend comparison easier
Combo charts combine chart types so users can contrast volume (columns) with trend (line) on the same visualization.
Question 2: What is the effect of applying 'Smooth Line' formatting to a line chart series in PowerPoint?
- It curves the line between data points rather than connecting them with straight segments (Correct answer)
- It removes data markers from the line
- It converts the line to a bar
- It adds a shadow effect to each point
Correct answer: It curves the line between data points rather than connecting them with straight segments
Smooth Line renders a Bezier-curved path between data points, giving a flowing appearance instead of angular segments.
Question 3: Which feature in PowerPoint allows you to display each data label as the actual value, percentage, or series name on a chart?
- Data Labels (Correct answer)
- Data Table
- Axis Titles
- Chart Title
Correct answer: Data Labels
Data Labels attach textual callouts directly on or near each data point showing its value, percentage, or category.
Question 4: If you want chart data to update automatically when the linked Excel file is changed, which method should you use when inserting the chart?
- Paste Special > Paste Link (Correct answer)
- Copy and Paste (standard)
- Insert > Object > Create New
- Screenshot the chart
Correct answer: Paste Special > Paste Link
Paste Special with Paste Link creates an OLE link so the PowerPoint chart reflects changes made in the source Excel file.
Question 5: What is the primary visual purpose of adding gridlines to a PowerPoint chart?
- To help viewers estimate data values by providing reference lines across the plot area (Correct answer)
- To separate chart series by color
- To add a border around the chart
- To display axis labels more prominently
Correct answer: To help viewers estimate data values by providing reference lines across the plot area
Gridlines extend tick marks across the plot area so readers can trace data points to axis values without guessing.
Question 6: Which chart element should you modify to change the interval at which numbers appear along the value axis?
- Axis units (Major/Minor) (Correct answer)
- Series fill
- Plot area border
- Chart title font
Correct answer: Axis units (Major/Minor)
Axis Major and Minor Units control how frequently tick marks and labels appear along the value (numeric) axis.
Question 7: When a pie chart slice is 'exploded' in PowerPoint, what visual effect does this create?
- The slice is pulled away from the center of the pie to emphasize it (Correct answer)
- All slices rotate 90 degrees
- The slice is deleted from the chart
- The entire pie becomes a donut chart
Correct answer: The slice is pulled away from the center of the pie to emphasize it
Exploding a slice offsets it outward from the pie's center, drawing the viewer's attention to that specific segment.
PowerPoint Certification Data Visualization 3
In a PowerPoint combo chart, what is the purpose of assigning one series to a 'Line' type while another remains 'Clustered Column'?