Test: Excel Charting - 1 - Primary 6 MCQ

Line chart

Bar chart

Scatter plot

Table chart

Column chart

Line chart

Pie chart

Scatter plot

The dependent variable

The independent variable

The category labels

The data series

Column chart

Line chart

Scatter plot

Pie chart

Column chart

Line chart

Scatter plot

Pie chart

Combine multiple chart types in a single chart

Combine multiple data series in a single chart

Combine multiple charts into a single worksheet

Combine multiple worksheets into a single chart

Right-click on the chart and select "Combine Chart Types"

Use the "Chart Tools" tab in the ribbon to select different chart types

Copy and paste multiple charts into a single worksheet

Use a specialized combination chart template

Continuous data

Discrete data

Categorical data

Numerical data

Select the data and click on the "Pie Chart" button in the ribbon

Use the "Insert" tab in the ribbon to add a pie chart

Copy and paste a pie chart from another worksheet

Use a specialized pie chart template

They are best used to show trends over time.

They can only display a single data series.

The size of each slice represents the percentage of the whole.

They are not suitable for displaying percentages.

To display the name of the chart

To identify the data series in the legend

To show the value of a data point

To provide a title for the chart

Changing the chart type

Adding a title and axis labels

Formatting the data series

Adjusting the size of the worksheet

Click and drag the chart's border

Use the "Size" option in the "Format Chart" menu

Right-click on the chart and select "Resize Chart"

Charts cannot be resized in Excel

Display a secondary set of data alongside the primary data

Add a second chart to the same worksheet

Combine multiple data series into a single series

Change the appearance of the chart's axis labels

TRENDLINE()

LINEST()

FORECAST()

GROWTH()