Match List-I with List-II.
| List-I | List-II | ||
|---|---|---|---|
| (A) | Depreciation using Straight Line Method | (I) | =PMT(Rate, Nper, Pv, Fv, Type) |
| (B) | Depreciation using Written Down Value Method | (II) | =SLN(cost, salvage, life) |
| (C) | Computation of Installment of Loan | (III) | Use Drop Down List |
| (D) | Data Validation | (IV) | = DB(Cost, Salvage, Life, Period, Month) |
Choose the correct answer from the options given below:
Answer & explanation
Correct answer: option 1
The correct answer is Option (1) → (A) - (II), (B) - (IV), (C) - (I), (D) - (III)
(A) Depreciation using Straight Line Method — this matches (II) =SLN(cost, salvage, life). SLN gives the same depreciation for every period.
(B) Depreciation using Written Down Value Method — this matches (IV) = DB(Cost, Salvage, Life, Period, Month). DB charges depreciation on the declining balance, which is the written down value method.
(C) Computation of Installment of Loan — this matches (I) =PMT(Rate, Nper, Pv, Fv, Type). PMT works out the periodic payment on a loan.
(D) Data Validation — this matches (III) Use Drop Down List. Validation limits what may be entered in a cell, and a drop-down list offers only the allowed entries.
NCERT (2026-27 edition): NCERT (2026-27 edition):
|
