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

Quiz =REPLACE — 15 Questions

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

Question 1 of 15 1/15

Which is the correct syntax of =REPLACE?

Question 2 of 15 2/15

How many required arguments does =REPLACE have?

Question 3 of 15 3/15

Is argument “num_chars” required in =REPLACE?

Question 4 of 15 4/15

Which statement about =REPLACE is correct?

Question 5 of 15 5/15

Which function is NOT related to =REPLACE?

Question 6 of 15 6/15

Is =REPLACE volatile?

Question 7 of 15 7/15

Is argument “start_num” required in =REPLACE?

Question 8 of 15 8/15

Is argument “old_text” required in =REPLACE?

Question 9 of 15 9/15

Is argument “new_text” required in =REPLACE?

Question 10 of 15 10/15

In =REPLACE, which is argument #1?

Question 11 of 15 11/15

Which use case fits =REPLACE?

Question 12 of 15 12/15

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

Question 13 of 15 13/15

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

Question 14 of 15 14/15

How many arguments does =REPLACE have in total?

Question 15 of 15 15/15

Which function is related to =REPLACE?

Click a question to see the answer.

1. Which is the correct syntax of =REPLACE?

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

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

2. How many required arguments does =REPLACE have?

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

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

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

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

Explanation: “num_chars” is required.

4. Which statement about =REPLACE is correct?

A. 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. ✓
B. Only works in old versions
C. Volatile and recalculates every time
D. Select entire column for best performance

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.

5. Which function is NOT related to =REPLACE?

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

Explanation: “TDIST” is not related to REPLACE.

6. Is =REPLACE volatile?

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

Explanation: REPLACE is not volatile.

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

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

Explanation: “start_num” is required.

8. Is argument “old_text” required in =REPLACE?

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

Explanation: “old_text” is required.

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

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

Explanation: “new_text” is required.

10. In =REPLACE, which is argument #1?

A. old_text ✓
B. lookup_value
C. num_chars
D. new_text

Explanation: Argument #1 is “old_text”.

11. Which use case fits =REPLACE?

A. Data Cleaning ✓
B. Error Handling
C. Conditional Logic
D. Lookup & Retrieval

Explanation: Use case “Data Cleaning” fits REPLACE.

12. What is the type of argument “start_num” in =REPLACE?

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

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

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

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

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

14. How many arguments does =REPLACE have in total?

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

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

15. Which function is related to =REPLACE?

A. SEARCH ✓
B. GAMMADIST
C. NOT
D. Z.TEST

Explanation: “SEARCH” is related to REPLACE.