Selecting data for charts in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to select the range A1 to B5 for the chart data.

Excel

=SUM([1])

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 range format in Excel uses a colon ':' between start and end cells, like A1:B5.

2fill in blank

medium

Complete the formula to select the first 3 rows in column C for the chart.

Excel

=AVERAGE([1])

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

AC1;C3

BC1-C3

CC1:C3

DC1_C3

Attempts:

3 left

💡 Hint

Common Mistakes

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

Using underscore '_' which is not valid for ranges

Excel uses a colon ':' to specify a range, so C1:C3 selects cells C1 to C3.

3fill in blank

hard

Fix the error in the formula to select data from cells D2 to D10 for the chart.

Excel

=SUM([1])

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

AD2:D10

BD2;D10

CD2_D10

DD2-D10

Attempts:

3 left

💡 Hint

Common Mistakes

Using dash '-' which subtracts values instead of selecting a range

Using semicolon ';' or underscore '_' which are invalid range separators

The correct way to specify a range in Excel is with a colon ':', so D2:D10 selects cells from D2 to D10.

4fill in blank

hard

Fill both blanks to create a formula that sums values in column E from row 1 to row 7.

Excel

=SUM([1]:[2])

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

AE1

BE7

C:

D-

Attempts:

3 left

💡 Hint

Common Mistakes

Using dash '-' instead of colon ':'

Putting the separator before the start cell

The colon ':' separates the start and end cells.

5fill in blank

hard

Fill both blanks to create a formula that averages values from cells F3 to F8.

Excel

=AVERAGE([1]:[2])

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

AF3

BF8

C:

D-

Attempts:

3 left

💡 Hint

Common Mistakes

Using dash '-' instead of colon ':'

Reversing the order of start and end cells