MO-211 practice question 21 of 35
Which chart type in Excel is used to display changes in data over time?
Full set: 355 questionsDomain Insert tables, charts, SmartArt, 3D models, and media
A line chart is the most appropriate chart type for displaying changes in data over a continuous period. It plots data points at regular intervals (such as days, months, or years) and connects them with a line, which effectively illustrates trends, accelerations, or decelerations in a time series. The horizontal axis (category axis) is used to represent the progression of time, while the vertical axis (value axis) represents the measured quantity, making it ideal for visualizing performance or change over time.
A. Bar Chart: Primarily used for comparing values across discrete categories, not for showing continuous trends over time.
C. Pie Chart: Represents the proportions of a whole at a single point in time and cannot display data changes over a period.
D. Scatter Chart: Used to show the relationship and correlation between two different sets of numerical data, not specifically for tracking a single value's trend over time.
1. Microsoft Corporation. (n.d.). Available chart types in Office. Microsoft Support. Retrieved from support.microsoft.com. In the "Line charts" section, it states, "Line charts can display continuous data over time, set against a common scale, and are therefore ideal for showing trends in data at equal intervals."
2. MIT Libraries. (2024). Data Visualization: Chart Types & When to Use Them. In the "Line Chart" section, the primary use case is described as: "Use to show time-series data (how a variable changes over time)."
3. Duke University Libraries. (n.d.). Data Visualization: Chart Chooser. The guide recommends a "Line Chart" for visualizing "Data over time" and describes its purpose as showing "trends and changes in data over a period of time."
Keep practicing
Take the free MO-211 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other MO-211 practice questions
- Question 1What formula can be used to calculate the sum of a range of cells in Excel?
- Question 2Which chart type is best used to display trends over time?
- Question 3What is the formula used in Excel to calculate the percentage change between two numbers?
- Question 4What is a slicer in Excel?
- Question 5What is the shortcut key to insert a new worksheet in Excel?
- Question 6What is the shortcut key for copying a formula in Excel?
