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

In =REPLACE, which is argument #3?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

Is argument “start_num” required in =REPLACE?

Question 4 of 10 4/10

Is argument “new_text” required in =REPLACE?

Question 5 of 10 5/10

Which function is related to =REPLACE?

Question 6 of 10 6/10

How many optional arguments does =REPLACE have?

Question 7 of 10 7/10

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

Question 8 of 10 8/10

Is =REPLACE volatile?

Question 9 of 10 9/10

Is argument “old_text” required in =REPLACE?

Question 10 of 10 10/10

How many required arguments does =REPLACE have?

Click a question to see the answer.

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

A. num_chars ✓
B. new_text
C. start_num
D. value

Explanation: Argument #3 is “num_chars”.

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

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

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

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

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

Explanation: “start_num” is required.

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

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

Explanation: “new_text” is required.

5. Which function is related to =REPLACE?

A. REDUCE
B. SEARCH ✓
C. HEX2OCT
D. MMULT

Explanation: “SEARCH” is related to REPLACE.

6. How many optional arguments does =REPLACE have?

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

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

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

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

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

8. Is =REPLACE volatile?

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

Explanation: REPLACE is not volatile.

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

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

Explanation: “old_text” is required.

10. How many required arguments does =REPLACE have?

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

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