Match the 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., Drop Down List, D., Data Validation, IV., = DB(cost, salvage, life, period, [month]), Choose the correct answer from the options given below:

Question

Match the 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. | Drop Down List | | D. | Data Validation | IV. | = DB(cost, salvage, life, period, [month]) | Choose the correct answer from the options given below:

Accepted Answer

A-II, B-IV, C-I, D-III

Answer

A-IV, B-II, C-I, D-III

Answer

A-IV, B-II, C-III, D-I

Answer

A-III, B-IV, C-I, D-II

List-I	List-II
(A) It is the function which adds the cells as per given specified criteria	(I) ROUND
(B) It is the function to rounds a number to specified number of digits.	(II) CONCATENATE
(C) It is used to get the number of the entries in a number field (including date also) i.e. in a range or array of numbers.	(III) SUMIF
(D) This function joins two or more text strings into one text string	(IV) COUNT

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.	Drop Down List
D.	Data Validation	IV.	= DB(cost, salvage, life, period, [month])

Solution

Related questions:

Keyboard Shortcuts

CUET Accountancy Past Year Questions (Topic-Wise)