CUETMOCK
  • Pricing
  • Mentors
Log inStart freeStart free mocks→

First test, then trust

Try a free CUET mock test.

Join 5,00,000+ students who rehearsed exam day on the exact NTA screen before sitting CUET. On the web and on Android.

Start free mocks →Get the Android app
CUETMOCK

India's #1 CUET Mock Test Platform. Original NCERT-based questions on the exact NTA exam screen — trusted by 5,00,000+ students since CUET 2022.

Get it onGoogle PlayScan to download the CUETMOCK app

Mock tests

  • CUET mock test series
  • Browse all papers
  • Commerce mocks
  • Humanities (Arts) mocks
  • Science mocks
  • Languages & GAT mocks
  • Free practice questions
  • Pricing

Resources

  • CUET exam guide
  • CUET syllabus
  • Universities accepting CUET
  • Expert blogs
  • News & notifications
  • Webinars & counselling
  • CUET score calculator
  • How we estimate your rank
  • FAQs

Company

  • About us
  • Our leadership & team
  • Our toppers
  • Mentors
  • For schools
  • Contact us
  • Terms
  • Privacy
  • Refund policy

Talk to us

+91 7696 6630 56info@cuetmock.comWhatsApp us

Our other platforms

  • JEE Mock — For IIT-JEE aspirants
  • NEET Mock — For NEET aspirants

Newsletter

Exam updates, study material and offers — no spam.

© 2026 NYC Ventures Pvt. Ltd.

701-702, Royal Business Park, Zirakpur, Punjab - 140603

  • Terms of use
  • Privacy policy
  • Refund policy
  • Contact us

iCUETMOCK is an independent preparation platform, not affiliated with the National Testing Agency (NTA). Always check exam details on the official NTA website.

  • Home
  • Mock tests
  • CUET guide
  • Pricing
  • Log in
Home/Practice questions/Accountancy Part C
Accountancy Part CSpreadsheet

Match List-I (Excel Function) with List-II (Use)List-I(A) CUMIPMT(B)…

Match List-I (Excel Function) with List-II (Use)

List-I

(A) CUMIPMT

(B) PV

(C) PMT

(D) NPV

List-II

(I) This function returns the present value of an investment.

(II) This function calculates the periodic payment for an annuity, assuming equal payments and a constant rate of interest

(III) This function returns the cumulative interest paid between two periods

(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:

Answer & explanation+

Correct answer: option 4

The correct answer is Option (4) → (A) - (III), (B) - (I), (C) - (II), (D) - (IV)

These are Excel's financial functions. The name of each function tells what it returns.

(A) CUMIPMT — this matches (III) This function returns the cumulative interest paid between two periods. CUM-I-PMT stands for cumulative interest payment, from a start period to an end period.

(B) PV — this matches (I) This function returns the present value of an investment. PV is present value: what a series of future payments is worth today, such as the loan amount.

(C) PMT — this matches (II) This function calculates the periodic payment for an annuity, assuming equal payments and a constant rate of interest. PMT is the payment per period, such as a loan instalment.

(D) NPV — this matches (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). NPV nets payments against income at a discount rate.

NCERT (2026-27 edition):
Financial Functions

Extract from the NCERT textbook

Extract from the NCERT textbook

Extract from the NCERT textbook

Extract from the NCERT textbook

Extract from the NCERT textbook

Advertisement

Practise more on Spreadsheet

Chapter-wise mocks on the real NTA exam screen, with solutions and your rank. Your first mocks are free.

Start free mocks →

Advertisement

Next questions

  1. Which class of following compound react with 2,4-DNP reagent to form an orange-red precipitate?Chemistry · Organic: Aldehydes, Ketones and Carboxylic Acids
  2. Characteristics such as hardworking, sincere, warm, loving and empathetic can also be called __________.Psychology · Self and Personality
  3. The kinetic energy of an electron in ground level in hydrogen atom is K units. The values of potential energy and total energy, respectivel…Physics · Atoms
  4. A box has 5 blue and 4 red balls. One ball is drawn at random and not replaced. Its colour is also not noted, then another ball is drawn at…Maths. Section A · Probability (Section A)
  5. Choose the appropriate word from the options given to complete the following sentence.Fortunately, her parents were ________unaware of what…English · Fill Blanks
  6. Rearrange the following parts of a sentence to make a meaningful sentence:A. the local language and see how yourB. travel to a foreign coun…English · Arrange in Meaningful Sequence
  7. The binding energy per nucleon of a nucleus (A = 240) is 7.8 MeV. If it breaks into two equal fragments, each of A = 120 and binding energy…Physics · Nuclei
  8. If m is the order and n is degree of differential equations, thenMatch List-I with List-IIList-IList-II(Differential Equation)(2m + n)(A) ≤…Maths. Section A · Differential Equations (Section A)
  9. The total expenditure on a commodity rises from Rs.100 to Rs.150 as a result of an increase in the price of the commodity from Rs. 10 to Rs…Economics · Micro Economics: Theory of Consumer behaviour
  10. A measurable characteristic of a sample is known as :Applied Maths. Section B2 · Inferential Statistics