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-II.List-IList-II(A)Depreciation using Straight…

Match List-I with List-II.

List-IList-II
(A)Depreciation using Straight Line Method(I)=PMT(Rate, Nper, Pv, Fv, Type)
(B)Depreciation using Written Down Value Method(II)=SLN(cost, salvage, life)
(C)Computation of Installment of Loan(III)Use Drop Down List
(D)Data Validation(IV)= DB(Cost, Salvage, Life, Period, Month)

Choose the correct answer from the options given below:

Answer & explanation+

Correct answer: option 1

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

(A) Depreciation using Straight Line Method — this matches (II) =SLN(cost, salvage, life). SLN gives the same depreciation for every period.

(B) Depreciation using Written Down Value Method — this matches (IV) = DB(Cost, Salvage, Life, Period, Month). DB charges depreciation on the declining balance, which is the written down value method.

(C) Computation of Installment of Loan — this matches (I) =PMT(Rate, Nper, Pv, Fv, Type). PMT works out the periodic payment on a loan.

(D) Data Validation — this matches (III) Use Drop Down List. Validation limits what may be entered in a cell, and a drop-down list offers only the allowed entries.

NCERT (2026-27 edition):
Summary – “… • The Excel functions SLN and DB are used for computation of depreciation using Straight Line Method (SLM) and Written Down Value Method (WDVM), respectively. WDV Method is also termed as declining balance (DB) method. • The function PMT is used to compute the loan repayment schedule.”

NCERT (2026-27 edition):
Data Validation

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. Which social group is the subject of concern to the speaker?History · Modern India: Framing the Constitution
  2. Fill in the blanks with the suitable word from the options given below:__________ much I tried, I couldn't help her.English · Grammar: Conjunction
  3. At maturity, a typical angiosperm embryo sac is:Biology · Sexual Reproduction in Flowering Plants
  4. What does not pertain to India’s Second Five-Year Plan?Political Science · Politics in India Since Independence: Politics of Planned Development
  5. The new partner is required to compensate the old partners for their loss of share in the super profits of the firm for which he brings in…Accountancy Part A · Admission of a Partner
  6. ABC Ltd. has a partnership deed as per which interest on drawing is to be charged @ 9% p.a and the total interest on drawings of Aman (part…Accountancy Part A · Accounting for Partnership
  7. Match the LIST-I with LIST-IILIST-I(Types of port)LIST-II(Example)A.Ports of CallI.RotterdamB.Packet StationII.KarwarC.Entrepot PortsIII.Ad…Geography · Fundamentals of Human Geography: International Trade
  8. If A= […] , then A^2-5A is equal to : (where I_2 is identity matrix of order 2)Applied Maths. Section A · Matrices (Section A)
  9. “No fixed geographical location” is NOT a distinctive feature of:Business Studies · Financial Markets
  10. The remark of George B. Cressey about the population of Asia that “Asia has many places where people are few and few places where people ar…Geography · Fundamentals of Human Geography: World Population-Distribution, Density and growth