Skip to main content
Super TutorResources
Chapter 9 of 14
QuestionsNotesFlashcardsSummaryFormulasQuizConceptsSyllabusPlan
Formula Sheet

Use of Spreadsheet in Business Applications

CBSE · Class 12 · Accountancy

All formulas from Use of Spreadsheet in Business Applications in CBSE Class 12 Accountancy. Key equations, constants, and identities for board exam preparation.

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 formula sheet and more.

Try Super Tutor — Free

1,000+ Class 12 students started this chapter today

12 Formulas · 3 Sections

Formulas

Payroll Accounting

BPE = BP * NOEDP/NODM

NOEDP = (Number of Days in a Month) – (Leave without Pay) – (Unauthorised Absence)

DA = BPE * (Applicable Rate of DA for the Month)

HRA = BPE * (Applicable Rate of HRA for the Month)

TRA = (Fixed Amount) or (On Percentage Basis)

Asset Accounting and Depreciation

Total Amount of Depreciation = Acquisition Cost – Salvage Value

Straight Line Depreciation = Total Depreciable Amount / Expected Useful Life

Rate of Depreciation = (Straight Line Depreciation / Total Depreciable Amount) x 100

SLN function

DB function

Loan Repayment Schedule

Yearly Installment Amt. = PMT(D6,C6,-A6,0,1)

Monthly Installment Amt. = F6/12

Full sheet with units and worked examples

View All

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 Formula Sheet

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