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

How many required arguments does =NOMINAL have?

Question 2 of 10 2/10

Which use case fits =NOMINAL?

Question 3 of 10 3/10

What is the output type of =NOMINAL?

Question 4 of 10 4/10

Is argument “npery” required in =NOMINAL?

Question 5 of 10 5/10

What usually causes #NUM! in =NOMINAL?

Question 6 of 10 6/10

In =NOMINAL, which is argument #2?

Question 7 of 10 7/10

Which is the correct syntax of =NOMINAL?

Question 8 of 10 8/10

In =NOMINAL, which is argument #1?

Question 9 of 10 9/10

Which function is related to =NOMINAL?

Question 10 of 10 10/10

What usually causes #VALUE! in =NOMINAL?

Click a question to see the answer.

1. How many required arguments does =NOMINAL have?

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

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

2. Which use case fits =NOMINAL?

A. Date & Time Calculations
B. Conditional Formatting & Validation
C. Dynamic Ranges & Dashboards
D. Financial Calculations ✓

Explanation: Use case “Financial Calculations” fits NOMINAL.

3. What is the output type of =NOMINAL?

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

Explanation: Output is “Number”.

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

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

Explanation: “npery” is required.

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

A. Text is always ignored
B. If effect_rate ≤ 0 or if npery < 1, NOMINAL returns the #NUM! error value. ✓
C. Output is always a dynamic array
D. Only works in old versions

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

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

A. value
B. npery ✓
C. lookup_value
D. effect_rate

Explanation: Argument #2 is “npery”.

7. Which is the correct syntax of =NOMINAL?

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

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

8. In =NOMINAL, which is argument #1?

A. value
B. criteria
C. effect_rate ✓
D. npery

Explanation: Argument #1 is “effect_rate”.

9. Which function is related to =NOMINAL?

A. IMSECH
B. EFFECT ✓
C. FINDB
D. BETA.DIST

Explanation: “EFFECT” is related to NOMINAL.

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

A. مقدار effect_rate کوچک‌تر یا مساوی صفر است یا npery کوچک‌تر از 1 است.
B. Output is always a dynamic array
C. If either argument is nonnumeric, NOMINAL returns the #VALUE! error value. ✓
D. Text is always ignored

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