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

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

Question 3 of 15 3/15

Which function is NOT related to =REPLACE?

Question 4 of 15 4/15

Which formula is a valid example of =REPLACE?

Question 5 of 15 5/15

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

Question 6 of 15 6/15

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

Question 7 of 15 7/15

Which function is related to =REPLACE?

Question 8 of 15 8/15

Which statement about =REPLACE is correct?

Question 9 of 15 9/15

Which category does =REPLACE belong to?

Question 10 of 15 10/15

Is =REPLACE volatile?

Question 11 of 15 11/15

Does =REPLACE return a dynamic array?

Question 12 of 15 12/15

In =REPLACE, which is argument #3?

Question 13 of 15 13/15

What is the output type of =REPLACE?

Question 14 of 15 14/15

In =REPLACE, which is argument #1?

Question 15 of 15 15/15

How many arguments does =REPLACE have in total?

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, 0)
C. REPLACE(old_text, start_num, num_chars, new_text)
D. =REPLACE(old_text, start_num, num_chars, new_text) ✓

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

2. What is the type of argument “old_text” in =REPLACE?

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

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

3. Which function is NOT related to =REPLACE?

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

Explanation: “TBILLEQ” is not related to REPLACE.

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

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

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

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

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

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

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

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

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

7. Which function is related to =REPLACE?

A. SEARCH ✓
B. COLUMNS
C. T.DIST.RT
D. EVEN

Explanation: “SEARCH” is related to REPLACE.

8. Which statement about =REPLACE is correct?

A. Text is always ignored
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. 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.

9. Which category does =REPLACE belong to?

A. Database
B. Compatibility
C. Cube
D. Text ✓

Explanation: Category is “Text”.

10. Is =REPLACE volatile?

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

Explanation: REPLACE is not volatile.

11. Does =REPLACE return a dynamic array?

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

Explanation: REPLACE does not spill.

12. In =REPLACE, which is argument #3?

A. range
B. old_text
C. num_chars ✓
D. start_num

Explanation: Argument #3 is “num_chars”.

13. What is the output type of =REPLACE?

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

Explanation: Output is “Text”.

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

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

Explanation: Argument #1 is “old_text”.

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

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

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