FIND and SEARCH in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to find the position of "cat" in cell A1 using FIND.

Google Sheets

=FIND([1], A1)

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

A"cat"

Bcat

C"Cat"

D"dog"

Attempts:

3 left

💡 Hint

Common Mistakes

Not using quotes around the text to find.

Using the wrong text like "dog".

Using unquoted text which causes an error.

The FIND function needs the text to find as a string in quotes. So "cat" is correct.

2fill in blank

medium

Complete the formula to find the position of "apple" in cell B2 using SEARCH (case-insensitive).

Google Sheets

=SEARCH([1], B2)

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

A"Apple"

B"apple"

CApple

Dapple

Attempts:

3 left

💡 Hint

Common Mistakes

Not using quotes around the text.

Using unquoted text causing errors.

Confusing case sensitivity with FIND.

SEARCH needs the text to find as a string in quotes. It is not case-sensitive, so "apple" works.

3fill in blank

hard

Fix the error in the formula to find "dog" in cell C3 using FIND.

Google Sheets

=FIND([1], C3)

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

A"Dog"

Bdog

CDOG

D"dog"

Attempts:

3 left

💡 Hint

Common Mistakes

Leaving out quotes around the text.

Using wrong case when case sensitivity matters.

Using unquoted text causing formula errors.

The text to find must be a string in quotes. "dog" is correct. Without quotes, it causes an error.

4fill in blank

hard

Fill both blanks to create a formula that finds "book" in cell D4 starting from position 3 using SEARCH.

Google Sheets

=SEARCH([1], D4, [2])

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

A"book"

B2

C3

D"Book"

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong starting position number.

Not quoting the text to find.

Confusing FIND and SEARCH arguments.

SEARCH needs the text in quotes and the starting position as a number. "book" and 3 are correct.

5fill in blank

hard

Fill all three blanks to create a formula that finds the position of "pen" in cell E5 starting from position 1 using FIND.

Google Sheets

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

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

A"pen"

BE5

C1

D"Pen"

Attempts:

3 left

💡 Hint

Common Mistakes

Not quoting the text.

Using wrong cell reference.

Wrong starting position number.

FIND needs the text in quotes, the cell reference, and the starting position number. "pen", E5, and 1 are correct.