Math & Trig =DECIMAL(text, radix)

Quiz =DECIMAL — 10 Questions

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

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

← DECIMAL ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Does =DECIMAL return a dynamic array?

Question 2 of 10 2/10

Is argument “text” required in =DECIMAL?

Question 3 of 10 3/10

Is argument “radix” required in =DECIMAL?

Question 4 of 10 4/10

What usually causes #VALUE! in =DECIMAL?

Question 5 of 10 5/10

In =DECIMAL, which is argument #2?

Question 6 of 10 6/10

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

Question 7 of 10 7/10

Which function is related to =DECIMAL?

Question 8 of 10 8/10

What is the output type of =DECIMAL?

Question 9 of 10 9/10

Which use case fits =DECIMAL?

Question 10 of 10 10/10

What usually causes #NUM! in =DECIMAL?

Click a question to see the answer.

1. Does =DECIMAL return a dynamic array?

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

Explanation: DECIMAL does not spill.

2. Is argument “text” required in =DECIMAL?

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

Explanation: “text” is required.

3. Is argument “radix” required in =DECIMAL?

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

Explanation: “radix” is required.

4. What usually causes #VALUE! in =DECIMAL?

A. Text is always ignored
B. آرگومان‌ها خارج از محدوده مجاز هستند؛ مثلاً طول Text بیش از ۲۵۵ نویسه است یا Radix خارج از ۲ تا ۳۶ است.
C. Select entire column for best performance
D. If either argument is outside its constraints, DECIMAL may return the #NUM! or #VALUE! error value. ✓

Explanation: If either argument is outside its constraints, DECIMAL may return the #NUM! or #VALUE! error value. — Fix: بررسی کنید Text فقط شامل نویسه‌های مجاز مبنا باشد و Radix مقدار عددی معتبر باشد.

5. In =DECIMAL, which is argument #2?

A. text
B. value
C. lookup_value
D. radix ✓

Explanation: Argument #2 is “radix”.

6. What is the type of argument “text” in =DECIMAL?

A. Array
B. Text ✓
C. Date
D. Logical

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

7. Which function is related to =DECIMAL?

A. BASE ✓
B. ROUND
C. MONTH
D. NUMBERVALUE

Explanation: “BASE” is related to DECIMAL.

8. What is the output type of =DECIMAL?

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

Explanation: Output is “Number”.

9. Which use case fits =DECIMAL?

A. Scientific & Unit Conversion ✓
B. Investment Appraisal
C. Lookup & Retrieval
D. Reporting

Explanation: Use case “Scientific & Unit Conversion” fits DECIMAL.

10. What usually causes #NUM! in =DECIMAL?

A. Output is always a dynamic array
B. Volatile and recalculates every time
C. Text is always ignored
D. If either argument is outside its constraints, DECIMAL may return the #NUM! or #VALUE! error value. ✓

Explanation: If either argument is outside its constraints, DECIMAL may return the #NUM! or #VALUE! error value. — Fix: Check the base and the text characters