8 ICT pg 12

What are the three components that make up the plot area in a 3D chart?

• X-axis, Y-axis, Time-axis

• X-axis, Y-axis, Color-axis

• X-axis, Y-axis, Value-axis

• X-axis, Y-axis, Z-axis

What is the purpose of the legend in a chart?

• To display the chart title and subtitle.

• To provide a decorative element in the chart.

• To show the source of the data used in the chart.

• To identify and explain the data series or categories in a chart.

How do gridlines help in interpreting a chart?

• Gridlines obscure the data points on the chart.

• Gridlines are only useful for aesthetic purposes.

• Gridlines make the chart more complicated to read.

• Gridlines help in interpreting a chart by providing visual reference points for aligning data with axis values.

What information does a data label provide?

• A data label indicates the time of data collection.

• A data label indicates the category or class of a data point.

• A data label shows the geographical location of the data point.

• A data label provides the numerical value of a data point.

Where does the data table come from in relation to a chart?

• The data table is unrelated to the chart's data.

• The data table is a visual representation of the chart.

• The data table serves as the source of data for the chart.

• The data table is created after the chart is made.

In MS Excel 2019, what determines the number of data points in a data series?

• The total number of cells in the worksheet.

• The number of non-empty cells in the selected range.

• The number of formulas in the selected range.

• The maximum number of rows in the worksheet.

What is the first step to create a chart in MS Excel 2019?

• Choose a chart type from the menu.

• Open a new Excel workbook.

• Select the data you want to include in the chart.

• Click on the 'Insert' tab.

Why might someone choose to display gridlines on a chart?

• To improve readability and help interpret data values and trends.

• To reduce the amount of information displayed.

• To make the chart look more colorful.

• To hide important data points.

What is the significance of assigning unique colors or patterns to data series?

• It simplifies the data entry process.

• It reduces the need for data analysis.

• It improves data interpretation and visual differentiation.

• It enhances data storage efficiency.

How can you identify a specific data point on a chart?

• Locate the intersection of the relevant x and y values on the chart.

• Choose a random point on the chart.

• Identify the color of the data point.

• Select the highest value on the chart.