Text =TEXTAFTER(text,delimiter,[instance_num], [match_mode], [match_end], [if_not_found])

Quiz =TEXTAFTER — 10 Questions

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

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

← TEXTAFTER ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What usually causes #VALUE! in =TEXTAFTER?

Question 2 of 10 2/10

What is the type of argument “match_end” in =TEXTAFTER?

Question 3 of 10 3/10

How many arguments does =TEXTAFTER have in total?

Question 4 of 10 4/10

Which function is related to =TEXTAFTER?

Question 5 of 10 5/10

Is argument “if_not_found” required in =TEXTAFTER?

Question 6 of 10 6/10

Which statement about =TEXTAFTER is correct?

Question 7 of 10 7/10

Does =TEXTAFTER return a dynamic array?

Question 8 of 10 8/10

Is argument “delimiter” required in =TEXTAFTER?

Question 9 of 10 9/10

In =TEXTAFTER, which is argument #3?

Question 10 of 10 10/10

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

Click a question to see the answer.

1. What usually causes #VALUE! in =TEXTAFTER?

A. Volatile and recalculates every time
B. Excel returns a #VALUE! error if instance_num = 0 or if instance_num is greater than the length of text. ✓
C. به طور پیش‌فرض #N/A برگردانده می‌شود. اگر delimiter در text وجود نداشته باشد یا instance_num بیشتر از تعداد رخدادهای delimiter باشد، اکسل خطای #N/A را برمی‌گرداند.
D. Text is always ignored

Explanation: Excel returns a #VALUE! error if instance_num = 0 or if instance_num is greater than the length of text. — Fix: برای instance_num مقدار غیرصفر و در بازه مجاز وارد کنید.

2. What is the type of argument “match_end” in =TEXTAFTER?

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

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

3. How many arguments does =TEXTAFTER have in total?

A. 6 ✓
B. 5
C. 7
D. 8

Explanation: =TEXTAFTER has 2 required, 4 optional (6 total).

4. Which function is related to =TEXTAFTER?

A. MID ✓
B. LAMBDA
C. TDIST
D. RAND

Explanation: “MID” is related to TEXTAFTER.

5. Is argument “if_not_found” required in =TEXTAFTER?

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

Explanation: “if_not_found” is optional.

6. Which statement about =TEXTAFTER is correct?

A. When searching with an empty delimiter value, TEXTAFTER matches immediately. It returns the entire text when searching from the front (if instance_num is positive) and empty text when searching from the end (if instance_num is negative). ✓
B. Volatile and recalculates every time
C. Output is always a dynamic array
D. Select entire column for best performance

Explanation: Correct: When searching with an empty delimiter value, TEXTAFTER matches immediately. It returns the entire text when searching from the front (if instance_num is positive) and empty text when searching from the end (if instance_num is negative).

7. Does =TEXTAFTER return a dynamic array?

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

Explanation: TEXTAFTER does not spill.

8. Is argument “delimiter” required in =TEXTAFTER?

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

Explanation: “delimiter” is required.

9. In =TEXTAFTER, which is argument #3?

A. lookup_value
B. text
C. instance_num ✓
D. delimiter

Explanation: Argument #3 is “instance_num”.

10. What is the fix for #VALUE! in =TEXTAFTER?

A. به طور پیش‌فرض #N/A برگردانده می‌شود. اگر delimiter در text وجود نداشته باشد یا instance_num بیشتر از تعداد رخدادهای delimiter باشد، اکسل خطای #N/A را برمی‌گرداند.
B. Volatile and recalculates every time
C. Only works in old versions
D. برای instance_num مقدار غیرصفر و در بازه مجاز وارد کنید. ✓