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

Quiz =SEARCH — 15 Questions

15 quiz questions about =SEARCH — test syntax, arguments, examples & errors!

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

← SEARCH ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

In =SEARCH, which is argument #2?

Question 2 of 15 2/15

What is the output type of =SEARCH?

Question 3 of 15 3/15

Which is the correct syntax of =SEARCH?

Question 4 of 15 4/15

Which statement about =SEARCH is correct?

Question 5 of 15 5/15

Since which Excel version is =SEARCH available?

Question 6 of 15 6/15

Which function is NOT related to =SEARCH?

Question 7 of 15 7/15

Is argument “find_text” required in =SEARCH?

Question 8 of 15 8/15

Which function is related to =SEARCH?

Question 9 of 15 9/15

Which category does =SEARCH belong to?

Question 10 of 15 10/15

What is the type of argument “start_num” in =SEARCH?

Question 11 of 15 11/15

Is argument “within_text” required in =SEARCH?

Question 12 of 15 12/15

What is the type of argument “find_text” in =SEARCH?

Question 13 of 15 13/15

How many required arguments does =SEARCH have?

Question 14 of 15 14/15

Which use case fits =SEARCH?

Question 15 of 15 15/15

What is the type of argument “within_text” in =SEARCH?

Click a question to see the answer.

1. In =SEARCH, which is argument #2?

A. find_text
B. within_text ✓
C. value
D. range

Explanation: Argument #2 is “within_text”.

2. What is the output type of =SEARCH?

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

Explanation: Output is “Number”.

3. Which is the correct syntax of =SEARCH?

A. =SEARCH(find_text,within_text,[start_num]) ✓
B. =ISNUMBER(find_text,within_text,[start_num])
C. =SEARCH(find_text,within_text,[start_num], 0)
D. SEARCH(find_text,within_text,[start_num])

Explanation: Correct syntax: =SEARCH(find_text,within_text,[start_num])

4. Which statement about =SEARCH is correct?

A. The SEARCHB function is deprecated. In workbooks set to Compatibility Version 2, SEARCH has improved behavior with Surrogate Pairs, counting them as one character instead of two. Variation Selectors (commonly used with emojis) will still be counted as separate characters. Read more here: The Unicode standard ✓
B. Requires add-in
C. Text is always ignored
D. Output is always a dynamic array

Explanation: Correct: The SEARCHB function is deprecated. In workbooks set to Compatibility Version 2, SEARCH has improved behavior with Surrogate Pairs, counting them as one character instead of two. Variation Selectors (commonly used with emojis) will still be counted as separate characters. Read more here: The Unicode standard

5. Since which Excel version is =SEARCH available?

A. Excel 2007 (Compatibility)
B. All versions ✓
C. Excel 365
D. Excel 2019

Explanation: Version: “All versions”.

6. Which function is NOT related to =SEARCH?

A. ISNUMBER
B. DEGREES ✓
C. MID
D. LEFT

Explanation: “DEGREES” is not related to SEARCH.

7. Is argument “find_text” required in =SEARCH?

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

Explanation: “find_text” is required.

8. Which function is related to =SEARCH?

A. ISNUMBER ✓
B. MATCH
C. IMCOSH
D. NORMSINV

Explanation: “ISNUMBER” is related to SEARCH.

9. Which category does =SEARCH belong to?

A. Cube
B. Date & Time
C. Text ✓
D. Engineering

Explanation: Category is “Text”.

10. What is the type of argument “start_num” in =SEARCH?

A. Reference
B. Date
C. Any type ✓
D. Text

Explanation: Type of “start_num” is “Any type”.

11. Is argument “within_text” required in =SEARCH?

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

Explanation: “within_text” is required.

12. What is the type of argument “find_text” in =SEARCH?

A. Date
B. Number
C. Reference
D. Any type ✓

Explanation: Type of “find_text” is “Any type”.

13. How many required arguments does =SEARCH have?

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

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

14. Which use case fits =SEARCH?

A. Reporting
B. Descriptive Statistics
C. Text Manipulation ✓
D. Sort, Filter & Dedupe

Explanation: Use case “Text Manipulation” fits SEARCH.

15. What is the type of argument “within_text” in =SEARCH?

A. Any type ✓
B. Value
C. Date
D. Mixed

Explanation: Type of “within_text” is “Any type”.