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 the List-I with List-IIList-I(A) Depreciation using Straight Li…

Match the List-I with List-II

List-I

(A) Depreciation using Straight Line Method

(B) Depreciation using Written Down Value Method

(C) Computation of Installment of Loan

(D) Data Validation

List-II

(I) =PMT(rate, nper, pv, [fv], [type])

(II) =SLN(cost, salvage, life)

(III) Drop Down List

(IV) = DB(cost, salvage, life, period, [month])

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)

Spreadsheets carry built-in functions for common accounting work, and a separate feature to control what may be typed into a cell.

(A) Depreciation using Straight Line Method — this matches (II) =SLN(cost, salvage, life). SLN gives the same depreciation every year: (cost − salvage value) ÷ useful life.

(B) Depreciation using Written Down Value Method — this matches (IV) = DB(cost, salvage, life, period, [month]). DB is the declining balance method, which charges depreciation on the reduced book value each year; it needs the period for which depreciation is wanted.

(C) Computation of Installment of Loan — this matches (I) =PMT(rate, nper, pv, [fv], [type]). PMT returns the periodic instalment from the rate, the number of payments and the loan amount.

(D) Data Validation — this matches (III) Drop Down List. Data validation restricts what can be entered in a cell, and a drop-down list of allowed entries is one of its ways of doing this.

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. If x is real, then the minimum value of x^2-8x+25 isMaths. Section A · Applications of Derivatives
  2. If X is a Poisson variate such that P(X=3)=2P(X=4) , then P(X=2) equals:[given e^-2=0.14 ]Applied Maths. Section B2 · Probability Distributions
  3. Arrange the following aqueous solutions in increasing order of their boiling points.Given: Molar mass (in g mol−1) of H, C, N, O, S and K r…Chemistry · Physical: Solutions
  4. Which of the following practices is not suitable for organic farming?Environmental Studies
  5. Choose the most appropriate word to complete the following sentence.The management was kind enough to ________ to some of the demands of th…English · Homonyms
  6. Match the LIST-I with LIST-IILIST-ILIST-IIA. The degree of the differential equation ≤ft((d^3y)/(dx^3))^4+≤ft((d^2y)/(dx^2))^5+≤ft(displays…Maths. Section B1 · Differential Equations
  7. Iceland Country is an example of ________________?General Aptitude Test · General Knowledge
  8. Traces of ‘canals’ have been found at which Harappan site?History · Ancient India: Bricks, Beads and Bones
  9. The function f:R→ R is defined by f(x)=2x^3+5 , then which of the following statements are correct?(A) f(x) has no local maximum value.(B)…Maths. Section A · Applications of Derivatives
  10. Which project was completed under the supervision of Persian masters, Mir Sayyid Ali and Abd us Samad?Fine Arts · The Mughal School of Miniature Painting