Financial =DB(cost, salvage, life, period, [month])

Quiz =DB — 10 Questions

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

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

← DB ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

In =DB, which is argument #3?

Question 2 of 10 2/10

Since which Excel version is =DB available?

Question 3 of 10 3/10

Which formula is a valid example of =DB?

Question 4 of 10 4/10

Which function is related to =DB?

Question 5 of 10 5/10

What is the type of argument “salvage” in =DB?

Question 6 of 10 6/10

Which use case fits =DB?

Question 7 of 10 7/10

Which is the correct syntax of =DB?

Question 8 of 10 8/10

What is the output type of =DB?

Question 9 of 10 9/10

Which statement about =DB is correct?

Question 10 of 10 10/10

Is argument “month” required in =DB?

Click a question to see the answer.

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

A. life ✓
B. cost
C. range
D. lookup_value

Explanation: Argument #3 is “life”.

2. Since which Excel version is =DB available?

A. All versions ✓
B. Excel 365
C. Excel 2019
D. Excel 2007 (Compatibility)

Explanation: Version: “All versions”.

3. Which formula is a valid example of =DB?

A. DB(A2,A3,A4,1,7)
B. =DB(A2,A3,A4,1,7, 0)
C. =DDB(A2,A3,A4,1,7)
D. =DB(A2,A3,A4,1,7) ✓

Explanation: Correct example: =DB(A2,A3,A4,1,7)

4. Which function is related to =DB?

A. EXPON.DIST
B. DDB ✓
C. ACOTH
D. QUOTIENT

Explanation: “DDB” is related to DB.

5. What is the type of argument “salvage” in =DB?

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

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

6. Which use case fits =DB?

A. Investment Appraisal
B. Conditional Logic
C. Financial Calculations ✓
D. Workdays & Due Dates

Explanation: Use case “Financial Calculations” fits DB.

7. Which is the correct syntax of =DB?

A. =DB(cost, salvage, life, period, [month]) ✓
B. =DDB(cost, salvage, life, period, [month])
C. =DB(cost, salvage, life, period, [month], 0)
D. DB(cost, salvage, life, period, [month])

Explanation: Correct syntax: =DB(cost, salvage, life, period, [month])

8. What is the output type of =DB?

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

Explanation: Output is “Number”.

9. Which statement about =DB is correct?

A. Requires add-in
B. The fixed-declining balance method computes depreciation at a fixed rate. DB uses the following formulas to calculate depreciation for a period: (cost - total depreciation from prior periods) * rate where: rate = 1 - ((salvage / cost) ^ (1 / life)), rounded to three decimal places ✓
C. Output is always a dynamic array
D. For the last period, DB uses this formula: ((cost - total depreciation from prior periods) * rate * (12 - month)) / 12

Explanation: Correct: The fixed-declining balance method computes depreciation at a fixed rate. DB uses the following formulas to calculate depreciation for a period: (cost - total depreciation from prior periods) * rate where: rate = 1 - ((salvage / cost) ^ (1 / life)), rounded to three decimal places

10. Is argument “month” required in =DB?

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

Explanation: “month” is optional.