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 and List-II.List-IList-II(A) This function calculates th…

Match List-I and List-II.

List-IList-II
(A) This function calculates the periodic payment for an annuity, assuming equal payments and a constant rate of interest.(I) IRR function
(B) It is the total number of payment periods in an annuity.(II) PMT
(C) It is the number 0 or 1 and indicates when payments are due.(III) Nper
(D) NPV is also related to the(IV) Type

Choose the correct answer from the options given below:

Answer & explanation+

Correct answer: option 3

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

The items are financial functions of a spreadsheet and the arguments they use.

(A) This function calculates the periodic payment for an annuity, assuming equal payments and a constant rate of interest. — this matches (II) PMT. PMT returns the payment for each period, such as the monthly instalment of a loan at a fixed rate of interest.

(B) It is the total number of payment periods in an annuity. — this matches (III) Nper. For a four-year loan repaid monthly, nper is 4 × 12 = 48.

(C) It is the number 0 or 1 and indicates when payments are due. — this matches (IV) Type. Type 0 means payments at the end of each period and type 1 at the beginning.

(D) NPV is also related to the — this matches (I) IRR function. The internal rate of return is the rate at which the net present value equals zero.

NCERT (2026-27 edition):
PMT

Extract from the NCERT textbook

NCERT (2026-27 edition):
FV

Extract from the NCERT textbook

NCERT (2026-27 edition):
NPV – “… NPV is also related to the IRR function (internal rate of return). IRR is the rate for which NPV equals zero: NPV (IRR (...),) = 0.”

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. Your friend is a fabulous painter. Keeping in mind various intelligences from Howard Gardner’s theory, which of the following is the most s…Psychology · Variations in Psychological Attributes
  2. Choose the most appropriate option that has the following sentence from Direct to Indirect Speech:Lila asked, "Isn't skydiving a dangerous…English · Direct/indirect
  3. Identify the correct statements regarding the “terracotta figurines of women” found at Harappan sites:A. They were heavily jewelled.B. Some…History · Ancient India: Bricks, Beads and Bones
  4. Find the correct sequence of organizing process:A. DepartmentalizationB. Identification and division of workC. Assignment of dutiesD. Estab…Business Studies · Organising
  5. Identify the situation when no entry is required in case of dissolution of a partnership firm.Accountancy Part A · Dissolution of Partnership Firm
  6. The value of the determinant Δ= […] is:Maths. Section B1 · Determinants
  7. Which of the following organizations are involved in developing technology for biogas production?(A) Indian Agricultural Research Institute…Biology · Microbes in Human Welfare
  8. The reaction of alkyl halides with sodium metal in dry ether isChemistry · Organic: Haloalkanes and Haloarenes
  9. To what location were the majority of Black people forcibly relocated to?Sociology · Indian Society: Patterns of Social Inequality and Exclusion
  10. If y=≤ft(√x)^π such that displaystyledy/dx=(π)/ay^π+b where a,b∈R then:Maths. Section B1 · Continuity and Differentiability