GMetrix Exam GMetrix Excel: Charts and Data Visualization 2 — Questions and Answers
Question 1: What do data labels display on an Excel chart?
- The chart title
- The numeric value of each data point (Correct answer)
- The axis unit
- The series name only
Correct answer: The numeric value of each data point
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?
- Ctrl+Alt+C
- F11 (Correct answer)
- Alt+F1
- Ctrl+F5
Correct answer: F11
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?
- Values placed side by side for each category
- Component values stacked within each bar to show totals (Correct answer)
- Negative values only
- A 3D perspective of the data
Correct answer: Component values stacked within each bar to show totals
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?
- The entire chart including its outer border
- The rectangular region bounded by the axes where data is plotted (Correct answer)
- The chart title area
- The legend box
Correct answer: The rectangular region bounded by the axes where data is plotted
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?
- Line chart
- Bar chart
- Pie chart (Correct answer)
- Area chart
Correct answer: Pie chart
Pie charts divide a circle into slices proportional to each value, clearly showing how parts relate to the total.
Question 6: How do you swap which data is shown on each axis in an Excel chart?
- Click Chart Design > Switch Row/Column (Correct answer)
- Right-click and select Transpose Data
- Click Format > Reverse Axes
- Press Ctrl+T
Correct answer: Click Chart Design > Switch Row/Column
The Switch Row/Column button in the Chart Design tab exchanges the data plotted on the horizontal and vertical axes.
GMetrix Exam GMetrix Excel: Charts and Data Visualization 2
What do data labels display on an Excel chart?