Chapter 35 of 38
Revision Notes
Electronic Spread Sheet — Revision Notes
NIOS · Class 12 · Accountancy
Electronic Spread Sheet revision notes for NIOS Class 12 Accountancy: 4 topics in quick points. Part of the NIOS Class 12 Accountancy syllabus.
89 questions40 flashcards5 concepts
Interactive on Super Tutor
Studying Electronic Spread Sheet? Get the full interactive chapter.
Quizzes, flashcards, AI doubt-solver and a step-by-step study plan — built for revision notes and more.
Free trial, no card needed.
Key Topics to Revise
1
Meaning and Basic Features of Electronic Spreadsheet
- Electronic Spreadsheet is a combination of rows and columns.
- It is also known as a worksheet.
- It is used for calculations and comparison of numerical or financial data.
2
Spreadsheet Grid, Cell Pointer, Data Entry and Auto Fill
- A spreadsheet is seen as a grid structured by rows and columns.
- Rows are numbered 1, 2, 3, and so on.
- Columns are identified by letters.
3
Formulas, Functions and Formula Elements
- A formula is a set of mathematical instructions used in Excel to perform calculations.
- Formulas always start with an = sign in the formula box.
- The elements of an Excel formula are references, operators, constants, and functions.
4
Relative, Absolute and Mixed Referencing
- Calling cells by just their column and row labels, such as A1, is called relative referencing.
- Relative references change when a formula is copied to another cell.
- If the formula in C1 is =(A1+B1), then copying it to C2 changes it to =(A2+B2).
Get complete notes with diagrams and examples
Full NotesKey Concepts
Computerised Accounting System has five pillarsAn electronic spreadsheet is a computerA workbook is a multipage documentA cell is the point whereEach row is given a number
Frequently Asked Questions
What are the important topics in Electronic Spread Sheet for NIOS Class 12 Accountancy?
Key topics in Electronic Spread Sheet include Meaning and Basic Features of Electronic Spreadsheet, Spreadsheet Grid, Cell Pointer, Data Entry and Auto Fill, Formulas, Functions and Formula Elements, Relative, Absolute and Mixed Referencing. Study these first, then practise questions on each for the NIOS Class 12 board exam.
How should I revise Electronic Spread Sheet for the NIOS Class 12 board exam?
Learn the core ideas first, then work through the 89 practice questions on Electronic Spread Sheet. 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 Electronic Spread Sheet
For serious students
Get the full Electronic Spread Sheet chapter — start free.
Quizzes, flashcards, an AI doubt solver and a study plan for NIOS Class 12 Accountancy. Free to start, no card needed.