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

In =AMORLINC, which is argument #1?

Question 2 of 15 2/15

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

Question 3 of 15 3/15

Is argument “rate” required in =AMORLINC?

Question 4 of 15 4/15

Which function is NOT related to =AMORLINC?

Question 5 of 15 5/15

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

Question 6 of 15 6/15

What is the output type of =AMORLINC?

Question 7 of 15 7/15

Is argument “date_purchased” required in =AMORLINC?

Question 8 of 15 8/15

In =AMORLINC, which is argument #3?

Question 9 of 15 9/15

Is =AMORLINC volatile?

Question 10 of 15 10/15

Is argument “first_period” required in =AMORLINC?

Question 11 of 15 11/15

Is argument “period” required in =AMORLINC?

Question 12 of 15 12/15

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

Question 13 of 15 13/15

In =AMORLINC, which is argument #2?

Question 14 of 15 14/15

Which statement about =AMORLINC is correct?

Question 15 of 15 15/15

How many arguments does =AMORLINC have in total?

Click a question to see the answer.

1. In =AMORLINC, which is argument #1?

A. basis
B. cost ✓
C. rate
D. range

Explanation: Argument #1 is “cost”.

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

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

Explanation: Type of “date_purchased” is “Date”.

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

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

Explanation: “rate” is required.

4. Which function is NOT related to =AMORLINC?

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

Explanation: “TANH” is not related to AMORLINC.

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

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

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

6. What is the output type of =AMORLINC?

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

Explanation: Output is “Number”.

7. Is argument “date_purchased” required in =AMORLINC?

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

Explanation: “date_purchased” is required.

8. In =AMORLINC, which is argument #3?

A. period
B. first_period ✓
C. salvage
D. lookup_value

Explanation: Argument #3 is “first_period”.

9. Is =AMORLINC volatile?

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

Explanation: AMORLINC is not volatile.

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

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

Explanation: “first_period” is required.

11. Is argument “period” required in =AMORLINC?

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

Explanation: “period” is required.

12. What is the type of argument “first_period” in =AMORLINC?

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

Explanation: Type of “first_period” is “Date”.

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

A. lookup_value
B. date_purchased ✓
C. range
D. value

Explanation: Argument #2 is “date_purchased”.

14. 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. Select entire column for best performance
C. Volatile and recalculates every time
D. Requires add-in

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.

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

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

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