Skip to main content
Super TutorResources
Chapter 6 of 14
QuestionsNotesFlashcardsSummaryFormulasQuizConceptsSyllabusPlan
Revision Notes

Spreadsheet

CBSE · Class 12 · Accountancy

Quick revision notes for Spreadsheet — CBSE Class 12 Accountancy. Key concepts, formulas, and definitions for last-minute revision.

69 questions90 flashcards5 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 revision notes and more.

Try Super Tutor — Free

1,000+ Class 12 students started this chapter today

Key Topics to Revise

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.

Get complete notes with diagrams and examples

Full Notes

Key Concepts

A workbook is an Excel fileA cell is the intersectionA cell reference identifies the locationA formula is a mathematical calculationA function is a special keyword

Frequently Asked Questions

What are the important topics in Spreadsheet for CBSE Class 12 Accountancy?
Spreadsheet 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 Spreadsheet — CBSE Class 12 Accountancy?
Understand the core concepts first, then work through the 69 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 Spreadsheet

All 14 chapters — CBSE Class 12 Accountancy Revision Notes

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.

Try Super Tutor Free
Try the full chapter — Free