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

What category of functions is used in this formula: =PMT(C10/12,C8,C9…

What category of functions is used in this formula: =PMT(C10/12,C8,C9,1)?

Answer & explanation+

Correct answer: option 2

The correct answer is Option (2) → Financial

PMT works out the periodic payment on a loan or annuity from the rate, the number of periods and the present value, so it belongs to Excel's Financial category. "Payment" is what PMT stands for, not a category of functions.

NCERT (2026-27 edition):
Use of Spreadsheet in Business Applications

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. Arrange the following in the decreasing order of their band gap energy.(A) Carbon (diamond)(B) Germanium(C) Metal(D) SiliconChoose the corr…Physics · Semiconductors and Electronic Devices
  2. What was the time duration of framing of the Constitution of India?History · Modern India: Framing the Constitution
  3. Which of the following schools of thought laid emphasis on perception of space by social categories?Geography · Fundamentals of Human Geography: Human Geography-Nature and Scope
  4. If the function f(x) defined by f(x)=x^3-3x+100,(x∈R) , (Where R is set of real numbers), then f(x) hasApplied Maths. Section A · Applications of Derivatives (Section A)
  5. After Green Revolution, as technology spread, a service-caste blacksmith in Punjab lost work because most farmers started using factory-mad…Sociology · Social Change and Development in India: Change and Development in Rural Society
  6. Choose the correct antonym of the following word: ADVERSITYEnglish · Antonyms
  7. Vansh, Ansh and Saransh are partners and on 31st March 2025, they decided to dissolve the firm and Vansh was appointed to look after the di…Accountancy Part A · Dissolution of Partnership Firm
  8. Match the LIST-I with LIST-IILIST-I(Traditional security measures)LIST-II(Meaning)A. Confidence buildingI. Regulating the acquisition or de…Political Science · Contemporary World Politics: Security in the Contemporary World
  9. Which of the following is NOT true about Gross National Happiness (GNH)?Geography · Fundamentals of Human Geography: Human Development
  10. The area of the region bounded by the curve y=√(9-x^2) and x -axis isMaths. Section B1 · Application of Integrals