Value fields and aggregation in Excel - Interactive Code Practice

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

CSUM(A1, A5)

DA1-A5

Attempts:

3 left

💡 Hint

Common Mistakes

Using plus signs instead of a range.

Trying to subtract cells instead of summing.

Using incorrect syntax inside SUM.

The SUM function adds all numbers in the range A1 to A5.

2fill in blank

medium

Complete the formula to calculate the average of values in cells B2 to B6.

Excel

=AVERAGE([1])

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

AB2-B6

BB2,B6

CB2:B6

DB2+B6

Attempts:

3 left

💡 Hint

Common Mistakes

Using subtraction or addition instead of a range.

Separating cells with commas incorrectly.

Not using a proper range format.

The AVERAGE function calculates the mean of the numbers in the range B2 to B6.

3fill in blank

hard

Fix the error in the formula to count how many cells in C1 to C10 contain numbers.

Excel

=COUNT([1])

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

AC1:C10

BC1,C10

CC1+C10

DC1-C10

Attempts:

3 left

💡 Hint

Common Mistakes

Using commas or minus signs instead of a colon.

Adding cells instead of specifying a range.

Using incorrect range syntax.

The COUNT function requires a range like C1:C10 to count numeric cells.

4fill in blank

hard

Fill both blanks to calculate the maximum value in range D1 to D8 and multiply it by 2.

Excel

=MAX([1]) * [2]

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

AD1:D8

BD1-D8

C2

D8

Attempts:

3 left

💡 Hint

Common Mistakes

Using subtraction instead of a range.

Multiplying by the wrong number.

Incorrect range syntax.

MAX(D1:D8) finds the highest number in the range, then multiplying by 2 doubles it.

5fill in blank

hard

Fill all three blanks to create a formula that sums values in E1 to E5 only if they are greater than 10.

Excel

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

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

AE1:E5

B">10"

DE1-E5

Attempts:

3 left

💡 Hint

Common Mistakes

Using subtraction instead of ranges.

Not quoting the condition properly.

Using different ranges for criteria and sum.

SUMIF sums cells in E1:E5 where the value is greater than 10, checking the same range for sum.