The correct answer is: C. A collection of related data
A data series is a collection of related data points that are plotted on a chart. Each data point in a data series is represented by a single value, such as a number, date, or text string. The data points in a data series are usually connected by a line or curve.
A data series can be created by selecting a range of cells in a spreadsheet. The cells in the range must contain data that is related to each other. For example, a data series could contain the sales figures for each month of the year.
Once a data series has been created, it can be plotted on a chart. To do this, select the data series and then click the Insert tab on the ribbon. In the Charts group, click the type of chart that you want to create. The chart will be inserted into the spreadsheet.
The data series in a chart can be formatted in a variety of ways. For example, you can change the color of the data points, the type of line that connects the data points, and the title of the chart.
Here is a brief explanation of each option:
- A. A type of chart is not correct because a data series is not a type of chart. A data series is a collection of related data points that are plotted on a chart.
- B. A cell reference is not correct because a data series is not a cell reference. A cell reference is a way of identifying a cell in a spreadsheet.
- D. A division of results is not correct because a data series is not a division of results. A data series is a collection of related data points that are plotted on a chart.