Text =REGEXEXTRACT(text, pattern, [return_mode], [case_sensitivity])

Quiz =REGEXEXTRACT — 10 Questions

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

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

← REGEXEXTRACT ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What is the type of argument “return_mode” in =REGEXEXTRACT?

Question 2 of 10 2/10

Since which Excel version is =REGEXEXTRACT available?

Question 3 of 10 3/10

Is =REGEXEXTRACT volatile?

Question 4 of 10 4/10

In =REGEXEXTRACT, which is argument #3?

Question 5 of 10 5/10

What is the output type of =REGEXEXTRACT?

Question 6 of 10 6/10

Is argument “return_mode” required in =REGEXEXTRACT?

Question 7 of 10 7/10

In =REGEXEXTRACT, which is argument #1?

Question 8 of 10 8/10

Which formula is a valid example of =REGEXEXTRACT?

Question 9 of 10 9/10

Is argument “pattern” required in =REGEXEXTRACT?

Question 10 of 10 10/10

What is the type of argument “case_sensitivity” in =REGEXEXTRACT?

Click a question to see the answer.

1. What is the type of argument “return_mode” in =REGEXEXTRACT?

A. Text
B. Value
C. Date
D. Number ✓

Explanation: Type of “return_mode” is “Number”.

2. Since which Excel version is =REGEXEXTRACT available?

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

Explanation: Version: “Excel 365”.

3. Is =REGEXEXTRACT volatile?

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

Explanation: REGEXEXTRACT is not volatile.

4. In =REGEXEXTRACT, which is argument #3?

A. return_mode ✓
B. range
C. criteria
D. lookup_value

Explanation: Argument #3 is “return_mode”.

5. What is the output type of =REGEXEXTRACT?

A. Date
B. Reference
C. Value
D. Text ✓

Explanation: Output is “Text”.

6. Is argument “return_mode” required in =REGEXEXTRACT?

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

Explanation: “return_mode” is required.

7. In =REGEXEXTRACT, which is argument #1?

A. text ✓
B. return_mode
C. pattern
D. case_sensitivity

Explanation: Argument #1 is “text”.

8. Which formula is a valid example of =REGEXEXTRACT?

A. =IFNA(A2,"[A-Z][a-z]+")
B. =REGEXEXTRACT(A2,"[A-Z][a-z]+") ✓
C. =REGEXEXTRACT(A2,"[A-Z][a-z]+", 0)
D. REGEXEXTRACT(A2,"[A-Z][a-z]+")

Explanation: Correct example: =REGEXEXTRACT(A2,"[A-Z][a-z]+")

9. Is argument “pattern” required in =REGEXEXTRACT?

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

Explanation: “pattern” is required.

10. What is the type of argument “case_sensitivity” in =REGEXEXTRACT?

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

Explanation: Type of “case_sensitivity” is “Number”.