MO-211 practice question 31 of 35
Which chart type is used to represent data that is consecutively measured over time?
Full set: 355 questionsDomain Insert tables, charts, SmartArt, 3D models, and media
A line chart is the most effective type for displaying continuous data measured over time. It connects individual data points with a line, which clearly illustrates trends, patterns, and fluctuations at equal intervals, such as days, months, or years. This visual connection between points emphasizes the progression and change in data values across a time period, making it the standard choice for time-series analysis.
A. Pie chart: This chart represents proportions of a whole at a single point in time and cannot show changes or trends over a period.
B. Column chart: While it can display data over time, it emphasizes the magnitude of individual data points rather than the continuous trend between them.
C. Bar chart: This is a horizontal version of a column chart, best used for comparing values across discrete categories, not for showing continuous time-series data.
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-272112e7b08e.
Reference Detail: In the "Line charts" section
the documentation 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. Duke University Libraries. (n.d.). Data Visualization: Chart Types - Line Chart. Retrieved from https://guides.library.duke.edu/dataviz/charttypes.
Reference Detail: Under the "Line Chart" section
it specifies
"Line charts are used to show a trend or change over time. They are best used to show many data points."
3. University of Washington. (n.d.). Choosing the Right Chart Type. Foster School of Business. Retrieved from https://foster.uw.edu/wp-content/uploads/2015/02/choosing-the-right-chart-type.pdf.
Reference Detail: Page 1
under "Line Chart
" the document explains its purpose is to "Show a trend over 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?
