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

How many optional arguments does =DECIMAL have?

Question 2 of 10 2/10

What usually causes #NUM! in =DECIMAL?

Question 3 of 10 3/10

Which category does =DECIMAL belong to?

Question 4 of 10 4/10

Which function is NOT related to =DECIMAL?

Question 5 of 10 5/10

In =DECIMAL, which is argument #1?

Question 6 of 10 6/10

How many required arguments does =DECIMAL have?

Question 7 of 10 7/10

Which is the correct syntax of =DECIMAL?

Question 8 of 10 8/10

Which statement about =DECIMAL is correct?

Question 9 of 10 9/10

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

Question 10 of 10 10/10

Is argument “text” required in =DECIMAL?

Click a question to see the answer.

1. How many optional arguments does =DECIMAL have?

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

Explanation: =DECIMAL has 2 required, 0 optional (2 total).

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

A. Requires add-in
B. Output is always a dynamic array
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

3. Which category does =DECIMAL belong to?

A. Web
B. Statistical
C. Information
D. Math & Trig ✓

Explanation: Category is “Math & Trig”.

4. Which function is NOT related to =DECIMAL?

A. BASE
B. VALUE
C. FV ✓
D. DECIMAL_X

Explanation: “FV” is not related to DECIMAL.

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

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

Explanation: Argument #1 is “text”.

6. How many required arguments does =DECIMAL have?

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

Explanation: =DECIMAL has 2 required, 0 optional (2 total).

7. Which is the correct syntax of =DECIMAL?

A. =DECIMAL(text, radix, 0)
B. DECIMAL(text, radix)
C. =BASE(text, radix)
D. =DECIMAL(text, radix) ✓

Explanation: Correct syntax: =DECIMAL(text, radix)

8. Which statement about =DECIMAL is correct?

A. Only works in old versions
B. Text is always ignored
C. Excel supports a Text argument greater than or equal to 0 and less than 2^53. A text argument that resolves to a number greater than 2^53 may result in a loss of precision.
D. The string length of Text must be less than or equal to 255 characters. ✓

Explanation: Correct: The string length of Text must be less than or equal to 255 characters.

9. What is the type of argument “radix” in =DECIMAL?

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

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

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

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

Explanation: “text” is required.