CES Data Analysis & Visualization 2

Question 1

Which built-in Excel chart type groups numeric values into bins to show their frequency distribution?

Accepted Answer

Histogram

Answer

A histogram groups values into bins and plots how often values fall into each bin.

Question 2

Which of the following is NOT a sparkline type available in Excel?

Accepted Answer

Pie

Answer

Excel offers only Line, Column, and Win/Loss sparklines.

Question 3

When should you plot a data series on a secondary vertical axis in a combo chart?

Accepted Answer

When two series have very different value ranges

Answer

A secondary axis keeps a small-scale series readable next to a large-scale one, such as revenue and percent margin.

Question 4

Which trendline option smooths out fluctuations by averaging a specified number of consecutive data points?

Accepted Answer

Moving Average

Answer

A Moving Average trendline averages a set Period of points to show the pattern more clearly.

Question 5

Which conditional formatting feature shows a bar inside each cell whose length is proportional to the cell's value?

Accepted Answer

Data Bars

Answer

Data Bars draw an in-cell bar whose length reflects the value relative to the other cells in the range.

CES - Certified Excel Specialists Practice Test