Why advanced charts tell deeper stories in Google Sheets - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to calculate the average of values in cells A1 to A10.

Google Sheets

=AVERAGE([1])

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

AA1:A10

BA1-A10

CA1,A10

DA1;A10

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dash '-' instead of a colon ':'

Separating cells with commas or semicolons

The correct range syntax in Google Sheets uses a colon to specify a range, like A1:A10. This tells the formula to include all cells from A1 through A10.

2fill in blank

medium

Complete the formula to count how many cells in B1:B20 contain numbers.

Google Sheets

=COUNT([1])

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

AB1:B20

BB1;B20

CB1-B20

DB1,B20

Attempts:

3 left

💡 Hint

Common Mistakes

Using commas or semicolons instead of a colon

Using a dash '-' which is invalid for ranges

The COUNT function counts numeric values in a range. The correct range syntax is B1:B20.

3fill in blank

hard

Fix the error in this formula that sums values in C1 to C15 but skips empty cells.

Google Sheets

=SUMIF([1], ">0")

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

AC1-C15

BC1:C15

CC1;C15

DC1,C15

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dash '-' or commas instead of a colon

Not specifying a range but just two cells

The SUMIF function needs a proper range like C1:C15 to check each cell. Using a colon defines the range correctly.

4fill in blank

hard

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

Google Sheets

=COUNTIF([1], [2])

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

AD1:D30

B"<50"

C">50"

DD1-D30

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dash '-' for the range

Using the wrong comparison operator or missing quotes

The COUNTIF function needs a range and a condition. The range is D1:D30 and the condition to count numbers greater than 50 is ">50".

5fill in blank

hard

Fill all three blanks to create a formula that sums values in E1:E25 only if they are less than 100.

Google Sheets

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

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

AE1:E25

B"<100"

DE1-E25

Attempts:

3 left

💡 Hint

Common Mistakes

Using dashes '-' instead of colons

Not quoting the condition

Using different ranges for check and sum

The SUMIF function takes three parts: the range to check (E1:E25), the condition ("<100"), and the range to sum (also E1:E25 in this case).