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

Which statement about =DB is correct?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

Is argument “life” required in =DB?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

Which is the correct syntax of =DB?

Question 6 of 10 6/10

How many arguments does =DB have in total?

Question 7 of 10 7/10

Which formula is a valid example of =DB?

Question 8 of 10 8/10

What is the output type of =DB?

Question 9 of 10 9/10

Is argument “salvage” required in =DB?

Question 10 of 10 10/10

Is argument “period” required in =DB?

Click a question to see the answer.

1. Which statement about =DB is correct?

A. Output is always a dynamic array
B. Requires add-in
C. Depreciation for the first and last periods is a special case. For the first period, DB uses this formula: cost * rate * month / 12
D. 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 ✓

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

2. What is the type of argument “month” in =DB?

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

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

3. Is argument “life” required in =DB?

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

Explanation: “life” is required.

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

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

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

5. Which is the correct syntax of =DB?

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

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

6. How many arguments does =DB have in total?

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

Explanation: =DB has 4 required, 1 optional (5 total).

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

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

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

8. What is the output type of =DB?

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

Explanation: Output is “Number”.

9. Is argument “salvage” required in =DB?

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

Explanation: “salvage” is required.

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

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

Explanation: “period” is required.