8 ICT pg 9

What is the primary purpose of a column chart?

• To illustrate the distribution of a dataset.

• To show the relationship between two variables.

• To compare different categories of data.

• To display data trends over time.

Which axis typically represents categories in a column chart?

• Horizontal axis (x-axis)

• Vertical axis (y-axis)

• Z-axis

• Legend area

What are the three subtypes of column charts available in Excel 2019?

• Clustered Column, Stacked Column, 100% Stacked Column

• Line Chart

• Pie Chart

• Vertical Bar Chart

When is a column chart preferred over other types of charts?

• When comparing discrete categories or showing changes over time.

• When displaying continuous data trends.

• When illustrating proportions of a whole.

• When visualizing complex relationships between variables.

In a column chart, what does each data point represent?

• Each data point represents the average of all measurements in the chart.

• Each data point represents the total of all categories.

• Each data point represents a random value unrelated to the chart.

• Each data point represents a specific value or measurement for a category or time period.

What does a 3-D clustered column chart display?

• A line graph displaying trends over time for multiple categories.

• Data in vertical bars grouped by categories for comparison of multiple data series.

• A pie chart showing percentage distribution of a single category.

• Data in horizontal bars for single data series comparison.

How can you compare different data items using a column chart?

• You can only compare data items if they are in the same category or group.

• You can compare data items by listing them in a table without any visual representation.

• You can compare different data items by representing each item as a column, with the height of the column indicating the value of the item.

• Each data item should be represented as a different color without height variation.

What type of data is best represented by a pie chart?

• Ordinal data

• Quantitative data

• Categorical data

• Time series data

What is the significance of the height of individual points in a column chart?

• The height signifies the value of the data represented.

• The height represents the time period of the data.

• The height shows the average of all data points.

• The height indicates the color of the data points.

How does a stacked column chart differ from a clustered column chart?

• A stacked column chart displays data in a pie format, while a clustered column chart uses a line format.

• A stacked column chart compares multiple categories, while a clustered column chart shows a single category over time.

• A stacked column chart is used for time series data, while a clustered column chart is for categorical data.

• A stacked column chart shows cumulative totals in a single column, while a clustered column chart shows individual values side by side.