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 type of data should be maintained for salary bill preparation?

What type of data should be maintained for salary bill preparation?

Answer & explanation+

Correct answer: option 4

The correct answer is option 4- Employee number, name, attendance, basic pay, allowances, and deductions.

Employee number, name, attendance, basic pay, allowances, and deductions type of data should be maintained for salary bill preparation.

Every employee is paid salary on a pre-determined date within the framework of employee contract and related personnel policy in force from time to time in an organisation. The computation of salary payment is based on the number of days an employee has worked, rate per grade of pay, rate of applied allowances and deductions to be made therefrom. The preparation of salary bill should provide for the following :

• Maintaining payroll related data such as Employee No., Name, Attendance, Basic Pay, applicable Dearness and other Allowances, deductions to be made.

• Periodic payroll computations: the payroll computation includes the calculation of various earning and deduction heads, which are to be derived from basic values (such as basic salary, number of days under leave without pay (LWP) and unauthorised absence, etc) as per the formulae.

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 “The Loneliness of Sonia and Sunny", a Booker Prize 2025 Shortlisted Novel?General Aptitude Test · Current Affairs
  2. Which of the following statement (s) is/are correct in the context of partition of India?History · Modern India: Understanding Partition
  3. If A= […] and B'= […] , then (A+2B)'=Applied Maths. Section B2 · Algebra
  4. If A= […] ,B= […] thenMaths. Section A · Matrices
  5. Which US President proposed “Atoms for Peace”?Political Science · Contemporary World Politics: International Organisations
  6. Indian writing in English was condemned as unpatriotic with the saying _________.English · Comprehension - (Narrative / Factual)
  7. Fill in the blank with the appropriate preposition: When I was a small boy ____ Bali, the school picnic was one of the major events ____ th…English · Grammar: Preposition
  8. In a certain experiment, the photoelectric cut-off voltage is 3.5 V. What will be the maximum kinetic energy of the photoelectrons emitted?Physics · Dual Nature of Radiation and Matter
  9. On selling 18 balls at Rs. 720, there is a loss equal to the cost price of 5 balls. The cost price of a ball is?General Aptitude Test · Numerical Ability
  10. Which of the following words is different in meaning from the other three?English · Odd One Out