PowerPoint Certification Data Visualization 2

Question 1

Which chart type is best for showing the distribution of a single continuous dataset, such as exam scores across a class?

Accepted Answer

Histogram

Answer

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?

Accepted Answer

Switch Row/Column

Answer

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?

Accepted Answer

Cumulative effect of sequentially introduced positive and negative values

Answer

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?

Accepted Answer

The rectangular region bounded by the axes where data is plotted

Answer

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?

Accepted Answer

Horizontal (X) axis

Answer

In column/bar charts, the horizontal X-axis displays category labels while the vertical Y-axis shows the numeric values.

PowerPoint Certification Practice Test