Why clean data enables analysis in Google Sheets - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

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

Google Sheets

=SUM([1])

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

AA1+A5

BSUM(A1, A5)

CA1:A5

DA1-A5

Attempts:

3 left

💡 Hint

Common Mistakes

Using plus signs instead of a range.

Trying to sum individual cells inside SUM incorrectly.

The correct way to sum a range of cells from A1 to A5 is to use A1:A5 inside the SUM function.

2fill in blank

medium

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

Google Sheets

=COUNTA([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 minus or plus signs instead of colon for ranges.

Separating cells with semicolons which is invalid here.

The COUNTA function counts non-empty cells in a range. The range must be written as B1:B10.

3fill in blank

hard

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

Google Sheets

=AVERAGE([1])

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

AC1:C5

BC1-C5

CC1,C5

DC1;C5

Attempts:

3 left

💡 Hint

Common Mistakes

Using minus signs instead of colon for ranges.

Separating cells with commas or semicolons inside the range.

The correct range for the AVERAGE function is C1:C5. Using a colon specifies the continuous range.

4fill in blank

hard

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

Google Sheets

=COUNTIF([1], [2])

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

AD1:D10

BD1-D10

C">50"

D>50

Attempts:

3 left

💡 Hint

Common Mistakes

Not putting the condition in quotes.

Using minus instead of colon for the range.

The COUNTIF function needs a range and a condition as a text string. The range is D1:D10 and the condition is ">50" with quotes.

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

Google Sheets

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

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

AE1:E10

B"<100"

DE1-E10

Attempts:

3 left

💡 Hint

Common Mistakes

Using minus instead of colon for ranges.

Not putting the condition in quotes.

Using different ranges for range and sum range incorrectly.

The SUMIF function needs a range, a condition as a text string, and the sum range. Here, the range and sum range are both E1:E10, and the condition is "<100".