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 use case fits =DB?

Question 2 of 10 2/10

Which statement about =DB is correct?

Question 3 of 10 3/10

Does =DB return a dynamic array?

Question 4 of 10 4/10

Is argument “month” required in =DB?

Question 5 of 10 5/10

In =DB, which is argument #3?

Question 6 of 10 6/10

Is argument “cost” required in =DB?

Question 7 of 10 7/10

Which is the correct syntax of =DB?

Question 8 of 10 8/10

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

Question 9 of 10 9/10

How many arguments does =DB have in total?

Question 10 of 10 10/10

Which category does =DB belong to?

Click a question to see the answer.

1. Which use case fits =DB?

A. Financial Calculations ✓
B. Forecasting & Trends
C. Text Manipulation
D. Investment Appraisal

Explanation: Use case “Financial Calculations” fits DB.

2. Which statement about =DB is correct?

A. Output is always a dynamic array
B. Text is always ignored
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

3. Does =DB return a dynamic array?

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

Explanation: DB does not spill.

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

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

Explanation: “month” is optional.

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

A. salvage
B. cost
C. life ✓
D. period

Explanation: Argument #3 is “life”.

6. Is argument “cost” required in =DB?

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

Explanation: “cost” is required.

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]) ✓
D. =DB(cost, salvage, life, period, [month], 0)

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

8. What is the type of argument “cost” in =DB?

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

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

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

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

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

10. Which category does =DB belong to?

A. Date & Time
B. Web
C. Statistical
D. Financial ✓

Explanation: Category is “Financial”.