Math & Trig =ARABIC( text )

Quiz =ARABIC — 10 Questions

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

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

← ARABIC ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Is argument “text” required in =ARABIC?

Question 2 of 10 2/10

Which category does =ARABIC belong to?

Question 3 of 10 3/10

Does =ARABIC return a dynamic array?

Question 4 of 10 4/10

What is the fix for #VALUE! in =ARABIC?

Question 5 of 10 5/10

Since which Excel version is =ARABIC available?

Question 6 of 10 6/10

Which function is related to =ARABIC?

Question 7 of 10 7/10

What is the type of argument “text” in =ARABIC?

Question 8 of 10 8/10

What is the output type of =ARABIC?

Question 9 of 10 9/10

Which statement about =ARABIC is correct?

Question 10 of 10 10/10

How many arguments does =ARABIC have in total?

Click a question to see the answer.

1. Is argument “text” required in =ARABIC?

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

Explanation: “text” is required.

2. Which category does =ARABIC belong to?

A. Financial
B. Math & Trig ✓
C. Engineering
D. Statistical

Explanation: Category is “Math & Trig”.

3. Does =ARABIC return a dynamic array?

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

Explanation: ARABIC does not spill.

4. What is the fix for #VALUE! in =ARABIC?

A. Text is always ignored
B. Check the spelling of the Roman numeral ✓
C. Only works in old versions
D. Requires add-in

Explanation: If Text is not a valid value, ARABIC returns the #VALUE! error value. Values that return a #VALUE! error value include numbers, dates, and text that is not a valid Roman numeral. — Fix: Check the spelling of the Roman numeral

5. Since which Excel version is =ARABIC available?

A. Excel 2013 ✓
B. Excel 365
C. All versions
D. Excel 2019

Explanation: Version: “Excel 2013”.

6. Which function is related to =ARABIC?

A. ROMAN ✓
B. NORMDIST
C. CHAR
D. CHOOSEROWS

Explanation: “ROMAN” is related to ARABIC.

7. What is the type of argument “text” in =ARABIC?

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

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

8. What is the output type of =ARABIC?

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

Explanation: Output is “Number”.

9. Which statement about =ARABIC is correct?

A. Text is always ignored
B. The maximum length of the argument is 255 characters. Therefore, the largest number that can be returned is 255,000.
C. Select entire column for best performance
D. If an empty string ("") is used as an input value, 0 is returned. ✓

Explanation: Correct: If an empty string ("") is used as an input value, 0 is returned.

10. How many arguments does =ARABIC have in total?

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

Explanation: =ARABIC has 1 required, 0 optional (1 total).