Value aggregation (SUM, COUNT, AVG) in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

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

Google Sheets

=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.

Separating cells with commas or semicolons instead of a colon.

The SUM function adds all numbers in the range A1 to A5. The correct range syntax is A1:A5.

2fill in blank

medium

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

Google Sheets

=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 commas or semicolons instead of a colon for ranges.

Using a dash '-' which is not valid for ranges.

The COUNT function counts numeric values in the range B1 to B10. The correct range syntax is B1:B10.

3fill in blank

hard

Fix the error in the formula to calculate the average of cells C1 to C7.

Google Sheets

=AVERAGE([1])

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

AC1-C7

BC1;C7

CC1:C7

DC1,C7

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dash '-' which is not valid for ranges.

Separating cells with commas or semicolons instead of a colon.

The AVERAGE function calculates the mean of numbers in the range C1 to C7. The correct range uses a colon ':' like C1:C7.

4fill in blank

hard

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

Google Sheets

=SUMIF([1], [2])

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

AD1:D5

B">10"

C<10

DD1-D5

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dash '-' instead of a colon ':' for the range.

Writing the condition without quotes or with wrong comparison.

The SUMIF function sums cells in the range D1:D5 that meet the condition '>10'. The range uses a colon ':' and the condition is a string with the comparison.

5fill in blank

hard

Fill both blanks to create a formula that counts numbers in E1 to E10 that are less than 5.

Google Sheets

=COUNTIF([1], [2])

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

AE1:E10

B"<5"

CE1-E10

DE1;E10

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dash '-' or semicolon ';' instead of a colon ':' for the range.

Not putting the condition in quotes.

The COUNTIF function counts cells in the range E1:E10 that satisfy the condition '<5'. The range uses a colon ':', and the condition is a string.