Test: Excel Charting - 2 - Primary 6 MCQ

Column chart

Line chart

Scatter plot

Pie chart

Charts are interactive and allow users to modify the data.

Charts make it easier to sort and filter data.

Charts can display large amounts of data more efficiently than tables.

Charts are not affected by changes in the underlying data.

=SUM()

=MAX()

=AVERAGE()

=COUNT()

Insert

Format

Review

Data

Pie chart

Bar chart

Scatter plot

Radar chart

To add a second set of data to the chart

To adjust the scale of the primary axis

To add a trendline to the chart

To display a different chart type on the same chart

Line chart

Area chart

Doughnut chart

Bubble chart

Copy and paste the data

Use the "Transpose" feature

Manually re-enter the data

Use the "Convert to Range" option

Bar chart

Scatter plot

Bubble chart

Radar chart

Right-click on the chart and select "Add Trendline"

Use the "Format" tab in the Chart Tools menu

Use the "Insert" tab and select "Trendline"

Drag and drop the trendline from the chart elements menu

Line chart

Scatter plot

Area chart

Radar chart

Right-click on the chart and select "Add Data Labels"

Use the "Design" tab in the Chart Tools menu

Use the "Format" tab and select "Data Labels"

Drag and drop the data labels from the chart elements menu

To display the data labels

To add a title to the chart

To identify the data series in the chart

To change the chart type

Use the "Create Dynamic Range" option in the Chart Tools menu

Use the "OFFSET" function in the chart data source

Use the "Dynamic Range" feature in the Format tab

Drag and drop the dynamic range from the chart elements menu

To display additional information about the data points

To add a third dimension to the chart

To create dynamic chart ranges

To adjust the scale of the chart axes