Skip to main content
Super TutorResources
Chapter 9 of 14
QuestionsNotesFlashcardsSummaryFormulasQuizConceptsSyllabusPlan
Chapter Summary

Use of Spreadsheet in Business Applications

CBSE · Class 12 · Accountancy

Summary of Use of Spreadsheet in Business Applications for CBSE Class 12 Accountancy. Key concepts, important points, and chapter overview.

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 chapter summary and more.

Try Super Tutor — Free

1,000+ Class 12 students started this chapter today

Overview

Spreadsheet software is used in business for payroll accounting, asset depreciation, and loan repayment schedules. It helps in organizing data, applying formulas, and producing accurate calculations quickly. The main strength of spreadsheet work is that one formula can be copied across many rows usi

Key Concepts

Basic Pay is the pay

Basic Pay is the pay in the pay scale plus Grade Pay, but it does not include Special Pay. Payroll also includes Grade Pay, Dearness Pay, Dearness All

Basic Pay Earned is calculated

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

Total Earnings is the sum

Total Earnings is the sum of BPE, DA, HRA, and TRA. Total Deductions is the sum of PF, TDS, and LOAN. Net Salary is Total Earnings minus Total Deducti

DA is 35% of Basic Pay

DA is 35% of Basic Pay. HRA is 40% for Supervisory employees and 30% for Non-supervisory employees. TRA is 1000 for Supervisory employees and 500 for

Provident Fund is a statutory deduction

Provident Fund is a statutory deduction under the Provident Fund Act and is calculated as 12% of BPE in the example. TDS is deducted monthly toward In

Learning Objectives

  • Compute employee gross salary and net salary using spreadsheet formulas
  • Apply payroll rules for earnings and deductions such as DA, HRA, TRA, PF, TDS, and loan instalments
  • Calculate depreciation of fixed assets by Straight Line Method and Written Down Value Method
  • Use Excel functions SLN, DB, and PMT for business calculations
  • Prepare schedules for payroll, fixed assets, and loan repayment using spreadsheet templates

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 Chapter Summary

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