UNIQUE function in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to get unique values from the range A1:A10.

Google Sheets

=UNIQUE([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 '+' or '-' instead of ':' to specify ranges.

Using semicolons ';' which are not valid for ranges.

The UNIQUE function takes a range as input. Using A1:A10 correctly selects the range.

2fill in blank

medium

Complete the formula to get unique values from the range B2:B20 and sort them.

Google Sheets

=SORT(UNIQUE([1]))

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

AB2:B20

BB2+B20

CB2;B20

DB2-B20

Attempts:

3 left

💡 Hint

Common Mistakes

Using '+' or '-' instead of ':' for ranges.

Using semicolons ';' which are invalid for ranges.

The UNIQUE function requires a range like B2:B20. Then SORT arranges the unique values.

3fill in blank

hard

Fix the error in the formula to get unique values from C1:C15.

Google Sheets

=UNIQUE([1])

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

The correct range syntax uses a colon ':' between start and end cells, like C1:C15.

4fill in blank

hard

Fill both blanks to create a formula that extracts unique values from D1:D30 and counts them.

Google Sheets

=COUNTA(UNIQUE([1])) + [2]

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

AD1:D30

BD1;D30

C0

D1

Attempts:

3 left

💡 Hint

Common Mistakes

Using semicolons instead of colons for ranges.

Adding 1 changes the count incorrectly.

The UNIQUE function needs the range D1:D30. Adding 0 keeps the count unchanged.

5fill in blank

hard

Fill all three blanks to create a formula that extracts unique values from E2:E25, sorts them, and returns the third item.

Google Sheets

=INDEX(SORT(UNIQUE([1])), [2], [3])

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

AE2:E25

B3

C1

D2

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect range syntax.

Mixing up row and column numbers in INDEX.

The formula extracts unique values from E2:E25, sorts them, then INDEX returns the 3rd row and 1st column value.