Why advanced charts tell better stories in Excel - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a basic line chart using Excel formula syntax.

Excel

Chart.AddChart2([1])

Drag options to blanks, or click blank then click option'

AxlPie

BxlLine

CxlBar

DxlArea

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing pie chart type for trend data.

Using bar chart type when a line chart is needed.

The xlLine option creates a line chart, which is a common basic chart type for showing trends.

2fill in blank

medium

Complete the code to add data labels to the chart.

Excel

Chart.SeriesCollection(1).[1].ShowValue = True

Drag options to blanks, or click blank then click option'

ADataLabels

BLegend

CAxes

DTitle

Attempts:

3 left

💡 Hint

Common Mistakes

Trying to show legend instead of data labels.

Using axes property incorrectly.

Data labels show the exact values on the chart, making the story clearer.

3fill in blank

hard

Fix the error in the code to set the chart title text.

Excel

Chart.[1].Text = "Sales Over Time"

Drag options to blanks, or click blank then click option'

ATitle

BLegend

CDataLabels

DAxes

Attempts:

3 left

💡 Hint

Common Mistakes

Using Legend instead of Title for the chart heading.

Trying to set text on DataLabels property.

The Title property sets the chart's main heading, which helps tell the story clearly.

4fill in blank

hard

Fill both blanks to add a secondary axis and set its title.

Excel

Chart.SeriesCollection(1).[1] = [2]
Chart.Axes(xlValue, [2]).HasTitle = True

Drag options to blanks, or click blank then click option'

AAxisGroup

BxlPrimary

CxlSecondary

DHasDataLabels

Attempts:

3 left

💡 Hint

Common Mistakes

Using xlPrimary instead of xlSecondary for the second axis.

Confusing HasDataLabels with AxisGroup.

Setting AxisGroup to xlSecondary moves the series to the secondary axis. Then we enable the title for that axis.

5fill in blank

hard

Fill all three blanks to create a dictionary of average sales by region with condition.

Excel

avg_sales = { [1] for region, sales in sales_data.items() if sum(sales) [2] 1000 and region != [3] }

Drag options to blanks, or click blank then click option'

Aregion: sum(sales)/len(sales)

B>

C"East"

Dregion: sum(sales)

Attempts:

3 left

💡 Hint

Common Mistakes

Using sum(sales) without dividing by length for average.

Using wrong comparison operator.

Not excluding the East region correctly.

This dictionary comprehension calculates average sales for regions with sales over 1000, excluding the East region.