Financial =RRI(nper, pv, fv)

Quiz =RRI — 15 Questions

15 quiz questions about =RRI — test syntax, arguments, examples & errors!

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

← RRI ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Which category does =RRI belong to?

Question 2 of 15 2/15

What is the type of argument “pv” in =RRI?

Question 3 of 15 3/15

How many arguments does =RRI have in total?

Question 4 of 15 4/15

How many required arguments does =RRI have?

Question 5 of 15 5/15

What is the type of argument “nper” in =RRI?

Question 6 of 15 6/15

Which function is related to =RRI?

Question 7 of 15 7/15

Which use case fits =RRI?

Question 8 of 15 8/15

In =RRI, which is argument #1?

Question 9 of 15 9/15

In =RRI, which is argument #2?

Question 10 of 15 10/15

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

Question 11 of 15 11/15

Is argument “nper” required in =RRI?

Question 12 of 15 12/15

What usually causes #NUM! in =RRI?

Question 13 of 15 13/15

Does =RRI return a dynamic array?

Question 14 of 15 14/15

Is =RRI volatile?

Question 15 of 15 15/15

In =RRI, which is argument #3?

Click a question to see the answer.

1. Which category does =RRI belong to?

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

Explanation: Category is “Financial”.

2. What is the type of argument “pv” in =RRI?

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

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

3. How many arguments does =RRI have in total?

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

Explanation: =RRI has 3 required, 0 optional (3 total).

4. How many required arguments does =RRI have?

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

Explanation: =RRI has 3 required, 0 optional (3 total).

5. What is the type of argument “nper” in =RRI?

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

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

6. Which function is related to =RRI?

A. FV ✓
B. CUBEMEMBERPROPERTY
C. OCT2HEX
D. QUOTIENT

Explanation: “FV” is related to RRI.

7. Which use case fits =RRI?

A. External Data, Web & Cube
B. Worksheet Info & Navigation
C. Error Handling
D. Forecasting & Trends ✓

Explanation: Use case “Forecasting & Trends” fits RRI.

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

A. range
B. criteria
C. nper ✓
D. pv

Explanation: Argument #1 is “nper”.

9. In =RRI, which is argument #2?

A. pv ✓
B. range
C. fv
D. nper

Explanation: Argument #2 is “pv”.

10. What is the fix for #VALUE! in =RRI?

A. مطمئن شوید هر سه آرگومان Nper و Pv و Fv عدد هستند و متن یا مقدار غیرعددی وارد نکرده‌اید. ✓
B. Output is always a dynamic array
C. Text is always ignored
D. اگر مقادیر آرگومان‌ها معتبر نباشند، تابع RRI خطای #NUM! را برمی‌گرداند.

Explanation: If arguments are not using valid data types, RRI returns the #VALUE! error value. — Fix: مطمئن شوید هر سه آرگومان Nper و Pv و Fv عدد هستند و متن یا مقدار غیرعددی وارد نکرده‌اید.

11. Is argument “nper” required in =RRI?

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

Explanation: “nper” is required.

12. What usually causes #NUM! in =RRI?

A. Volatile and recalculates every time
B. اگر آرگومان‌ها از نوع داده معتبر استفاده نکنند، تابع RRI خطای #VALUE! را برمی‌گرداند.
C. If argument values are not valid, RRI returns the #NUM! error value. ✓
D. Output is always a dynamic array

Explanation: If argument values are not valid, RRI returns the #NUM! error value. — Fix: Check the first argument

13. Does =RRI return a dynamic array?

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

Explanation: RRI does not spill.

14. Is =RRI volatile?

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

Explanation: RRI is not volatile.

15. In =RRI, which is argument #3?

A. pv
B. fv ✓
C. range
D. nper

Explanation: Argument #3 is “fv”.