Text =REPLACEB(old_text, start_num, num_bytes, new_text)

Quiz =REPLACEB — 10 Questions

10 quiz questions about =REPLACEB — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← REPLACEB ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which statement about =REPLACEB is correct?

Question 2 of 10 2/10

Which formula is a valid example of =REPLACEB?

Question 3 of 10 3/10

Is argument “start_num” required in =REPLACEB?

Question 4 of 10 4/10

How many arguments does =REPLACEB have in total?

Question 5 of 10 5/10

Is =REPLACEB volatile?

Question 6 of 10 6/10

How many required arguments does =REPLACEB have?

Question 7 of 10 7/10

Is argument “num_bytes” required in =REPLACEB?

Question 8 of 10 8/10

Which function is NOT related to =REPLACEB?

Question 9 of 10 9/10

In =REPLACEB, which is argument #2?

Question 10 of 10 10/10

Is argument “new_text” required in =REPLACEB?

Click a question to see the answer.

1. Which statement about =REPLACEB is correct?

A. تابع REPLACEB هر نویسه دوبایتی را دو بایت حساب می‌کند؛ برای زبان‌های تک‌بایتی تفاوتی با REPLACE ندارد. ✓
B. Requires add-in
C. Only works in old versions
D. Volatile and recalculates every time

Explanation: Correct: تابع REPLACEB هر نویسه دوبایتی را دو بایت حساب می‌کند؛ برای زبان‌های تک‌بایتی تفاوتی با REPLACE ندارد.

2. Which formula is a valid example of =REPLACEB?

A. =REPLACEB("Excel",2,2,"PR") ✓
B. =FIND("Excel",2,2,"PR")
C. REPLACEB("Excel",2,2,"PR")
D. =REPLACEB("Excel",2,2,"PR", 0)

Explanation: Correct example: =REPLACEB("Excel",2,2,"PR")

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

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

Explanation: “start_num” is required.

4. How many arguments does =REPLACEB have in total?

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

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

5. Is =REPLACEB volatile?

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

Explanation: REPLACEB is not volatile.

6. How many required arguments does =REPLACEB have?

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

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

7. Is argument “num_bytes” required in =REPLACEB?

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

Explanation: “num_bytes” is required.

8. Which function is NOT related to =REPLACEB?

A. FIND
B. ODDFPRICE ✓
C. LEFT
D. MID

Explanation: “ODDFPRICE” is not related to REPLACEB.

9. In =REPLACEB, which is argument #2?

A. value
B. lookup_value
C. start_num ✓
D. criteria

Explanation: Argument #2 is “start_num”.

10. Is argument “new_text” required in =REPLACEB?

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

Explanation: “new_text” is required.