FIND and SEARCH in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

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

Excel

=FIND([1], A1)

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

A"dog"

B"cat"

Ccat

DA1

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting to put the text in quotes

Using a cell reference instead of text

Using SEARCH instead of FIND when case matters

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

Excel

=SEARCH([1], B2)

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

Aapple

B"Apple"

CB2

D"apple"

Attempts:

3 left

💡 Hint

Common Mistakes

Not using quotes around the text

Using FIND instead of SEARCH for case-insensitive search

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

3fill in blank

hard

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

Excel

=FIND([1], C3)

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

A"book"

Bbook

CC3

D"Book"

Attempts:

3 left

💡 Hint

Common Mistakes

Leaving out quotes around the text

Using a cell reference instead of text

The text to find must be in quotes. Without quotes, Excel gives an error.

4fill in blank

hard

Fill both blanks to find the position of "pen" in cell D4 starting from character 3 using SEARCH.

Excel

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

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

A"pen"

B1

C3

D"Pen"

Attempts:

3 left

💡 Hint

Common Mistakes

Not putting the text in quotes

Starting search from position 1 instead of 3

SEARCH("pen", D4, 3) starts searching from the 3rd character in D4 for "pen".

5fill in blank

hard

Fill all three blanks to create a formula that finds "tree" in cell E5 ignoring case, starting from character 2.

Excel

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

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

A"tree"

BE5

C2

D"Tree"

Attempts:

3 left

💡 Hint

Common Mistakes

Using FIND instead of SEARCH for case-insensitive search

Not putting text in quotes

Wrong starting position

SEARCH("tree", E5, 2) finds "tree" ignoring case, starting from character 2 in cell E5.