Line charts in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to select the data range for a line chart from cells A1 to B5.

Excel

Select the range [1] to create a line chart.

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

AA1:B5

BA1-B5

CA1;B5

DA1_B5

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dash '-' instead of a colon ':'

Using semicolon ';' or underscore '_' which are invalid for ranges

The correct way to select a range in Excel is using a colon between the start and end cells, like A1:B5.

2fill in blank

medium

Complete the formula to calculate the average of values in cells B2 to B6 for the line chart data.

Excel

=AVERAGE([1])

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

AB2:B6

BB2;B6

CB2-B6

DB2_B6

Attempts:

3 left

💡 Hint

Common Mistakes

Using dash '-' or semicolon ';' inside the formula range

Using underscore '_' which is invalid

Excel uses a colon ':' to specify a range in formulas, so B2:B6 is correct.

3fill in blank

hard

Fix the error in the formula to sum values in cells C1 to C10 for the line chart.

Excel

=SUM([1])

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

AC1-C10

BC1;C10

CC1:C10

DC1_C10

Attempts:

3 left

💡 Hint

Common Mistakes

Using dash '-' or semicolon ';' instead of colon ':'

Using underscore '_' which is invalid

The correct range syntax in Excel formulas uses a colon ':', so C1:C10 is correct.

4fill in blank

hard

Fill both blanks to create a line chart data dictionary with months as keys and sales as values.

Excel

data = [1] for month, sales in zip(months, [2])

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

A{month: sales}

B[month, sales]

Csales

Dmonths

Attempts:

3 left

💡 Hint

Common Mistakes

Using list syntax instead of dictionary syntax

Swapping months and sales in the zip

To create a dictionary with months as keys and sales as values, use {month: sales} and iterate over sales.

5fill in blank

hard

Fill all three blanks to filter sales data for values greater than 100 before plotting the line chart.

Excel

filtered = { [1]: [2] for [3] in sales if sales[[1]] > 100 }

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

Amonth

Bvalue

Dsales

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong variable names causing key errors

Confusing keys and values in the comprehension

The dictionary comprehension uses month as key, value as value, and iterates over month in sales keys.