Text =FIND(find_text, within_text, [start_num])

Quiz =FIND — 10 Questions

10 quiz questions about =FIND — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← FIND ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Is argument “start_num” required in =FIND?

Question 2 of 10 2/10

How many required arguments does =FIND have?

Question 3 of 10 3/10

What usually causes #VALUE! in =FIND?

Question 4 of 10 4/10

Which function is related to =FIND?

Question 5 of 10 5/10

Which statement about =FIND is correct?

Question 6 of 10 6/10

What is the output type of =FIND?

Question 7 of 10 7/10

What is the fix for #VALUE! in =FIND?

Question 8 of 10 8/10

Is =FIND volatile?

Question 9 of 10 9/10

Which formula is a valid example of =FIND?

Question 10 of 10 10/10

In =FIND, which is argument #3?

Click a question to see the answer.

1. Is argument “start_num” required in =FIND?

A. —
B. Yes
C. No
D. No ✓

Explanation: “start_num” is optional.

2. How many required arguments does =FIND have?

A. 2 ✓
B. 4
C. 1
D. 3

Explanation: =FIND has 2 required, 1 optional (3 total).

3. What usually causes #VALUE! in =FIND?

A. Only works in old versions
B. Text is always ignored
C. The text was not found, or the start number is less than 1 or greater than the length of the text ✓
D. Output is always a dynamic array

Explanation: The text was not found, or the start number is less than 1 or greater than the length of the text — Fix: Check the text and case, or handle the error with IFERROR

4. Which function is related to =FIND?

A. ISNUMBER ✓
B. DVARP
C. T.INV.2T
D. SQRTPI

Explanation: “ISNUMBER” is related to FIND.

5. Which statement about =FIND is correct?

A. Only works in old versions
B. Returns only the position of the first match; for later occurrences use the third argument.
C. Text is always ignored
D. If the text is not found, the #VALUE! error is returned. ✓

Explanation: Correct: If the text is not found, the #VALUE! error is returned.

6. What is the output type of =FIND?

A. Date
B. Mixed
C. Number ✓
D. Array

Explanation: Output is “Number”.

7. What is the fix for #VALUE! in =FIND?

A. Check the text and case, or handle the error with IFERROR ✓
B. Only works in old versions
C. Volatile and recalculates every time
D. Requires add-in

Explanation: The text was not found, or the start number is less than 1 or greater than the length of the text — Fix: Check the text and case, or handle the error with IFERROR

8. Is =FIND volatile?

A. No
B. No ✓
C. —
D. Yes

Explanation: FIND is not volatile.

9. Which formula is a valid example of =FIND?

A. FIND("-", A2)
B. =FIND("-", A2) ✓
C. =ISNUMBER("-", A2)
D. =FIND("-", A2, 0)

Explanation: Correct example: =FIND("-", A2)

10. In =FIND, which is argument #3?

A. lookup_value
B. start_num ✓
C. within_text
D. value

Explanation: Argument #3 is “start_num”.