Why Excel is essential for data work - 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 plus signs instead of a range.

Using incorrect range syntax.

The SUM function adds all numbers in the range A1 to 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 plus or minus instead of a range.

Multiplying cells instead of averaging.

The AVERAGE function calculates the mean of the numbers in the range B1 to B10.

3fill in blank

hard

Fix the error in the formula to count how many cells in C1 to C20 are greater than 10.

Excel

=COUNTIF([1], ">10")

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 arithmetic operators instead of a range.

Forgetting to use a colon for ranges.

The COUNTIF function needs a range like C1:C20 to check each cell.

4fill in blank

hard

Fill both blanks to create a formula that sums values in D1 to D10 only if they are greater than 5.

Excel

=SUMIF([1], [2])

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

AD1:D10

B">5"

C"><5"

DD1+D10

Attempts:

3 left

💡 Hint

Common Mistakes

Using arithmetic instead of a range.

Using wrong condition signs.

The SUMIF function sums cells in D1:D10 that meet the condition >5.

5fill in blank

hard

Fill both blanks to create a formula that counts cells in E1 to E15 that are equal to 100.

Excel

=COUNTIF([1], [2])

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

AE1:E15

B"=100"

C"100"

DE1+E15

Attempts:

3 left

💡 Hint

Common Mistakes

Using arithmetic instead of range.

Not using quotes around criteria.

The COUNTIF function uses the range E1:E15 and the condition "=100" to count cells equal to 100.