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

Is argument “pattern” required in =REGEXEXTRACT?

Question 2 of 10 2/10

Which function is NOT related to =REGEXEXTRACT?

Question 3 of 10 3/10

How many required arguments does =REGEXEXTRACT have?

Question 4 of 10 4/10

In =REGEXEXTRACT, which is argument #3?

Question 5 of 10 5/10

How many optional arguments does =REGEXEXTRACT have?

Question 6 of 10 6/10

Is argument “case_sensitivity” required in =REGEXEXTRACT?

Question 7 of 10 7/10

Is =REGEXEXTRACT volatile?

Question 8 of 10 8/10

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

Question 9 of 10 9/10

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

Question 10 of 10 10/10

Does =REGEXEXTRACT return a dynamic array?

Click a question to see the answer.

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

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

Explanation: “pattern” is required.

2. Which function is NOT related to =REGEXEXTRACT?

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

Explanation: “SUMX2MY2” is not related to REGEXEXTRACT.

3. How many required arguments does =REGEXEXTRACT have?

A. 6
B. 3
C. 4 ✓
D. 5

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

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

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

Explanation: Argument #3 is “return_mode”.

5. How many optional arguments does =REGEXEXTRACT have?

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

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

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

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

Explanation: “case_sensitivity” is required.

7. Is =REGEXEXTRACT volatile?

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

Explanation: REGEXEXTRACT is not volatile.

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

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

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

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

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

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

10. Does =REGEXEXTRACT return a dynamic array?

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

Explanation: REGEXEXTRACT does not spill.