D388 Fundamentals of Spreadsheets and Data Presentations - Set 5 - Part 3

Correct Answer: They help the reader estimate the value of each data point against the value axis

Gridlines are light reference lines extending from the axis across the plot area that help readers visually align data points with the axis scale to estimate values more accurately. They do not label categories (axis labels do that), identify series (the legend does that), or serve as a title. Overly heavy gridlines can add clutter, so they should be kept subtle.

Correct Answer: Pie chart

A pie chart is well suited to showing how a single total is divided into a small number of parts (here, four departments), emphasizing each part's share of the whole. With only four categories, the slices are easy to compare. A line chart shows trends over time, a scatter plot shows relationships between variables, and a histogram shows frequency distributions.

Correct Answer: Choose a scale and intervals that represent the data honestly without exaggerating or minimizing changes

An honest, appropriate axis scale with consistent, sensible intervals ensures that the visual magnitude of changes matches their real magnitude, so the chart neither exaggerates nor understates trends. Deliberately compressing or stretching the axis distorts interpretation, random intervals mislead, and removing the axis leaves readers unable to gauge values.

Correct Answer: Keep the layout simple, consistent, and focused on the most relevant metrics

A good dashboard is simple, consistent, and focused, presenting the most relevant metrics clearly so decision-makers grasp the situation quickly. Overloading the screen with metrics, using inconsistent fonts and colors, or forcing excessive scrolling all reduce clarity and slow comprehension.

Correct Answer: Line chart

A line chart is ideal for displaying how a single continuous value changes over many ordered time intervals, such as daily stock prices across a year, because the connected line makes the overall trend and fluctuations easy to follow. A pie or doughnut chart shows composition at one point in time, and a clustered column chart with 365 columns would be far too cluttered for a dense daily series.

Correct Answer: It creates visual noise and makes it harder to identify what is important

Using many unrelated bright colors overwhelms the viewer, creating visual noise that competes for attention and makes it difficult to discern which elements matter most. A restrained, consistent palette with intentional highlight colors communicates hierarchy more effectively. Color choice does not affect file size, calculation, or legend behavior.

Correct Answer: The categories or groups being compared

In a standard column chart, the horizontal axis (also called the category or x-axis) lists the discrete categories or groups being compared, while the vertical axis shows the measured values. The color key is provided by the legend, and cumulative totals would require a specific chart type such as a running-total line rather than being an inherent function of the horizontal axis.

Correct Answer: The area grows far faster than the underlying value, exaggerating the difference

When an icon is scaled in both width and height to represent a value, its two-dimensional area increases with the square of the scaling factor, so a value that doubles appears about four times larger. This exaggerates differences and misleads viewers. Accurate pictographs should scale by count or by a single dimension, not by area.

Correct Answer: Apply the percentage format with a consistent number of decimal places, e.g., 45.2%

Applying Excel's percentage number format with a consistent number of decimal places (such as 45.2%) makes the values instantly recognizable as percentages and keeps the column visually uniform and easy to scan. Leaving them as raw decimals is harder to interpret, converting to text prevents calculation, and coloring every row differently adds clutter without adding meaning.

Correct Answer: An annotation, which provides context that guides interpretation of the data

An annotation is explanatory text (often with a callout or arrow) placed on a chart to give context about a specific data point or event, helping the audience understand why something happened and guiding interpretation. It is central to data storytelling. Gridlines aid value estimation, legends identify series, and a secondary axis rescales a series, none of which explain events.