Skip to main content
Super TutorResources
Chapter 9 of 14
QuestionsNotesFlashcardsSummaryFormulasQuizConceptsSyllabusPlan
Revision Notes

Use of Spreadsheet in Business Applications

CBSE · Class 12 · Accountancy

Quick revision notes for Use of Spreadsheet in Business Applications — CBSE Class 12 Accountancy. Key concepts, formulas, and definitions for last-minute revision.

80 questions80 flashcards5 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 revision notes and more.

Try Super Tutor — Free

1,000+ Class 12 students started this chapter today

Key Topics to Revise

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.

Get complete notes with diagrams and examples

Full Notes

Key Concepts

Basic Pay is the payBasic Pay Earned is calculatedTotal Earnings is the sumDA is 35% of Basic PayProvident Fund is a statutory deduction

Frequently Asked Questions

What are the important topics in Use of Spreadsheet in Business Applications for CBSE Class 12 Accountancy?
Use of Spreadsheet in Business Applications covers several key topics that are frequently asked in CBSE Class 12 board exams. Focus on the core concepts listed on this page and practise related questions to build confidence.
How to score full marks in Use of Spreadsheet in Business Applications — CBSE Class 12 Accountancy?
Understand the core concepts first, then work through the 80 practice questions available for this chapter. Revise formulas and 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 14 chapters — CBSE Class 12 Accountancy Revision Notes

For serious students

Get the full Use of Spreadsheet in Business Applications chapter — for free.

Quizzes, flashcards, AI doubt-solver and a step-by-step study plan for CBSE Class 12 Accountancy.

Try Super Tutor Free
Try the full chapter — Free