Financial =NOMINAL(effect_rate, npery)

Quiz =NOMINAL — 10 Questions

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

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

← NOMINAL ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What is the type of argument “npery” in =NOMINAL?

Question 2 of 10 2/10

What usually causes #NUM! in =NOMINAL?

Question 3 of 10 3/10

Since which Excel version is =NOMINAL available?

Question 4 of 10 4/10

What is the fix for #NUM! in =NOMINAL?

Question 5 of 10 5/10

Which statement about =NOMINAL is correct?

Question 6 of 10 6/10

How many required arguments does =NOMINAL have?

Question 7 of 10 7/10

Is argument “npery” required in =NOMINAL?

Question 8 of 10 8/10

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

Question 9 of 10 9/10

How many optional arguments does =NOMINAL have?

Question 10 of 10 10/10

Which category does =NOMINAL belong to?

Click a question to see the answer.

1. What is the type of argument “npery” in =NOMINAL?

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

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

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

A. Select entire column for best performance
B. Requires add-in
C. Output is always a dynamic array
D. If effect_rate ≤ 0 or if npery < 1, NOMINAL returns the #NUM! error value. ✓

Explanation: If effect_rate ≤ 0 or if npery < 1, NOMINAL returns the #NUM! error value. — Fix: Check the two arguments

3. Since which Excel version is =NOMINAL available?

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

Explanation: Version: “All versions”.

4. What is the fix for #NUM! in =NOMINAL?

A. Check the two arguments ✓
B. Volatile and recalculates every time
C. یک یا هر دو آرگومان غیرعددی هستند.
D. Text is always ignored

Explanation: If effect_rate ≤ 0 or if npery < 1, NOMINAL returns the #NUM! error value. — Fix: Check the two arguments

5. Which statement about =NOMINAL is correct?

A. Output is always a dynamic array
B. The relationship between NOMINAL and EFFECT is shown in the following equation:
C. Npery is truncated to an integer. ✓
D. Requires add-in

Explanation: Correct: Npery is truncated to an integer.

6. How many required arguments does =NOMINAL have?

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

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

7. Is argument “npery” required in =NOMINAL?

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

Explanation: “npery” is required.

8. What is the fix for #VALUE! in =NOMINAL?

A. Volatile and recalculates every time
B. برای effect_rate و npery مقادیر عددی وارد کنید. ✓
C. Select entire column for best performance
D. مقدار effect_rate کوچک‌تر یا مساوی صفر است یا npery کوچک‌تر از 1 است.

Explanation: If either argument is nonnumeric, NOMINAL returns the #VALUE! error value. — Fix: برای effect_rate و npery مقادیر عددی وارد کنید.

9. How many optional arguments does =NOMINAL have?

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

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

10. Which category does =NOMINAL belong to?

A. Date & Time
B. Financial ✓
C. Lookup & Reference
D. Cube

Explanation: Category is “Financial”.