Skip to main content
Chapter 36 of 38
Chapter Summary

Use Of Spreadsheet In Business Applications — Chapter Summary

NIOS · Class 12 · Accountancy

Summary of Use Of Spreadsheet In Business Applications for NIOS Class 12 Accountancy. Part of the NIOS Class 12 Accountancy syllabus.

87 questions38 flashcards7 formulas & key relations5 concepts

Interactive on Super Tutor

Studying Use Of Spreadsheet In Business Applications? Get the full interactive chapter.

Quizzes, flashcards, AI doubt-solver and a step-by-step study plan — built for chapter summary and more.

Free trial, no card needed.

Overview

Notice how a spreadsheet helps organize two major business tasks in accounting: payroll accounting and depreciation accounting. It brings formulas, calculations, and records into one system, so salary details and asset values can be handled more quickly and more accurately. Count the main ideas care

Key Concepts

Use of computers for maintaining

Use of computers for maintaining the records salary of employees is known as payroll accounting. Payroll is an accounting statement that shows the sal

Earnings include Basic Pay

Earnings include Basic Pay, Grade Pay, Dearness Pay, Dearness Allowance, House Rent Allowance, Transport Allowance, and any other earning. Deductions

Basic Pay Earned is the Basic

Basic Pay Earned is the Basic Pay calculated with reference to Number of Effective Days Present during the month. The formula is BPE = BP × NOEDP/NODM

Gross salary consists of Basic Pay

Gross salary consists of Basic Pay and various allowances. Net salary is the difference between gross salary and deductions.

DA = BPE × Rate

DA = BPE × Rate of DA, HRA = BPE × Rate of HRA, TRA may be fixed or percentage based, TE = BPE + DA + HRA + TRA, PF = BPE × PF Rate, TD = PF + TDS + L

Learning Objectives

  • State the meaning of payroll accounting
  • Explain the components of payroll
  • State the meaning of depreciation
  • Explain the methods of depreciation
  • Compute annual depreciation with the help of a computer

Frequently Asked Questions

What are the important topics in Use Of Spreadsheet In Business Applications for NIOS Class 12 Accountancy?
Key topics in Use Of Spreadsheet In Business Applications include Payroll Accounting, Payroll Components, Payroll Calculation Elements, Depreciation. Study these first, then practise questions on each for the NIOS Class 12 board exam.
How should I revise Use Of Spreadsheet In Business Applications for the NIOS Class 12 board exam?
Learn the core ideas first, then work through the 87 practice questions on Use Of Spreadsheet In Business Applications. Revise definitions regularly and use flashcards for quick recall before the exam.

Sources & Official References

Content is aligned to the official syllabus. Refer to the board website for the latest curriculum.

For serious students

Get the full Use Of Spreadsheet In Business Applications chapter — start free.

Quizzes, flashcards, an AI doubt solver and a study plan for NIOS Class 12 Accountancy. Free to start, no card needed.