Skip to main content
Super TutorResources
Chapter 6 of 14
Syllabus

Spreadsheet — Syllabus

Madhya Pradesh Board · Class 12 · Accountancy

What Spreadsheet covers in Madhya Pradesh Board Class 12 Accountancy: 4 topics, for the 2026-27 session. Topics include Basic Concepts of Spreadsheet.

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 syllabus and more.

Try Super Tutor — Free

Free trial, no card needed.

4 Topics · Madhya Pradesh Board Class 12 Accountancy · 2026-27

Topics in Spreadsheet

1

1. Basic Concepts of Spreadsheet

  • A workbook is a file in Excel and contains multiple worksheets.
  • By default, a workbook has three sheets: Sheet 1, Sheet 2, and Sheet 3.
  • Only one worksheet can be active at a time.
2

2. Formula Writing, Functions, and Order of Operations

  • Formulas must begin with an equal to sign.
  • A formula may contain cell references and functions.
  • The order of mathematical operations follows brackets, exponents, multiplication/division from left to right, then addition/subtraction from left to right.
3

3. Useful Functions: Date, Text, Counting, and Rounding

  • TODAY() returns the serial number of the current date.
  • January 1, 1900 is serial number 1.
  • NOW() returns the serial number of the current date and time.
4

4. Lookup Functions and Reference-Based Searching

  • LOOKUP returns a value from a one-row or one-column range or from an array.
  • LOOKUP has vector form and array form.
  • Vector form searches one row or one column and returns a value from the same position in a second range.

Key Concepts

Central concept: Spreadsheet as a grid-based tool for recording, calculating, analysing, and presenting data in workbook worksheets

WorkbookWorksheetCellCell referenceValues and labelsBasic and derived valuesFormulasFunctions

Work through every topic in Spreadsheet with notes and quizzes

Start This Chapter

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 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 Syllabus

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