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 CUse of Spreadsheet in Business Applications

Match List-I with List-IIList-I(A) Interest rate per period for the l…

Match List-I with List-II

List-I

(A) Interest rate per period for the loan

(B) Total number of payments for the loan. Its unit (e.g. year) should match with the unit of the interest rate

(C) Whether payment is made at the beginning (value=1) or at the end (value=0) of the period

(D) Future value, which is taken as 0, is the balance at the end of the loan period

List-II

(I) Type

(II) Rate

(III) FV

(IV) Nper

Choose the correct answer from the options given below:

Answer & explanation+

Correct answer: option 2

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

Excel’s PMT function works out the instalment on a loan from its arguments: rate, number of payments, present value, future value and type.

(A) Interest rate per period for the loan — this matches (II) Rate. Rate is the interest charged for each period, for example the monthly rate for monthly instalments.

(B) Total number of payments for the loan. Its unit (e.g. year) should match with the unit of the interest rate — this matches (IV) Nper. Nper is the number of periods, counted in the same unit as the rate.

(C) Whether payment is made at the beginning (value=1) or at the end (value=0) of the period — this matches (I) Type. Type tells Excel when each payment falls due.

(D) Future value, which is taken as 0, is the balance at the end of the loan period — this matches (III) FV. FV is the balance left after the last payment, which is nil for a loan repaid in full.

NCERT (2026-27 edition):
Calculating Interest and Repayments of Loan

Extract from the NCERT textbook

Advertisement

Practise more on Use of Spreadsheet in Business Applications

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. Who is the author of the book titled, “The Story of Indian Archaeology”?History · Ancient India: Bricks, Beads and Bones
  2. As a result of __________, the same structure takes different forms because it performs different functions:Biology · Evolution
  3. In agarose gel electrophoresis, the separated DNA fragments can be visualised with the help of -Biology · Biotechnology -Principles and Processes
  4. Match List-I with List-IIList-IList-II(A)Dissolution expenses of Rs. 7,800 were paid by partner.(I)Realisation A/c …..Dr To Bank A/c(B)When…Accountancy Part A · Dissolution of Partnership Firm
  5. Moreh-Tamu and Zokhawthar-Rhi are border trade points between India and which of the following neighbouring countries?General Aptitude Test · General Knowledge
  6. Which of the following factors are responsible for the loss of biodiversity?A. MigrationB. Over-exploitationC. FragmentationD. Co-extinctio…Biology · Biodiversity and Conservation
  7. Choose the correct option to fill in the blank in the given sentence:This column _________ twice weekly in the newspaper that I subscribe t…English · Grammar: Tenses
  8. The number of iron balls, each 1 cm in radius, that can be made from an iron sphere of diameter 12 cm is:General Aptitude Test · Quantitative Reasoning
  9. Which coding type consists of alphabets or abbreviations as symbols to codify a piece of information?Accountancy Part C · Overview of Computerised Accounting System
  10. Match List-I with List-IILIST-ILIST-IIDiseasesCausative organisms(A) Common cold(I) Haemophilus influenzae(B) Malaria(II) Salmonella typhi(…Biology · Human Health and Disease