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 usually causes #VALUE! in =NOMINAL?

Question 2 of 10 2/10

Which formula is a valid example of =NOMINAL?

Question 3 of 10 3/10

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

Question 4 of 10 4/10

Which is the correct syntax of =NOMINAL?

Question 5 of 10 5/10

Which category does =NOMINAL belong to?

Question 6 of 10 6/10

Which function is NOT related to =NOMINAL?

Question 7 of 10 7/10

What usually causes #NUM! in =NOMINAL?

Question 8 of 10 8/10

What is the output type of =NOMINAL?

Question 9 of 10 9/10

Is argument “effect_rate” required in =NOMINAL?

Question 10 of 10 10/10

How many required arguments does =NOMINAL have?

Click a question to see the answer.

1. What usually causes #VALUE! in =NOMINAL?

A. Volatile and recalculates every time
B. Select entire column for best performance
C. If either argument is nonnumeric, NOMINAL returns the #VALUE! error value. ✓
D. مقدار effect_rate کوچک‌تر یا مساوی صفر است یا npery کوچک‌تر از 1 است.

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

2. Which formula is a valid example of =NOMINAL?

A. =NOMINAL(A2,A3, 0)
B. =NOMINAL(A2,A3) ✓
C. =EFFECT(A2,A3)
D. NOMINAL(A2,A3)

Explanation: Correct example: =NOMINAL(A2,A3)

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

A. Volatile and recalculates every time
B. Text is always ignored
C. Check the two arguments ✓
D. Select entire column for best performance

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

4. Which is the correct syntax of =NOMINAL?

A. =EFFECT(effect_rate, npery)
B. NOMINAL(effect_rate, npery)
C. =NOMINAL(effect_rate, npery) ✓
D. =NOMINAL(effect_rate, npery, 0)

Explanation: Correct syntax: =NOMINAL(effect_rate, npery)

5. Which category does =NOMINAL belong to?

A. Engineering
B. Statistical
C. Lookup & Reference
D. Financial ✓

Explanation: Category is “Financial”.

6. Which function is NOT related to =NOMINAL?

A. EFFECT
B. RATE
C. COPILOT ✓
D. NOMINAL_X

Explanation: “COPILOT” is not related to NOMINAL.

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

A. یک یا هر دو آرگومان غیرعددی هستند.
B. If effect_rate ≤ 0 or if npery < 1, NOMINAL returns the #NUM! error value. ✓
C. Volatile and recalculates every time
D. Requires add-in

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

8. What is the output type of =NOMINAL?

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

Explanation: Output is “Number”.

9. Is argument “effect_rate” required in =NOMINAL?

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

Explanation: “effect_rate” is required.

10. How many required arguments does =NOMINAL have?

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

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