Sparklines in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to create a sparkline for data in cells A1 to A5.

Excel

=SPARKLINE([1])

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

AA1:A5

BB1:B5

CA5:A1

DA1:B5

Attempts:

3 left

💡 Hint

Common Mistakes

Using a range with multiple columns like A1:B5.

Reversing the range order like A5:A1.

The sparkline formula needs the range of data to visualize. Here, A1:A5 is the correct range.

2fill in blank

medium

Complete the formula to create a line sparkline for data in cells C1 to C6.

Excel

=SPARKLINE(C1:C6, [1])

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

A"line"

B1

C{"charttype", "line"}

D{"charttype", "column"}

Attempts:

3 left

💡 Hint

Common Mistakes

Using just "line" without the key.

Using a number instead of an options array.

The second argument is an options array. To specify a line chart, use {"charttype", "line"}.

3fill in blank

hard

Fix the error in the sparkline formula to show a column chart for data in D1 to D4.

Excel

=SPARKLINE(D1:D4, [1])

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

A{charttype, column}

B"column"

Ccolumn

D{"charttype", "column"}

Attempts:

3 left

💡 Hint

Common Mistakes

Omitting quotes around keys or values.

Not using curly braces for options.

The options must be a proper array with keys and values as strings. {"charttype", "column"} is correct.

4fill in blank

hard

Fill both blanks to create a sparkline with a win/loss chart type for data in E1 to E7.

Excel

=SPARKLINE([1], [2])

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

AE1:E7

B{"charttype", "winloss"}

C{"charttype", "column"}

DE1:E6

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong data range.

Choosing the wrong chart type option.

The data range is E1:E7 and the chart type option for win/loss is {"charttype", "winloss"}.

5fill in blank

hard

Fill all three blanks to create a sparkline for F1:F5 with a column chart and set the color to red.

Excel

=SPARKLINE([1], { [2], "column" ; [3] })

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

AF1:F5

B"charttype"

C"column"

D"color", "red"

Attempts:

3 left

💡 Hint

Common Mistakes

Not using quotes around keys or values.

Missing the color option.

The data range is F1:F5. The options include the key "charttype" with value "column" and the key "color" with value "red". Here, the learner fills the key for chart type and the color option.