Skip to main content
Super TutorResources
Chapter 9 of 14
Syllabus

Use of Spreadsheet in Business Applications — Syllabus

Madhya Pradesh Board · Class 12 · Accountancy

What Use of Spreadsheet in Business Applications covers in Madhya Pradesh Board Class 12 Accountancy: 3 topics, for the 2026-27 session.

80 questions80 flashcards12 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 syllabus and more.

Try Super Tutor — Free

Free trial, no card needed.

3 Topics · Madhya Pradesh Board Class 12 Accountancy · 2026-27

Topics in Use of Spreadsheet in Business Applications

1

1. Payroll Accounting

  • Salary is computed from attendance, basic pay, allowances, and deductions.
  • Payroll data includes employee number, name, type, attendance, basic pay, allowances, deductions, and net salary.
  • Basic Pay Earned depends on the number of effective days present in the month.
2

2. Asset Accounting and Depreciation

  • Fixed assets are long-term assets that provide productive capability to a firm.
  • Fixed assets can be tangible or intangible.
  • Tangible assets are physical in nature; intangible assets do not have a physical dimension.
3

3. Loan Repayment Schedule

  • A loan is borrowed money, called principal amount, for a specified period at a pre-specified rate of interest.
  • Loan repayment is generally done through periodic instalments, usually monthly.
  • Excel PMT is used to compute repayment instalments.

Key Concepts

Central concept: Spreadsheet applications in payroll accounting, asset accounting, and loan repayment

Payroll AccountingAsset AccountingLoan Repayment ScheduleSpreadsheet FunctionsAddressing in FormulasExample Business Entities

Work through every topic in Use of Spreadsheet in Business Applications with notes and quizzes

Start This Chapter

Frequently Asked Questions

What are the important topics in Use of Spreadsheet in Business Applications for Madhya Pradesh Board Class 12 Accountancy?
Key topics in Use of Spreadsheet in Business Applications include Payroll Accounting, Asset Accounting and Depreciation, Loan Repayment Schedule. Study these first, then practise questions on each for the Madhya Pradesh Board Class 12 board exam.
How should I revise Use of Spreadsheet in Business Applications for the Madhya Pradesh Board Class 12 board exam?
Learn the core ideas first, then work through the 80 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.

More resources for Use of Spreadsheet in Business Applications

All Madhya Pradesh Board Class 12 Accountancy Syllabus

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 Madhya Pradesh Board Class 12 Accountancy. Free to start, no card needed.

Try Super Tutor Free
Try this chapter free