Financial =AMORLINC(cost, date_purchased, first_period, salvage, period, rate, [basis])

Quiz =AMORLINC — 15 Questions

15 quiz questions about =AMORLINC — test syntax, arguments, examples & errors!

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

← AMORLINC ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

How many optional arguments does =AMORLINC have?

Question 2 of 15 2/15

What is the type of argument “rate” in =AMORLINC?

Question 3 of 15 3/15

Which statement about =AMORLINC is correct?

Question 4 of 15 4/15

Which use case fits =AMORLINC?

Question 5 of 15 5/15

Is argument “cost” required in =AMORLINC?

Question 6 of 15 6/15

Is =AMORLINC volatile?

Question 7 of 15 7/15

In =AMORLINC, which is argument #2?

Question 8 of 15 8/15

Is argument “rate” required in =AMORLINC?

Question 9 of 15 9/15

Which function is NOT related to =AMORLINC?

Question 10 of 15 10/15

Which is the correct syntax of =AMORLINC?

Question 11 of 15 11/15

How many required arguments does =AMORLINC have?

Question 12 of 15 12/15

Is argument “first_period” required in =AMORLINC?

Question 13 of 15 13/15

How many arguments does =AMORLINC have in total?

Question 14 of 15 14/15

What is the output type of =AMORLINC?

Question 15 of 15 15/15

Which function is related to =AMORLINC?

Click a question to see the answer.

1. How many optional arguments does =AMORLINC have?

A. 1 ✓
B. 3
C. 0
D. 2

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

2. What is the type of argument “rate” in =AMORLINC?

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

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

3. Which statement about =AMORLINC is correct?

A. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text. ✓
B. Text is always ignored
C. Select entire column for best performance
D. Volatile and recalculates every time

Explanation: Correct: Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.

4. Which use case fits =AMORLINC?

A. Date & Time Calculations
B. Depreciation
C. External Data, Web & Cube
D. Financial Calculations ✓

Explanation: Use case “Financial Calculations” fits AMORLINC.

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

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

Explanation: “cost” is required.

6. Is =AMORLINC volatile?

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

Explanation: AMORLINC is not volatile.

7. In =AMORLINC, which is argument #2?

A. first_period
B. basis
C. date_purchased ✓
D. cost

Explanation: Argument #2 is “date_purchased”.

8. Is argument “rate” required in =AMORLINC?

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

Explanation: “rate” is required.

9. Which function is NOT related to =AMORLINC?

A. AMORDEGRC
B. ACOT ✓
C. SLN
D. AMORLINC_X

Explanation: “ACOT” is not related to AMORLINC.

10. Which is the correct syntax of =AMORLINC?

A. =AMORLINC(cost, date_purchased, first_period, salvage, period, rate, [basis]) ✓
B. =AMORLINC(cost, date_purchased, first_period, salvage, period, rate, [basis], 0)
C. AMORLINC(cost, date_purchased, first_period, salvage, period, rate, [basis])
D. =AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis])

Explanation: Correct syntax: =AMORLINC(cost, date_purchased, first_period, salvage, period, rate, [basis])

11. How many required arguments does =AMORLINC have?

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

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

12. Is argument “first_period” required in =AMORLINC?

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

Explanation: “first_period” is required.

13. How many arguments does =AMORLINC have in total?

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

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

14. What is the output type of =AMORLINC?

A. Array
B. Number ✓
C. Reference
D. Value

Explanation: Output is “Number”.

15. Which function is related to =AMORLINC?

A. DEC2HEX
B. CHISQ.INV.RT
C. AMORDEGRC ✓
D. FLOOR.MATH

Explanation: “AMORDEGRC” is related to AMORLINC.