Why clean data entry prevents errors 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 a dash '-' instead of a colon ':' for ranges.

Using a semicolon ';' which is not valid for ranges.

Adding cells with '+' instead of using a range.

The correct range syntax in Excel uses a colon ':' to specify a range of cells, like A1:A5.

2fill in blank

medium

Complete the formula to calculate the average of cells B1 to B10.

Excel

=AVERAGE([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 a dash '-' instead of a colon ':' for ranges.

Using a semicolon ';' which is invalid for ranges.

Adding cells with '+' instead of using a range.

To calculate the average of a range, use a colon ':' to specify the range like B1:B10.

3fill in blank

hard

Fix the error in the formula to count non-empty cells in C1 to C20.

Excel

=COUNTA([1])

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

AC1:C20

BC1-C20

CC1;C20

DC1+C20

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dash '-' instead of a colon ':' for ranges.

Using a semicolon ';' which is invalid for ranges.

Adding cells with '+' instead of using a range.

The correct range syntax uses a colon ':' to specify the range C1:C20 for COUNTA.

4fill in blank

hard

Fill both blanks to create a dictionary of word lengths for words longer than 4 letters.

Excel

{word: [1] for word in words if len(word) [2] 4}

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

Alen(word)

B<=

C>

Dword

Attempts:

3 left

💡 Hint

Common Mistakes

Using word instead of len(word) for the value.

Using <= instead of > for the condition.

The dictionary maps each word to its length using len(word). The condition filters words longer than 4 letters using > 4.

5fill in blank

hard

Fill all three blanks to create a dictionary of uppercase words and their lengths for words longer than 3 letters.

Excel

{ [1]: [2] for word in words if len(word) [3] 3 }

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

Aword.upper()

Blen(word)

C>

Dword

Attempts:

3 left

💡 Hint

Common Mistakes

Using word instead of word.upper() for keys.

Using <= instead of > for filtering.

Using word instead of len(word) for values.

The dictionary uses the uppercase version of each word as the key (word.upper()), the length as the value (len(word)), and filters words longer than 3 letters (> 3).