GMetrix Exam GMetrix Excel: Charts and Data Visualization 2

Question 1

What do data labels display on an Excel chart?

Accepted Answer

The numeric value of each data point

Answer

Data labels annotate each data point with its actual value, making charts easier to read without referencing the axis.

Question 2

Which keyboard shortcut creates a new chart on a separate chart sheet in Excel?

Accepted Answer

F11

Answer

Pressing F11 instantly creates a chart on a dedicated chart sheet using the default chart type.

Question 3

What does a stacked bar chart display compared to a clustered bar chart?

Accepted Answer

Component values stacked within each bar to show totals

Answer

Stacked bar charts layer data series within each bar so you can see both individual contributions and the cumulative total.

Question 4

In an Excel chart, what is the plot area?

Accepted Answer

The rectangular region bounded by the axes where data is plotted

Answer

The plot area is the inner section of a chart, framed by the axes, where data series such as bars or lines are rendered.

Question 5

Which chart type is most appropriate for comparing parts of a whole using a single data series?

Accepted Answer

Pie chart

Answer

Pie charts divide a circle into slices proportional to each value, clearly showing how parts relate to the total.

GMetrix Exam Practice Test