MO-211 practice question 2 of 35
Which chart type is best used to display trends over time?
Full set: 355 questionsDomain Insert tables, charts, SmartArt, 3D models, and media
A line chart is the most effective type for displaying trends over time. It plots data points at regular intervals (such as days, months, or years) and connects them with a line, which clearly illustrates the progression and fluctuations of the data. This continuous visual representation makes it easy to identify patterns, such as increases, decreases, or volatility, across a time series. This is its primary and intended function in data visualization.
A. Pie Chart: Incorrect. Pie charts represent the proportions of a whole at a single point in time; they cannot show how data changes over a period.
C. Scatter Chart: Incorrect. Scatter charts are used to show the relationship and correlation between two different numerical variables, not necessarily a trend over a continuous time axis.
D. Bar Chart: Incorrect. While bar charts can display data over time periods, they are better for comparing discrete categories rather than showing a continuous trend.
1. Microsoft Corporation. (n.d.). Available chart types in Office. Microsoft Support. Retrieved from https://support.microsoft.com/en-us/office/available-chart-types-in-office-a6187218-807e-4103-9e0a-27cdb19afb90.
Section: Line charts: "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. (n.d.). Data Visualization: Chart Types. MIT.edu. Retrieved from https://libguides.mit.edu/data-visualization/chart-types.
Section: Line Graph: "Line graphs are used to track changes over short and long periods of time. When smaller changes exist
line graphs are better to use than bar graphs."
3. University of Washington. (n.d.). Choosing the Right Chart Type. Center for Social Science Computation and Research (CSSCR).
Section: Line Graphs: "Line graphs are used to display data that changes continuously over time. The line in a line graph connects a series of points that represent the data."
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 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?
- Question 7How can you apply a custom number format to a cell in Excel?
