Spreadsheet
CBSE · Class 12 · Accountancy
All formulas from Spreadsheet in CBSE Class 12 Accountancy. Key equations, constants, and identities for board exam preparation.
Interactive on Super Tutor
Studying Spreadsheet? Get the full interactive chapter.
Quizzes, flashcards, AI doubt-solver and a step-by-step study plan — built for formula sheet and more.
1,000+ Class 12 students started this chapter today
Formulas
Core Spreadsheet Concepts
V = Q × P
MA = PA * (1 + R / (100 * CP)) ^ (R * CP)
CI = MA - PA
Data types: 306 = Numeric, Asset = alpha-numeric, 12/07/08 = Date
Cell References and Navigation
Relative reference
Absolute reference
Mixed reference
A1: E2
Order of Operations and Formula Rules
Order of operations: brackets, exponents, multiplication/division left to right, addition/subtraction left to right
= D1+E1/F1*G1
Functions and Common Excel Functions
=FunctionName(Data)
SUMIF (range, criteria, sum_range)
IF (logical_test, value_if_ture, value_if_false)
VLOOKUP (lookup_value, table_array, col_index_num, range_lookup)
HLOOKUP(lookup_value, table_array, row_index_num, range_lookup)
Full sheet with units and worked examples
View AllFrequently Asked Questions
What are the important topics in Spreadsheet for CBSE Class 12 Accountancy?
How to score full marks in Spreadsheet — CBSE Class 12 Accountancy?
Sources & Official References
- NCERT Official — ncert.nic.in
- CBSE Academic — cbseacademic.nic.in
- CBSE Official — cbse.gov.in
- National Education Policy 2020 — education.gov.in
Content is aligned to the official syllabus. Refer to the board website for the latest curriculum.
More resources for Spreadsheet
Practice Quiz
Test yourself with a quick quiz
Important Questions
Practice with board exam-style questions
Revision Notes
Key points for last-minute revision
Chapter Summary
Understand the chapter at a glance
Concept Maps
See how topics connect visually
Study Plan
Step-by-step plan to ace this chapter
Flashcards
Quick-fire cards for active recall
Syllabus
What topics to cover
NCERT Solutions
Every textbook question solved step by step
For serious students
Get the full Spreadsheet chapter — for free.
Quizzes, flashcards, AI doubt-solver and a step-by-step study plan for CBSE Class 12 Accountancy.