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

Quiz =REGEXEXTRACT — 15 Questions

15 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 — 15 questions 1 of 15

Question 1 of 15 1/15

Which is the correct syntax of =REGEXEXTRACT?

Question 2 of 15 2/15

Which category does =REGEXEXTRACT belong to?

Question 3 of 15 3/15

Since which Excel version is =REGEXEXTRACT available?

Question 4 of 15 4/15

Which formula is a valid example of =REGEXEXTRACT?

Question 5 of 15 5/15

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

Question 6 of 15 6/15

Is argument “case_sensitivity” required in =REGEXEXTRACT?

Question 7 of 15 7/15

Which use case fits =REGEXEXTRACT?

Question 8 of 15 8/15

In =REGEXEXTRACT, which is argument #3?

Question 9 of 15 9/15

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

Question 10 of 15 10/15

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

Question 11 of 15 11/15

In =REGEXEXTRACT, which is argument #2?

Question 12 of 15 12/15

Does =REGEXEXTRACT return a dynamic array?

Question 13 of 15 13/15

Is =REGEXEXTRACT volatile?

Question 14 of 15 14/15

Which function is NOT related to =REGEXEXTRACT?

Question 15 of 15 15/15

How many optional arguments does =REGEXEXTRACT have?

Click a question to see the answer.

1. Which is the correct syntax of =REGEXEXTRACT?

A. =IFNA(text, pattern, [return_mode], [case_sensitivity])
B. REGEXEXTRACT(text, pattern, [return_mode], [case_sensitivity])
C. =REGEXEXTRACT(text, pattern, [return_mode], [case_sensitivity]) ✓
D. =REGEXEXTRACT(text, pattern, [return_mode], [case_sensitivity], 0)

Explanation: Correct syntax: =REGEXEXTRACT(text, pattern, [return_mode], [case_sensitivity])

2. Which category does =REGEXEXTRACT belong to?

A. Text ✓
B. Engineering
C. Cube
D. Math & Trig

Explanation: Category is “Text”.

3. Since which Excel version is =REGEXEXTRACT available?

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

Explanation: Version: “Excel 365”.

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

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

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

5. What is the type of argument “text” in =REGEXEXTRACT?

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

Explanation: Type of “text” is “Text”.

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

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

Explanation: “case_sensitivity” is required.

7. Which use case fits =REGEXEXTRACT?

A. Data Cleaning ✓
B. Forecasting & Trends
C. Advanced Formulas
D. Conditional Formatting & Validation

Explanation: Use case “Data Cleaning” fits REGEXEXTRACT.

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

A. lookup_value
B. value
C. return_mode ✓
D. pattern

Explanation: Argument #3 is “return_mode”.

9. What is the type of argument “pattern” in =REGEXEXTRACT?

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

Explanation: Type of “pattern” is “Text”.

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

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

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

11. In =REGEXEXTRACT, which is argument #2?

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

Explanation: Argument #2 is “pattern”.

12. Does =REGEXEXTRACT return a dynamic array?

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

Explanation: REGEXEXTRACT does not spill.

13. Is =REGEXEXTRACT volatile?

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

Explanation: REGEXEXTRACT is not volatile.

14. Which function is NOT related to =REGEXEXTRACT?

A. IFNA
B. MID
C. ISREF ✓
D. REGEXREPLACE

Explanation: “ISREF” is not related to REGEXEXTRACT.

15. How many optional arguments does =REGEXEXTRACT have?

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

Explanation: =REGEXEXTRACT has 4 required, 0 optional (4 total).