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

How many arguments does =AMORDEGRC have in total?

Question 2 of 15 2/15

Which use case fits =AMORDEGRC?

Question 3 of 15 3/15

How many required arguments does =AMORDEGRC have?

Question 4 of 15 4/15

Is argument “salvage” required in =AMORDEGRC?

Question 5 of 15 5/15

Is argument “rate” required in =AMORDEGRC?

Question 6 of 15 6/15

Which formula is a valid example of =AMORDEGRC?

Question 7 of 15 7/15

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

Question 8 of 15 8/15

How many optional arguments does =AMORDEGRC have?

Question 9 of 15 9/15

Which statement about =AMORDEGRC is correct?

Question 10 of 15 10/15

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

Question 11 of 15 11/15

Is argument “cost” required in =AMORDEGRC?

Question 12 of 15 12/15

Is =AMORDEGRC volatile?

Question 13 of 15 13/15

Which function is NOT related to =AMORDEGRC?

Question 14 of 15 14/15

In =AMORDEGRC, which is argument #2?

Question 15 of 15 15/15

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

Click a question to see the answer.

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

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

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

2. Which use case fits =AMORDEGRC?

A. Loans & Installments
B. Financial Calculations ✓
C. Forecasting & Trends
D. Numbering & Sample Data

Explanation: Use case “Financial Calculations” fits AMORDEGRC.

3. How many required arguments does =AMORDEGRC have?

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

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

4. Is argument “salvage” required in =AMORDEGRC?

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

Explanation: “salvage” is required.

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

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

Explanation: “rate” is required.

6. Which formula is a valid example of =AMORDEGRC?

A. =AMORLINC(A2,A3,A4,A5,A6,A7,A8)
B. =AMORDEGRC(A2,A3,A4,A5,A6,A7,A8, 0)
C. AMORDEGRC(A2,A3,A4,A5,A6,A7,A8)
D. =AMORDEGRC(A2,A3,A4,A5,A6,A7,A8) ✓

Explanation: Correct example: =AMORDEGRC(A2,A3,A4,A5,A6,A7,A8)

7. What is the type of argument “cost” in =AMORDEGRC?

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

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

8. How many optional arguments does =AMORDEGRC have?

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

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

9. Which statement about =AMORDEGRC is correct?

A. The depreciation rate will grow to 50 percent for the period preceding the last period and will grow to 100 percent for the last period.
B. Because of changes to the depreciation methodology of the French accounting system, this function is deprecated and should no longer be used. It is included for compatibility of old workbooks only. ✓
C. This function will return the depreciation until the last period of the life of the assets or until the cumulated value of depreciation is greater than the cost of the assets minus the salvage value.
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: Because of changes to the depreciation methodology of the French accounting system, this function is deprecated and should no longer be used. It is included for compatibility of old workbooks only.

10. What is the type of argument “period” in =AMORDEGRC?

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

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

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

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

Explanation: “cost” is required.

12. Is =AMORDEGRC volatile?

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

Explanation: AMORDEGRC is not volatile.

13. Which function is NOT related to =AMORDEGRC?

A. AMORDEGRC_X
B. CODE ✓
C. DDB
D. AMORLINC

Explanation: “CODE” is not related to AMORDEGRC.

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

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

Explanation: Argument #2 is “date_purchased”.

15. What is the fix for #NUM! in =AMORDEGRC?

A. Volatile and recalculates every time
B. Only works in old versions
C. Check the inputs ✓
D. Output is always a dynamic array

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