Why structured data enables analysis in Excel - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to sum values in cells A1 to A5.

Excel

=SUM([1])

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

AA1-A5

BA1+A5

CA1:A5

DA1;A5

Attempts:

3 left

💡 Hint

Common Mistakes

Using '+' instead of ':' to specify a range

Using ';' which is not valid for ranges

Subtracting cells instead of summing

The correct way to sum a range in Excel is to use a colon between the start and end cells, like A1:A5.

2fill in blank

medium

Complete the formula to count how many cells in B1 to B10 contain numbers.

Excel

=COUNT([1])

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

AB1-B10

BB1:B10

CB1;B10

DB1+B10

Attempts:

3 left

💡 Hint

Common Mistakes

Using '-' or '+' instead of ':' for ranges

Using ';' which is invalid for ranges

The COUNT function counts numeric values in a range specified with a colon, like B1:B10.

3fill in blank

hard

Fix the error in this formula to find the average of cells C1 to C8.

Excel

=AVERAGE([1])

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

AC1:C8

BC1;C8

CC1-C8

DC1+C8

Attempts:

3 left

💡 Hint

Common Mistakes

Using '-' which subtracts cells

Using ';' which is invalid for ranges

Using '+' which adds cells

The correct range syntax uses a colon ':' between the first and last cell, like C1:C8.

4fill in blank

hard

Fill both blanks to create a formula that counts cells in D1 to D12 that are greater than 5.

Excel

=COUNTIF([1], [2])

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

AD1:D12

B>5

CD1;D12

D<5

Attempts:

3 left

💡 Hint

Common Mistakes

Using semicolon ';' instead of colon ':' for range

Using wrong comparison operator in condition

COUNTIF needs a range and a condition. The range is D1:D12 and the condition is ">5" to count values greater than 5.

5fill in blank

hard

Fill all three blanks to create a formula that sums values in E1 to E10 only if they are less than 20.

Excel

=SUMIF([1], [2], [3])

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

AE1:E10

B<20

D>20

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong operators in condition

Mixing up range and sum_range arguments

SUMIF needs a range to check (E1:E10), a condition ("<20"), and the sum range (E1:E10) to add matching values.