Financial =AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis])

Quiz =AMORDEGRC — 15 Questions

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

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

← AMORDEGRC ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Is =AMORDEGRC volatile?

Question 2 of 15 2/15

Which is the correct syntax of =AMORDEGRC?

Question 3 of 15 3/15

Is argument “rate” required in =AMORDEGRC?

Question 4 of 15 4/15

In =AMORDEGRC, which is argument #2?

Question 5 of 15 5/15

Does =AMORDEGRC return a dynamic array?

Question 6 of 15 6/15

What is the type of argument “rate” in =AMORDEGRC?

Question 7 of 15 7/15

In =AMORDEGRC, which is argument #1?

Question 8 of 15 8/15

What usually causes #NUM! in =AMORDEGRC?

Question 9 of 15 9/15

How many required arguments does =AMORDEGRC have?

Question 10 of 15 10/15

Is argument “period” required in =AMORDEGRC?

Question 11 of 15 11/15

Is argument “date_purchased” required in =AMORDEGRC?

Question 12 of 15 12/15

How many arguments does =AMORDEGRC have in total?

Question 13 of 15 13/15

Which function is related to =AMORDEGRC?

Question 14 of 15 14/15

Is argument “cost” required in =AMORDEGRC?

Question 15 of 15 15/15

Which category does =AMORDEGRC belong to?

Click a question to see the answer.

1. Is =AMORDEGRC volatile?

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

Explanation: AMORDEGRC is not volatile.

2. Which is the correct syntax of =AMORDEGRC?

A. =AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis], 0)
B. =AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis]) ✓
C. AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis])
D. =AMORLINC(cost, date_purchased, first_period, salvage, period, rate, [basis])

Explanation: Correct syntax: =AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis])

3. Is argument “rate” required in =AMORDEGRC?

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

Explanation: “rate” is required.

4. In =AMORDEGRC, which is argument #2?

A. range
B. date_purchased ✓
C. value
D. period

Explanation: Argument #2 is “date_purchased”.

5. Does =AMORDEGRC return a dynamic array?

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

Explanation: AMORDEGRC does not spill.

6. What is the type of argument “rate” in =AMORDEGRC?

A. Text
B. Array
C. Reference
D. Number ✓

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

7. In =AMORDEGRC, which is argument #1?

A. cost ✓
B. range
C. criteria
D. salvage

Explanation: Argument #1 is “cost”.

8. What usually causes #NUM! in =AMORDEGRC?

A. Only works in old versions
B. If the life of assets is between 0 (zero) and 1, 1 and 2, 2 and 3, or 4 and 5, the #NUM! error value is returned. ✓
C. Requires add-in
D. Volatile and recalculates every time

Explanation: If the life of assets is between 0 (zero) and 1, 1 and 2, 2 and 3, or 4 and 5, the #NUM! error value is returned. — Fix: Check the inputs

9. How many required arguments does =AMORDEGRC have?

A. 8
B. 6 ✓
C. 7
D. 5

Explanation: =AMORDEGRC has 6 required, 1 optional (7 total).

10. Is argument “period” required in =AMORDEGRC?

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

Explanation: “period” is required.

11. Is argument “date_purchased” required in =AMORDEGRC?

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

Explanation: “date_purchased” is required.

12. How many arguments does =AMORDEGRC have in total?

A. 8
B. 9
C. 7 ✓
D. 6

Explanation: =AMORDEGRC has 6 required, 1 optional (7 total).

13. Which function is related to =AMORDEGRC?

A. AMORLINC ✓
B. ROUNDDOWN
C. YEARFRAC
D. RIGHT

Explanation: “AMORLINC” is related to AMORDEGRC.

14. Is argument “cost” required in =AMORDEGRC?

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

Explanation: “cost” is required.

15. Which category does =AMORDEGRC belong to?

A. Text
B. Financial ✓
C. Information
D. Database

Explanation: Category is “Financial”.