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

Is argument “num_bytes” required in =REPLACEB?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

Which statement about =REPLACEB is correct?

Question 4 of 10 4/10

Is argument “start_num” required in =REPLACEB?

Question 5 of 10 5/10

In =REPLACEB, which is argument #3?

Question 6 of 10 6/10

Which function is NOT related to =REPLACEB?

Question 7 of 10 7/10

Which is the correct syntax of =REPLACEB?

Question 8 of 10 8/10

In =REPLACEB, which is argument #2?

Question 9 of 10 9/10

Which function is related to =REPLACEB?

Question 10 of 10 10/10

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

Click a question to see the answer.

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

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

Explanation: “num_bytes” is required.

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

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

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

3. Which statement about =REPLACEB is correct?

A. تابع REPLACEB هر نویسه دوبایتی را دو بایت حساب می‌کند؛ برای زبان‌های تک‌بایتی تفاوتی با REPLACE ندارد. ✓
B. Output is always a dynamic array
C. Requires add-in
D. Select entire column for best performance

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

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

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

Explanation: “start_num” is required.

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

A. old_text
B. new_text
C. value
D. num_bytes ✓

Explanation: Argument #3 is “num_bytes”.

6. Which function is NOT related to =REPLACEB?

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

Explanation: “DAYS” is not related to REPLACEB.

7. Which is the correct syntax of =REPLACEB?

A. =FIND(old_text, start_num, num_bytes, new_text)
B. REPLACEB(old_text, start_num, num_bytes, new_text)
C. =REPLACEB(old_text, start_num, num_bytes, new_text, 0)
D. =REPLACEB(old_text, start_num, num_bytes, new_text) ✓

Explanation: Correct syntax: =REPLACEB(old_text, start_num, num_bytes, new_text)

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

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

Explanation: Argument #2 is “start_num”.

9. Which function is related to =REPLACEB?

A. ISERROR
B. ACOTH
C. CRITBINOM
D. FIND ✓

Explanation: “FIND” is related to REPLACEB.

10. What is the type of argument “start_num” in =REPLACEB?

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

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