Get Started
Start Free Mocks
CUETMOCK

Ace Your

CUET Preparation Today

Start Free Mocks
Home Questions 7DCR0P8MA3
Target Exam

CUET

Subject

Accountancy Part C

Chapter

Use of Spreadsheet in Business Applications

Question:

Match List-I with List-II

List-I
Excel Function		List-II
Use
(A) CUMIPMT(I) This function returns the present value of an investment.
(B) PV(II) This function calculates the periodic payment for an annuity, assuming equal payments and a constant rate of interest
(C) PMT(III) This function returns the cumulative interest paid between two periods
(D) NPV(IV) This function calculates the net present value of an investment by using a discount rate and a series of future payments (negative values) and income (positive values).

Choose the correct answer from the options given below:

Options:

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

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

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

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

Correct Answer:

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

Explanation:

The correct answer is Option (4) → 

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

CUET Questions