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

Does =NUMBERVALUE return a dynamic array?

Question 2 of 10 2/10

Is =NUMBERVALUE volatile?

Question 3 of 10 3/10

How many optional arguments does =NUMBERVALUE have?

Question 4 of 10 4/10

What usually causes #VALUE! in =NUMBERVALUE?

Question 5 of 10 5/10

In =NUMBERVALUE, which is argument #1?

Question 6 of 10 6/10

In =NUMBERVALUE, which is argument #2?

Question 7 of 10 7/10

How many arguments does =NUMBERVALUE have in total?

Question 8 of 10 8/10

In =NUMBERVALUE, which is argument #3?

Question 9 of 10 9/10

Which category does =NUMBERVALUE belong to?

Question 10 of 10 10/10

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

Click a question to see the answer.

1. Does =NUMBERVALUE return a dynamic array?

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

Explanation: NUMBERVALUE does not spill.

2. Is =NUMBERVALUE volatile?

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

Explanation: NUMBERVALUE is not volatile.

3. How many optional arguments does =NUMBERVALUE have?

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

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

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

A. If a decimal separator is used more than once in the Text argument, NUMBERVALUE returns the #VALUE! error value. If the group separator occurs after the decimal separator in the Text argument, NUMBERVALUE returns the #VALUE! error value. If any of the arguments are not valid, NUMBERVALUE returns the #VALUE! error value. ✓
B. Select entire column for best performance
C. Text is always ignored
D. Volatile and recalculates every time

Explanation: If a decimal separator is used more than once in the Text argument, NUMBERVALUE returns the #VALUE! error value. If the group separator occurs after the decimal separator in the Text argument, NUMBERVALUE returns the #VALUE! error value. If any of the arguments are not valid, NUMBERVALUE returns the #VALUE! error value. — Fix: Use text with the specified separators

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

A. text ✓
B. group_separator
C. criteria
D. decimal_separator

Explanation: Argument #1 is “text”.

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

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

Explanation: Argument #2 is “decimal_separator”.

7. How many arguments does =NUMBERVALUE have in total?

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

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

8. In =NUMBERVALUE, which is argument #3?

A. group_separator ✓
B. text
C. criteria
D. decimal_separator

Explanation: Argument #3 is “group_separator”.

9. Which category does =NUMBERVALUE belong to?

A. Statistical
B. Cube
C. Financial
D. Compatibility ✓

Explanation: Category is “Compatibility”.

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

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

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