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

Is argument “start_num” required in =REPLACE?

Question 2 of 10 2/10

How many required arguments does =REPLACE have?

Question 3 of 10 3/10

Does =REPLACE return a dynamic array?

Question 4 of 10 4/10

In =REPLACE, which is argument #2?

Question 5 of 10 5/10

In =REPLACE, which is argument #3?

Question 6 of 10 6/10

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

Question 7 of 10 7/10

Which function is NOT related to =REPLACE?

Question 8 of 10 8/10

Is argument “new_text” required in =REPLACE?

Question 9 of 10 9/10

Is argument “old_text” required in =REPLACE?

Question 10 of 10 10/10

In =REPLACE, which is argument #1?

Click a question to see the answer.

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

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

Explanation: “start_num” is required.

2. How many required arguments does =REPLACE have?

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

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

3. Does =REPLACE return a dynamic array?

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

Explanation: REPLACE does not spill.

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

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

Explanation: Argument #2 is “start_num”.

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

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

Explanation: Argument #3 is “num_chars”.

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

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

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

7. Which function is NOT related to =REPLACE?

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

Explanation: “IMTAN” is not related to REPLACE.

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

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

Explanation: “new_text” is required.

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

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

Explanation: “old_text” is required.

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

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

Explanation: Argument #1 is “old_text”.