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

Which formula is a valid example of =REPLACE?

Question 2 of 10 2/10

Since which Excel version is =REPLACE available?

Question 3 of 10 3/10

Which use case fits =REPLACE?

Question 4 of 10 4/10

How many optional arguments does =REPLACE have?

Question 5 of 10 5/10

What is the type of argument “new_text” in =REPLACE?

Question 6 of 10 6/10

Does =REPLACE return a dynamic array?

Question 7 of 10 7/10

Which statement about =REPLACE is correct?

Question 8 of 10 8/10

Which is the correct syntax of =REPLACE?

Question 9 of 10 9/10

Which function is NOT related to =REPLACE?

Question 10 of 10 10/10

What is the type of argument “num_chars” in =REPLACE?

Click a question to see the answer.

1. Which formula is a valid example of =REPLACE?

A. =SEARCH(A2,6,5,"*")
B. =REPLACE(A2,6,5,"*", 0)
C. REPLACE(A2,6,5,"*")
D. =REPLACE(A2,6,5,"*") ✓

Explanation: Correct example: =REPLACE(A2,6,5,"*")

2. Since which Excel version is =REPLACE available?

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

Explanation: Version: “All versions”.

3. Which use case fits =REPLACE?

A. Numbering & Sample Data
B. Daily Tasks
C. Depreciation
D. Data Cleaning ✓

Explanation: Use case “Data Cleaning” fits REPLACE.

4. How many optional arguments does =REPLACE have?

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

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

5. What is the type of argument “new_text” in =REPLACE?

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

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

6. Does =REPLACE return a dynamic array?

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

Explanation: REPLACE does not spill.

7. Which statement about =REPLACE is correct?

A. Volatile and recalculates every time
B. Requires add-in
C. 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. ✓
D. Output is always a dynamic array

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.

8. Which is the correct syntax of =REPLACE?

A. =REPLACE(old_text, start_num, num_chars, new_text, 0)
B. =REPLACE(old_text, start_num, num_chars, new_text) ✓
C. REPLACE(old_text, start_num, num_chars, new_text)
D. =SEARCH(old_text, start_num, num_chars, new_text)

Explanation: Correct syntax: =REPLACE(old_text, start_num, num_chars, new_text)

9. Which function is NOT related to =REPLACE?

A. SEARCH
B. CEILING ✓
C. VALUE
D. SUBSTITUTE

Explanation: “CEILING” is not related to REPLACE.

10. What is the type of argument “num_chars” in =REPLACE?

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

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