AccountsISC Class 12 · Accounting Application of Electronic Spread Sheet

Electronic Spreadsheet: Concept, Features and Formatting for ISC Class 12 Accounts

Updated 17 October 2026 · Draft, not yet fact-checked

An electronic spreadsheet is application software that arranges data in rows and columns of cells so that calculations, analysis and presentation can be done quickly and updated automatically when data changes. A file is a workbook made of worksheets; a cell is named by its column and row (for example B2) and a range by its corners (for example B1:G10).

A cell is named by column letter then row number (D3); a range joins two corners (B1:D2); a workbook holds worksheets.

Illustration drawn for QuestionBuddy.

Understand Electronic Spreadsheet: Concept, Features, Formatting and Printing

Meaning and utility. An electronic spreadsheet is a computer program that holds data in a grid of rows (numbered) and columns (lettered). The intersection of a row and a column is a cell, named by column letter and row number such as B2. A range is a block of cells named by its first and last corner, such as B1:G10. A file is a workbook, which holds one or more worksheets. Because formulas refer to cells, results update when the data changes. Familiar examples are Microsoft Excel, Google Sheets and Zoho Sheet.

Merits. Speed and accuracy of calculation; automatic recalculation; ready functions; neat formatting; charts and sorting built in; easy storage and sharing.
Demerits. Errors in formulas can go unnoticed; limited security; not suited for very large or multi-user databases; needs a computer and some skill; data entry mistakes still occur.

Data types. Text (labels and headings), numbers, dates, and alphanumeric values (for example an invoice number such as INV101). Text aligns left by default and numbers align right.

Working with the file. Create a new workbook, enter headings and data, save with a name and quit; open an existing workbook and move around with the mouse, arrow keys, the Name box or shortcuts such as Ctrl+Home (go to A1). Toolbars and menus give the commands. Common keyboard shortcuts: Ctrl+C copy, Ctrl+X cut, Ctrl+V paste, Ctrl+Z undo, Ctrl+S save, Ctrl+P print.

Single and multiple workbooks. Within a workbook you can add, delete, rename, move or copy a worksheet. Between workbooks you can copy or move entries or whole sheets. Imported data can come from other files (Data menu); exporting is done from the File menu.

Formatting a worksheet. AutoFormat (ready-made table styles), changing alignment (left, centre, right, merge and centre), character styles (bold, italics, underline, font size), column width and row height, date format, borders and colours.

Previewing and printing. Use print preview to check the output. Page setup includes orientation, margins, print titles (repeating heading rows on every page), page breaks, and headers and footers.

Freeze Panes. This tool locks chosen rows and/or columns, usually the headings, so that they stay on screen while you scroll through the rest of the sheet. Select the cell below the rows and to the right of the columns you want to keep, then freeze.

Error values. #DIV/0! (division by zero); #NAME? (unrecognised function or name); #VALUE! (wrong type of data); #REF! (invalid cell reference); #NUM! (invalid number); #NULL! (incorrect range operator, such as a space between ranges that do not intersect).

Cell references. A relative reference (B2) changes when the formula is copied; an absolute reference (typed with a dollar sign before the column letter and another before the row number, or made by pressing F4) does not change. Use absolute references for fixed values such as a tax rate. Functions and accounting applications come in the next topic page.

Electronic Spreadsheet: Concept, Features, Formatting and Printing: key facts

Cell and range: Column letter + Row number
for example B2
Range: first cell:last cell
for example B1:G10; Cell address notation.
Number of cells in a range: Number of columns | multiplied by Number of rows; B1:G10 has 6 × 10 = 60 cells.
Relative and absolute reference: B2 changes when copied | B2 made absolute with dollar signs does not change; A mixed reference fixes only the row or only the column.
Common error values: #DIV/0! division by zero
#NAME? unknown name
#VALUE! wrong data type
#REF! invalid reference
#NUM! invalid number
#NULL! wrong range operator; Standard spreadsheet errors.

How to answer Electronic Spreadsheet: Concept, Features, Formatting and Printing questions

Most questions here are short theory or tool-based, so answer in precise terms.

1Name the tool or feature exactly (for example Freeze Panes, Print Titles).
2Give its use in one sentence and, if asked, the way to apply it.
3For ranges, count columns times rows.
4For errors, name the error and its cause.
5For formulas copied across cells, decide which references are relative and which are absolute.

Electronic Spreadsheet: Concept, Features, Formatting and Printing in real life

The idea, met in an everyday situation. Answer the question in your own words, then compare with the model answer. The one-line hook is what to remember.

Keeping headings in view

Suppose a school clerk keeps a sheet of 300 student records with headings in row 1 and names in column A. When she scrolls down to row 250, the headings disappear and she cannot tell which column holds fees.

Which spreadsheet feature solves this and which cell should she select?

Try it first, then show the solutionSolution

She needs row 1 and column A to remain visible.
Select cell B2, the cell just below the heading row and to the right of the name column.
Apply Freeze Panes.

Answer: Freeze Panes, with cell B2 selected, keeps row 1 and column A fixed while the rest scrolls.

Memory hook: Select below and right, then freeze.

Tricks to remember Electronic Spreadsheet: Concept, Features, Formatting and Printing

Short memory aids. Say each one aloud once, then use it on a question the same day.

Columns × rows
Cells in a range = number of columns times number of rows.
Use it when: Counting cells.
Dollar locks
A dollar sign locks the column letter or row number that follows it.
Use it when: Absolute references.
N-V-R-D-N-N
#NAME, #VALUE, #REF, #DIV/0, #NUM, #NULL: six error values.
Use it when: Recalling errors.

Electronic Spreadsheet: Concept, Features, Formatting and Printing: solved examples

Ordered from board level to HOTS. Try each one before you open the solution.

Example 1: Counting cells in a range · 1 mark · MCQBoard level

The number of cells in the range C3:F8 is:
(a) 18
(b) 24
(c) 20
(d) 30

Try it first, then show the solutionSolution

Columns C to F: 4 columns. Rows 3 to 8: 6 rows.
4 × 6 = 24.

Answer: (b) 24

Example 2: Merits and demerits · 3 marks · Short answerBoard level

State any two merits and two demerits of an electronic spreadsheet. (3 marks)

Try it first, then show the solutionSolution

Merits: it recalculates automatically when data changes; it provides ready functions, charts and sorting.
Demerits: a wrong formula can give wrong results unnoticed; it is not suited to very large or multi-user databases.

Answer: Merits: automatic recalculation; built-in functions and charts. Demerits: formula errors can go unnoticed; unsuitable for large multi-user data.

Example 3: Relative and absolute references · 3 marks · Short answerHarder board level

In a sheet, B2:B5 hold quantities 10, 20, 15, 5 and C2:C5 hold rates 50, 40, 60, 100. Cell F1 holds the discount rate 10%. D2 contains =B2*C2 and E2 contains =D2*F1 with F1 made an absolute reference (dollar signs before F and before 1); both are filled down to row 5. State the formula in E4 and the values in D2:D5 and E2:E5. (3 marks)

Try it first, then show the solutionSolution

D2:D5 = 10×50, 20×40, 15×60, 5×100 = 500, 800, 900, 500.
The relative reference D2 moves to D4 in E4, but the absolute reference F1 stays fixed: E4 = =D4*F1 (with F1 locked).
E2:E5 = 10% of D: 50, 80, 90, 50.

Answer: E4 contains =D4*F1 with F1 locked. D2:D5 = 500, 800, 900, 500; E2:E5 = 50, 80, 90, 50.

Example 4: Diagnosing error values · 6 marks · Long answerHarder board level

Explain the error shown by each formula, with the corrective action: E2 =SUM(B2 C2) shows #NULL!; E3 =B3/C3 where C3 holds 0 shows #DIV/0!; E4 =SQRT(-9) shows #NUM!; E5 =SUMM(B2:B5) shows #NAME?; E6 =B2+"abc" shows #VALUE!; E7 refers to a deleted sheet and shows #REF!. (6 marks)

Try it first, then show the solutionSolution

#NULL!: the space is an intersection operator and B2, C2 do not intersect; use a comma or colon.
#DIV/0!: the divisor is zero; correct C3 or test it with IF.
#NUM!: square root of a negative number; supply a non-negative value.
#NAME?: the function name is misspelt; write SUM.
#VALUE!: text added to a number; use a numeric cell.
#REF!: the referenced cell is gone; point the formula to an existing cell.

Answer:

Cell	Formula entered	Result	Reason
E2	=SUM(B2 C2)	#NULL!	A space is the intersection operator; B2 and C2 do not intersect
E3	=B3/C3 (C3 holds 0)	#DIV/0!	Division by zero
E4	=SQRT(-9)	#NUM!	Invalid number for the function
E5	=SUMM(B2:B5)	#NAME?	Function name not recognised
E6	=B2+"abc"	#VALUE!	Text used where a number is needed
E7	=Sheet2!A1 after Sheet2 is deleted	#REF!	The referenced cell no longer exists

Example 5: Which panes freeze? · 3 marks · Short answerHOTS / competency

A payroll sheet has headings in rows 1 and 2 and employee codes in columns A and B. A clerk selects cell C3 and chooses Freeze Panes. Which rows and columns stay fixed? She then wants the heading rows to repeat on every printed page. Name the print setting. (3 marks)

Try it first, then show the solutionSolution

Freeze Panes locks everything above and to the left of the selected cell: rows 1 and 2, columns A and B.
Freezing is a screen feature and does not affect printing.
For printing, set Print Titles (rows to repeat at top) in Page Setup.

Answer: Rows 1-2 and columns A-B stay fixed. Use Print Titles in Page Setup to repeat headings on each printed page.

Where students lose marks in Electronic Spreadsheet: Concept, Features, Formatting and Printing

The slips examiners see most often, and what to write instead.

Mistake: Counting only columns or rows
Forgetting that a range is two-dimensional.
Wrong working
C3:F8 has 6 cells
Right working
4 × 6 = 24 cells
Do this: Multiply columns by rows.
Usually costs: 1 mark.
Mistake: Not locking the cell of a fixed rate
Copying a formula with a relative rate cell.
Wrong working
=D2*F1 filled down gives F2, F3 ...
Right working
=D2*F1 with F1 made absolute
Do this: Fix any cell that must not move.
Usually costs: 1-2 marks.
Mistake: Confusing #NAME? with #VALUE!
Both involve wrong input.
Wrong working
=SUMM(B2:B5) gives #VALUE!
Right working
It gives #NAME? as the function is unknown
Do this: #NAME? is about names; #VALUE! is about data types.
Usually costs: 1 mark.
Mistake: Saying Freeze Panes repeats headings in print
Treating screen and print features alike.
Wrong working
Freeze Panes repeats headings on printed pages
Right working
Print Titles repeat headings on printed pages
Do this: Freeze Panes is for the screen only.
Usually costs: 1 mark.

Exam tips

Write full names of features (Print Titles, Freeze Panes, Page Break).
Use cell addresses in capitals and show formulas starting with =.
Give a short use for every tool you name.
For merits and demerits, give distinct points, not reworded ones.

Practice questions on Electronic Spreadsheet: Concept, Features, Formatting and Printing

Write each answer on paper first. Open the hint only if you are stuck, and the answer only when you have finished.

Q1 · 1 mark · MCQBoard level
In B1:G10, B1 and G10 are:
(a) the first and last cells of the range
(b) two separate cells
(c) two worksheets
(d) two workbooks
Hint
The colon joins corners.
Answer
(a) the first and last cells of the range
Q2 · 3 marks · Short answerBoard level
Name the feature of a spreadsheet and state its use: (i) a tool that keeps headings visible while scrolling; (ii) a setting that repeats headings on every printed page; (iii) a command that changes how a date is shown. (3 marks)
Hint
Screen, print, format.
Answer
(i) Freeze Panes: locks rows/columns on screen. (ii) Print Titles in Page Setup: repeats heading rows on each page. (iii) Date format (Format Cells): changes the display of a date without changing its value.
Q3 · 3 marks · Short answerHarder board level
B2:B4 hold quantities 12, 8, 25 and C2:C4 hold prices 40, 150, 20. D2 has =B2*C2, filled down; G1 holds the tax rate 5%; E2 has =D2*G1 with G1 made an absolute reference, filled down. Give the values of D2:D4, E2:E4 and the sum of D2:D4. (3 marks)
Hint
The locked rate cell never changes.
Answer
D2:D4 = 480, 1,200, 500; E2:E4 = 24, 60, 25; sum of D2:D4 = ₹2,180.
Q4 · 6 marks · Long answerHarder board level
State the cause and remedy for each: (i) #DIV/0!; (ii) #NAME?; (iii) #REF!; (iv) #VALUE!; (v) #NUM!; (vi) #NULL!. (6 marks)
Hint
One line each.
Answer
(i) Divisor zero: change divisor or test with IF. (ii) Unknown function or name: correct the spelling. (iii) Invalid reference: restore or re-point the reference. (iv) Wrong data type: use numbers. (v) Invalid number: correct the argument. (vi) Wrong range operator: use a colon or comma.
Q5 · 3 marks · Short answerHOTS / competency
A sheet has headings in row 1 and item codes in column A, and 80 items. A student wants the headings and codes always visible. She selects A2 and applies Freeze Panes, but the codes still scroll away. Explain the mistake and the correct cell. (3 marks)
Hint
Which cell sits below and to the right?
Answer
Selecting A2 freezes only row 1, since nothing lies to the left of column A. The correct cell is B2, which freezes row 1 and column A.

Test your recall

Answer in your head or on paper first, then open the card. Pulling an answer out of memory makes it stick far better than re-reading.

1.Cells in range B1:G10?Show answer
6 × 10 = 60.
2.What does #DIV/0! mean?Show answer
Division by zero.
3.Which reference does not change on copying?Show answer
Absolute, locked with dollar signs (F4).
4.Which setting repeats headings on printed pages?Show answer
Print Titles.
5.What does Freeze Panes do?Show answer
Locks rows or columns on screen while scrolling.

Electronic Spreadsheet: Concept, Features, Formatting and Printing: frequently asked questions

Which spreadsheet software must I know?

The syllabus is software-neutral; examples use Excel-style notation, which other spreadsheets also follow.

Is a workbook the same as a worksheet?

No. A workbook is the file; worksheets are its pages.

How is a chart made?

See the topic page on charts, sorting and filtering.

How do I import data?

Import data through the Data menu (for example, get external data); export or save as another format from the File menu.