Financial
=AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis])
Quiz =AMORDEGRC — 10 Questions
10 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
Progress — 10 questions
1 of 10
Question 1 of 10
1/10
In =AMORDEGRC, which is argument #2?
Explanation: Argument #2 is “date_purchased”.
Question 2 of 10
2/10
What is the fix for #NUM! in =AMORDEGRC?
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
Question 3 of 10
3/10
Does =AMORDEGRC return a dynamic array?
Explanation: AMORDEGRC does not spill.
Question 4 of 10
4/10
Which statement about =AMORDEGRC is correct?
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.
Question 5 of 10
5/10
Which use case fits =AMORDEGRC?
Explanation: Use case “Financial Calculations” fits AMORDEGRC.
Question 6 of 10
6/10
How many required arguments does =AMORDEGRC have?
Explanation: =AMORDEGRC has 6 required, 1 optional (7 total).
Question 7 of 10
7/10
What is the type of argument “period” in =AMORDEGRC?
Explanation: Type of “period” is “Number”.
Question 8 of 10
8/10
Is argument “cost” required in =AMORDEGRC?
Explanation: “cost” is required.
Question 9 of 10
9/10
What is the type of argument “cost” in =AMORDEGRC?
Explanation: Type of “cost” is “Number”.
Question 10 of 10
10/10
Is argument “period” required in =AMORDEGRC?
Explanation: “period” is required.