Text =REPLACE(old_text, start_num, num_chars, new_text)

Quiz =REPLACE — 10 Questions

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

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

← REPLACE ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What is the output type of =REPLACE?

Question 2 of 10 2/10

In =REPLACE, which is argument #2?

Question 3 of 10 3/10

How many required arguments does =REPLACE have?

Question 4 of 10 4/10

Is argument “new_text” required in =REPLACE?

Question 5 of 10 5/10

Is argument “num_chars” required in =REPLACE?

Question 6 of 10 6/10

Which statement about =REPLACE is correct?

Question 7 of 10 7/10

Is argument “start_num” required in =REPLACE?

Question 8 of 10 8/10

Which category does =REPLACE belong to?

Question 9 of 10 9/10

How many optional arguments does =REPLACE have?

Question 10 of 10 10/10

Which use case fits =REPLACE?

Click a question to see the answer.

1. What is the output type of =REPLACE?

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

Explanation: Output is “Text”.

2. In =REPLACE, which is argument #2?

A. value
B. range
C. criteria
D. start_num ✓

Explanation: Argument #2 is “start_num”.

3. How many required arguments does =REPLACE have?

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

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

4. Is argument “new_text” required in =REPLACE?

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

Explanation: “new_text” is required.

5. Is argument “num_chars” required in =REPLACE?

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

Explanation: “num_chars” is required.

6. Which statement about =REPLACE is correct?

A. Requires add-in
B. The REPLACEB function is deprecated. In workbooks set to Compatibility Version 2, REPLACE 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. For more information, see The Unicode standard. ✓
C. Select entire column for best performance
D. Text is always ignored

Explanation: Correct: The REPLACEB function is deprecated. In workbooks set to Compatibility Version 2, REPLACE 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. For more information, see The Unicode standard.

7. Is argument “start_num” required in =REPLACE?

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

Explanation: “start_num” is required.

8. Which category does =REPLACE belong to?

A. Lookup & Reference
B. Cube
C. Text ✓
D. Date & Time

Explanation: Category is “Text”.

9. How many optional arguments does =REPLACE have?

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

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

10. Which use case fits =REPLACE?

A. Data Cleaning ✓
B. Financial Calculations
C. Date & Time Calculations
D. Numbering & Sample Data

Explanation: Use case “Data Cleaning” fits REPLACE.