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-IExcel FunctionList-IIUse(A) CUMIPMT(I)…

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:

Answer & explanation+

Correct answer: option 4

The correct answer is Option (4) → 

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

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. The sculpture from Sanchi shown below includes elephants. In the sculpture at Sanchi, elephants were depicted to signify which human attrib…History · Ancient India: Thinkers, Beliefs and Buildings
  2. A fresh watermelon weighing 20 kg contains 96% water. After 5 days, because of evaporation, its water content falls to 95%. Find the weight…General Aptitude Test · Numerical Ability
  3. How many major Puranas (Mahapuranas) are there?General Aptitude Test · General Knowledge
  4. Given below are two statements:Statement I: Biodiversity hotspots are regions of slow habitat loss.Statement II: Biodiversity hotspots were…Biology · Biodiversity and Conservation
  5. A sum of ₹3125 amounts to 3515.20 in 3 years at x% p.a., interest being compounded yearly. What will be the simple interest (in ₹) on the s…General Aptitude Test · Numerical Ability
  6. Who wrote the "Harshacharita", a biography of Harshavardhana?General Aptitude Test · General Knowledge
  7. Who among the following founded the 'Satyashodhak Samaj' ?Sociology · Indian Society: Continuity and Change
  8. The interest on partner's drawings is debited to __________________while charging interest on drawings on drawings made by the partner.Accountancy Part A · Accounting for Partnership
  9. Cost price of two articles is same. 1st is sold at 20% profit and 2nd is sold at 30% loss. Find overall profit or loss percentage in this t…General Aptitude Test · Numerical Ability
  10. In Selye's General Adaptation Syndrome, which of the following takes place during the resistance stage?Psychology · Meeting Life Challenges