Skip to main content
Super TutorResources
Chapter 6 of 14
Formula Sheet

Spreadsheet — Formula Sheet

Madhya Pradesh Board · Class 12 · Accountancy

15 formulas from Spreadsheet (Madhya Pradesh Board Class 12 Accountancy) on one page, grouped by topic. Covers Basic Concepts of Spreadsheet, Formula.

69 questions90 flashcards15 formulas & key relations5 concepts

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.

Try Super Tutor — Free

Free trial, no card needed.

15 Entries · 4 Sections

Formulas and Key Relations

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 All

Frequently Asked Questions

What are the important topics in Spreadsheet for Madhya Pradesh Board Class 12 Accountancy?
Key topics in Spreadsheet include Basic Concepts of Spreadsheet, Formula Writing, Functions, and Order of Operations, Useful Functions: Date, Text, Counting, and Rounding, Lookup Functions and Reference-Based Searching. Study these first, then practise questions on each for the Madhya Pradesh Board Class 12 board exam.
How many formulas are in Spreadsheet?
This sheet lists 15 formulas from Spreadsheet, grouped by topic. Learn what each symbol stands for so you can apply the formula, not just recall it.
How should I revise Spreadsheet for the Madhya Pradesh Board Class 12 board exam?
Learn the core ideas first, then work through the 69 practice questions on Spreadsheet. 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 Spreadsheet

All Madhya Pradesh Board Class 12 Accountancy Formula Sheet

For serious students

Get the full Spreadsheet 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