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

← AMORDEGRC ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

How many arguments does =AMORDEGRC have in total?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

Which category does =AMORDEGRC belong to?

Question 4 of 10 4/10

Which formula is a valid example of =AMORDEGRC?

Question 5 of 10 5/10

Is argument “cost” required in =AMORDEGRC?

Question 6 of 10 6/10

Which function is NOT related to =AMORDEGRC?

Question 7 of 10 7/10

Which function is related to =AMORDEGRC?

Question 8 of 10 8/10

Is argument “period” required in =AMORDEGRC?

Question 9 of 10 9/10

Is argument “date_purchased” required in =AMORDEGRC?

Question 10 of 10 10/10

Which use case fits =AMORDEGRC?

Click a question to see the answer.

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

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

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

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

A. Requires add-in
B. Text is always ignored
C. Only works in old versions
D. Check the inputs ✓

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

3. Which category does =AMORDEGRC belong to?

A. Financial ✓
B. Logical
C. Cube
D. Math & Trig

Explanation: Category is “Financial”.

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

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

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

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

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

Explanation: “cost” is required.

6. Which function is NOT related to =AMORDEGRC?

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

Explanation: “CHIINV” is not related to AMORDEGRC.

7. Which function is related to =AMORDEGRC?

A. OCT2BIN
B. AMORLINC ✓
C. TRANSLATE
D. XMATCH

Explanation: “AMORLINC” is related to AMORDEGRC.

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

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

Explanation: “period” is required.

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

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

Explanation: “date_purchased” is required.

10. Which use case fits =AMORDEGRC?

A. Investment Appraisal
B. Financial Calculations ✓
C. Conditional Aggregation
D. Numbering & Sample Data

Explanation: Use case “Financial Calculations” fits AMORDEGRC.