Financial =RECEIVED(settlement, maturity, investment, discount, [basis])

Quiz =RECEIVED — 10 Questions

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

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

← RECEIVED ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

How many optional arguments does =RECEIVED have?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

In =RECEIVED, which is argument #1?

Question 4 of 10 4/10

Does =RECEIVED return a dynamic array?

Question 5 of 10 5/10

What usually causes #VALUE! in =RECEIVED?

Question 6 of 10 6/10

Is argument “maturity” required in =RECEIVED?

Question 7 of 10 7/10

Which statement about =RECEIVED is correct?

Question 8 of 10 8/10

Which is the correct syntax of =RECEIVED?

Question 9 of 10 9/10

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

Question 10 of 10 10/10

What is the type of argument “maturity” in =RECEIVED?

Click a question to see the answer.

1. How many optional arguments does =RECEIVED have?

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

Explanation: =RECEIVED has 4 required, 1 optional (5 total).

2. What is the fix for #NUM! in =RECEIVED?

A. Only works in old versions
B. Select entire column for best performance
C. Text is always ignored
D. Check the order of the dates and the input values ✓

Explanation: If investment ≤ 0 or if discount ≤ 0, RECEIVED returns the #NUM! error value. If basis < 0 or if basis > 4, RECEIVED returns the #NUM! error value. If settlement ≥ maturity, RECEIVED returns the #NUM! error value. — Fix: Check the order of the dates and the input values

3. In =RECEIVED, which is argument #1?

A. range
B. settlement ✓
C. maturity
D. basis

Explanation: Argument #1 is “settlement”.

4. Does =RECEIVED return a dynamic array?

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

Explanation: RECEIVED does not spill.

5. What usually causes #VALUE! in =RECEIVED?

A. If settlement or maturity is not a valid date, RECEIVED returns the #VALUE! error value. ✓
B. مقدار investment یا discount صفر یا منفی، basis خارج از بازه ۰ تا ۴، یا settlement مساوی یا بعد از maturity است.
C. Volatile and recalculates every time
D. Text is always ignored

Explanation: If settlement or maturity is not a valid date, RECEIVED returns the #VALUE! error value. — Fix: تاریخ‌ها را با تابع DATE وارد کنید یا بررسی کنید سلول‌ها واقعاً تاریخ باشند.

6. Is argument “maturity” required in =RECEIVED?

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

Explanation: “maturity” is required.

7. Which statement about =RECEIVED is correct?

A. Microsoft Excel stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900.
B. Requires add-in
C. Text is always ignored
D. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text. ✓

Explanation: Correct: Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.

8. Which is the correct syntax of =RECEIVED?

A. RECEIVED(settlement, maturity, investment, discount, [basis])
B. =RECEIVED(settlement, maturity, investment, discount, [basis]) ✓
C. =RECEIVED(settlement, maturity, investment, discount, [basis], 0)
D. =INTRATE(settlement, maturity, investment, discount, [basis])

Explanation: Correct syntax: =RECEIVED(settlement, maturity, investment, discount, [basis])

9. What is the fix for #VALUE! in =RECEIVED?

A. Only works in old versions
B. Text is always ignored
C. تاریخ‌ها را با تابع DATE وارد کنید یا بررسی کنید سلول‌ها واقعاً تاریخ باشند. ✓
D. Output is always a dynamic array

10. What is the type of argument “maturity” in =RECEIVED?

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

Explanation: Type of “maturity” is “Date”.