Compatibility =NUMBERVALUE(Text, [Decimal_separator], [Group_separator ])

Quiz =NUMBERVALUE — 10 Questions

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

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

← NUMBERVALUE ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Is argument “decimal_separator” required in =NUMBERVALUE?

Question 2 of 10 2/10

In =NUMBERVALUE, which is argument #1?

Question 3 of 10 3/10

What is the type of argument “group_separator” in =NUMBERVALUE?

Question 4 of 10 4/10

Does =NUMBERVALUE return a dynamic array?

Question 5 of 10 5/10

How many optional arguments does =NUMBERVALUE have?

Question 6 of 10 6/10

What is the type of argument “decimal_separator” in =NUMBERVALUE?

Question 7 of 10 7/10

What is the output type of =NUMBERVALUE?

Question 8 of 10 8/10

Is argument “group_separator” required in =NUMBERVALUE?

Question 9 of 10 9/10

Since which Excel version is =NUMBERVALUE available?

Question 10 of 10 10/10

Which statement about =NUMBERVALUE is correct?

Click a question to see the answer.

1. Is argument “decimal_separator” required in =NUMBERVALUE?

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

Explanation: “decimal_separator” is optional.

2. In =NUMBERVALUE, which is argument #1?

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

Explanation: Argument #1 is “text”.

3. What is the type of argument “group_separator” in =NUMBERVALUE?

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

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

4. Does =NUMBERVALUE return a dynamic array?

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

Explanation: NUMBERVALUE does not spill.

5. How many optional arguments does =NUMBERVALUE have?

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

Explanation: =NUMBERVALUE has 1 required, 2 optional (3 total).

6. What is the type of argument “decimal_separator” in =NUMBERVALUE?

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

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

7. What is the output type of =NUMBERVALUE?

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

Explanation: Output is “Number”.

8. Is argument “group_separator” required in =NUMBERVALUE?

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

Explanation: “group_separator” is optional.

9. Since which Excel version is =NUMBERVALUE available?

A. Excel 2019
B. Excel 365
C. All versions
D. Excel 2007 (Compatibility) ✓

Explanation: Version: “Excel 2007 (Compatibility)”.

10. Which statement about =NUMBERVALUE is correct?

A. Only works in old versions
B. Requires add-in
C. If the Decimal_separator and Group_separator arguments are not specified, separators from the current locale are used. ✓
D. If the Text argument ends in one or more percent signs (%), they are used in the calculation of the result. Multiple percent signs are additive if they are used in the Text argument just as they are if they are used in a formula. For example, =NUMBERVALUE("9%%") returns the same result (0.0009) as the formula =9%%.

Explanation: Correct: If the Decimal_separator and Group_separator arguments are not specified, separators from the current locale are used.