Accounting Application of Electronic Spreadsheet: ISC Class 12 Accounts

What Accounting Application of Electronic Spread Sheet is about

Weightage: Accounting Application of Electronic Spread Sheet carries 10 of the 80 theory marks in Section C (Computerised Accounting). Candidates answer either Section B or Section C (20 marks each), after the compulsory 60-mark Section A.Source: CISCE ISC Accountancy (Accounts) syllabus, examination year 2027, distribution of marks

Key concepts

Meaning, utility, merits and demerits

An electronic spreadsheet is a software application that arranges data in a grid of rows and columns and performs calculations through formulas and built-in functions.

Utility in accounting: journals and ledgers, payroll, depreciation schedules, loan schedules, budgets, ratio analysis, charts for reports.

Merits:

• Automatic recalculation when inputs change (what-if analysis).
• Accuracy: formulas remove arithmetic errors.
• Speed: formulas can be copied down thousands of rows.
• Presentation: formatting, charts and printing.
• Data handling: sorting, filtering, importing and exporting (for example CSV files).

Demerits:

• A wrong formula silently produces wrong results everywhere it is copied.
• Limited security and audit trail compared with accounting software.
• Large data sets become slow and hard to control.
• Needs training.

Worked example

Suppose a small trader keeps his journal in a notebook. State two advantages he would gain by maintaining it in an electronic spreadsheet. [2 marks]

Try it first, then show the solutionSolution

1. Totals of debit and credit columns are calculated automatically with =SUM(), so errors in addition are avoided.
2. Entries can be sorted or filtered (for example all cash entries) and corrected without rewriting the whole page.

Answer: Automatic and accurate totals; easy sorting, filtering and correction.

Basic features: workbooks, navigation, shortcuts, formatting, printing

• Workbook and worksheets: a workbook holds sheets (Sheet1, Sheet2…), which can be added, deleted, renamed, moved or copied within or between workbooks.
• Data types: text (labels), numbers, dates, alphanumeric values; heading information in the top row.
• Range: a block of cells written as first cell : last cell, for example B1:G10.
• Common shortcuts: Ctrl+Z undo; Ctrl+Y redo; Ctrl+C copy; Ctrl+X cut; Ctrl+V paste; Ctrl+S save; Ctrl+N new workbook; Ctrl+P print; Ctrl+Home go to A1; F2 edit a cell.
• Formatting: alignment, font styles, number and date formats, column width, borders, fill colours, auto format.
• Printing: page setup (orientation, margins), print titles (repeat heading rows on every page), page breaks, headers and footers, print preview.
• Freeze panes: keeps heading rows or columns visible while scrolling through a long sheet.
• Macros are written in VBA (Visual Basic for Applications).
• Online spreadsheets such as Google Sheets can collect records from Google Forms (sign-up or registration forms).

Worked example

Suppose a payroll sheet has 500 employees and the headings in row 1 disappear when you scroll down. Which feature solves this, and how? [1 mark]

Try it first, then show the solutionSolution

1. Freeze panes: select row 2 and choose View → Freeze Panes (Freeze Top Row), so row 1 stays visible.

Answer: Freeze panes (freeze the top row).

Formulas, cell references and error values

A formula begins with = and uses operators + − * / ^ and %.

• Summation =SUM(B2:B10); average =AVERAGE(C2:C31); percentage =B2*12% or =B2/B10*100.
• Relative reference (B2) changes when copied; absolute reference ($B$2) stays fixed: use it for a rate kept in one cell, for example =C2*$K$1.
• Mixed reference ($B2orB$2) fixes only the column or the row.

Error values:

Error	Meaning
#DIV/0!	division by zero or a blank cell
#VALUE!	wrong type of argument (text used in arithmetic)
#REF!	reference to a deleted or invalid cell
#NAME?	text not recognised (misspelt function)
#N/A	value not available (lookup found nothing)
#NUM!	invalid numeric value (impossible calculation or too large a number)
#NULL!	intersection of two ranges that do not intersect (space used instead of comma or colon)
#####	column too narrow to display the value

Worked example

Suppose cell D2 should show 40% of the basic pay in C2, and the rate 40% is kept in cell K1 for all employees. Write a formula for D2 that can be copied down to D501. [1 mark]

Try it first, then show the solutionSolution

1. The basic pay reference must change row by row (relative); the rate must stay on K1 (absolute).

Answer: =C2*$K$1

Functions: IF, date functions and PMT

• IF (if-then-else): =IF(condition, value if true, value if false). Example: commission at 5% if sales in B2 exceed ₹2,00,000, otherwise 2%: =IF(B2>200000, B2*5%, B2*2%). Nested IF handles more slabs: =IF(B2>500000, B2*7%, IF(B2>200000, B2*5%, B2*2%)).
• AND / OR inside IF: =IF(AND(C2>=40, D2>=40), "Pass", "Fail").
• Date functions: =TODAY() (current date); =NOW() (date and time); =DATE(2026,3,31); =YEAR(A2), =MONTH(A2), =DAY(A2); =A3−A2 or =DAYS(A3,A2) for days between two dates.
• PMT: calculates the equal periodic payment (instalment) of a loan for a constant interest rate and number of periods: =PMT(rate, nper, pv). For monthly instalments use rate/12 and months.
• Other useful functions: MAX, MIN, COUNT, COUNTIF, ROUND.

Worked example

Suppose column B has each salesman's sales. Commission is 5% if sales exceed ₹2,00,000 and 2% otherwise. Write the formula for C2, and find the commission on sales of ₹2,50,000 and ₹1,50,000. [2 marks]

Try it first, then show the solutionSolution

1. =IF(B2>200000, B2*5%, B2*2%).
2. ₹2,50,000 → 2,50,000 × 5% = ₹12,500; ₹1,50,000 → 1,50,000 × 2% = ₹3,000.

Answer: =IF(B2>200000,B2*5%,B2*2%); ₹12,500 and ₹3,000.

Accounting applications: payroll, sales, marks and journal

Payroll components (as named in the syllabus):

• Basic pay; DA (dearness allowance, a % of basic); HRA (house rent allowance, a % of basic); TA (transport/travel allowance); CCA (city compensatory allowance).
• Gross salary = Basic + DA + HRA + TA + CCA (+ other allowances).
• Deductions: employee's PF (a % of basic, or of basic + DA if stated) and income tax (TDS).
• Net salary = Gross salary − deductions.
• CTC (cost to company) = Gross salary + employer's contribution to PF (and other employer costs).

Sale of goods: sales = units sold × selling price; cost of goods sold = units sold × cost; profit = sales − cost; unsold stock = (units made − units sold) × cost; salesmen's commission with IF.

Marks: =SUM(C2:G2) for total; =AVERAGE(C2:G2) for average; =IF(H2>=33*5, "Pass", "Fail").

Journal: columns for Date, Particulars, L.F., Debit, Credit; =SUM(D2:D50) and =SUM(E2:E50) with a check cell =IF(D51=E51, "Agreed", "Check").

Worked example

Suppose an employee has basic pay ₹30,000, DA 40% and HRA 20% of basic, TA ₹2,000, CCA ₹1,500; PF 12% of basic; income tax ₹5,000; employer's PF 12% of basic. Calculate gross salary, net salary and CTC. [3 marks]

Try it first, then show the solutionSolution

1. Gross = 30,000 + 12,000 + 6,000 + 2,000 + 1,500 = ₹51,500.
2. Net = 51,500 − 3,600 − 5,000 = ₹42,900.
3. CTC = 51,500 + 3,600 = ₹55,100.

Answer: Gross ₹51,500; net ₹42,900; CTC ₹55,100.

Data presentation: charts and database features

Charts: select the data and insert a chart (or use the chart wizard). Types: column/bar (compare amounts), line (trends over time), pie (parts of a whole, one data series), area, scatter. Format gridlines, legends, axis titles and data labels; preview and print.

Database in a spreadsheet: a list with one record per row and one field per column, with headings in the first row.

• Sort: arrange records in ascending or descending order on one or more fields.
• Filter (AutoFilter): show only records meeting a condition (for example sales > 2,00,000), hiding the rest without deleting them; advanced filter for complex criteria.
• Query: extract records matching criteria (filters, COUNTIF/SUMIF).
• Import and export: Data → Get Data (from text/CSV, databases, the web) to import; Save As (CSV, PDF) or Export to export.

Worked example

Suppose a sales manager wants to (i) show monthly sales trend for a year and (ii) show each region's share in total sales. Which chart type suits each? [2 marks]

Try it first, then show the solutionSolution

1. (i) A trend over time: line chart.
2. (ii) Parts of a whole: pie chart.

Answer: (i) Line chart; (ii) pie chart.

Accounting Application of Electronic Spread Sheet in real life

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

Topics in this chapter

• Spreadsheet Charts, Sorting, Querying and Filtering a Database
• Spreadsheet Formulas, Functions and Accounting Applications
• Electronic Spreadsheet: Concept, Features, Formatting and Printing

Accounting Application of Electronic Spread Sheet: key facts

Total

=SUM(first cell:last cell)

Average

=AVERAGE(range)

IF

=IF(condition, value if true, value if false)

Gross salary

=Basic + DA + HRA + TA + CCA (e.g. =SUM(C2:G2))

Net salary

=Gross salary − PF − income tax

CTC

=Gross salary + employer's PF contribution

Loan instalment

=PMT(rate per period, number of periods, loan amount)

How the board asks Accounting Application of Electronic Spread Sheet

The question patterns to expect, and the method that works for each.

Tricks to remember Accounting Application of Electronic Spread Sheet

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

• Payroll order: B-D-H-T-C

  Basic, DA, HRA, TA, CCA make gross; PF and tax come off to make net; employer's PF on top makes CTC.

  Use it when: Payroll formulas.

• Errors by first letter

  DIV: divide by zero; VALUE: wrong type; REF: lost reference; NAME: misspelt; NUM: impossible number; NULL: ranges that do not meet.

  Use it when: Error-value questions.

Accounting Application of Electronic Spread Sheet: board-level solved questions

Ordered from board level to HOTS. Cover the solution, write your own, then compare step by step.

Case-study practice (Section A style)

Read the situation, then answer every part. In the board paper this is a 6-mark question split into 2 + 2 + 1 + 1 marks.

Where the marks are

How a typical answer is split into step marks. Show every step: a right final answer alone rarely earns full marks.

Where students lose marks in Accounting Application of Electronic Spread Sheet

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

• ✗Mistake: Skipping spreadsheet questions altogether

  CISCE examiners' comments, 2025, on the range-reference MCQ and on Questions 16 and 18: "Very few candidates attempted this question."

  ✓Do this: Practise writing formulas for payroll and sales sheets every week; these are scoring questions.

  Usually costs: Up to 6 marks in Question 18.

• ✗Mistake: Writing numbers instead of cell references

  A formula such as =30000*40% gives the right value for one row but fails when copied down; the answer key expects references such as =C2*40%.

  ✓Do this: Always refer to the cell that holds the input.

  Usually costs: ½-1 mark per formula.

• ✗Mistake: Missing "=" or wrong range punctuation

  Without "=" the entry is treated as text; ranges need a colon (B1:G10), not a hyphen or full stop.

  ✓Do this: Begin every formula with = and write ranges with a colon.

  Usually costs: ½ mark.

• ✗Mistake: Wrong base for PF or allowances

  Case questions state whether PF is on basic or on basic + DA, and incentives may be merged with other allowances; ignoring the wording gives a wrong formula.

  ✓Do this: Underline the base in the question and use exactly that cell.

  Usually costs: 1 mark.

Practice questions on Accounting Application of Electronic Spread Sheet

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

1. Q1 · 1 mark · MCQBoard level

   A file containing one or more worksheets is called a:
   (a) datasheet
   (b) workbook
   (c) table
   (d) record

   Hint

   Book of sheets.

   Answer

   (b)

2. Q2 · 1 mark · Very short answerBoard level

   What is the intersection of a row and a column called?

   Hint

   C2 is one.

   Answer

   A cell.

3. Q3 · 1 mark · Very short answerBoard level

   Which programming language is used to write macros in MS Excel?

   Hint

   Three letters.

   Answer

   VBA (Visual Basic for Applications).

4. Q4 · 1 mark · Very short answerHarder board level

   Describe the error values #NUM! and #NULL!.

   Hint

   Numbers and intersections.

   Answer

   #NUM!: an invalid numeric value or impossible calculation; #NULL!: two ranges that do not intersect are referenced (usually a space instead of a colon or comma).

5. Q5 · 1 mark · Very short answerHarder board level

   How are records (a) imported into and (b) exported from a spreadsheet?

   Hint

   Data menu and Save As.

   Answer

   (a) Data → Get Data (from text/CSV, a database or the web); (b) File → Save As or Export in another format such as CSV or PDF.

6. Q6 · 2 marks · Short answerHOTS / competency

   Write a formula for commission in C2: 2% on sales (B2) up to ₹1,00,000, 4% from ₹1,00,001 to ₹3,00,000, and 6% above ₹3,00,000.

   Hint

   Nested IF.

   Answer

   =IF(B2>300000,B2*6%,IF(B2>100000,B2*4%,B2*2%))

7. Q7 · 2 marks · Short answerHarder board level

   Explain the difference between relative and absolute cell references with an example.

   Hint

   Dollar sign.

   Answer

   A relative reference (B2) changes when the formula is copied; an absolute reference ($B$2) does not. E.g. =C2*$K$1 keeps the rate in K1 fixed while C2 changes row by row.

8. Q8 · 2 marks · Short answerBoard level

   Give two demerits of using spreadsheets for accounting.

   Hint

   Errors and control.

   Answer

   A wrong formula copied down spreads errors silently; weak security and audit trail compared with accounting software (also, large files become slow).

9. Q9 · 2 marks · Short answerHOTS / competency

   An employee's salary sheet shows Gross Salary in H2 = ₹48,000 and employer PF in M2 = ₹3,000. Write the formula for CTC in N2 and state why CTC is more than gross salary.

   Hint

   Employer cost.

   Answer

   =H2+M2 = ₹51,000. CTC includes the employer's contribution to PF, which is a cost to the company but not part of the salary paid.

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. 1.Shortcut to undo?Show answer

   Ctrl + Z.

2. 2.Range from B1 to G10?Show answer

   B1:G10.

3. 3.Language of macros?Show answer

   VBA.

4. 4.What does PMT calculate?Show answer

   The equal periodic payment of a loan.

5. 5.Gross salary components?Show answer

   Basic + DA + HRA + TA + CCA.

Quick revision checklist

The night before the exam: can you do each of these without looking?

• ☐Formula starts with =; ranges use a colon.
• ☐Relative B2, absolute $B$2.
• ☐=IF(condition, true, false); nest for slabs.
• ☐Gross = Basic + DA + HRA + TA + CCA; Net = Gross − PF − tax; CTC = Gross + employer PF.
• ☐Freeze panes keeps headings visible.
• ☐Line chart for trends, pie for shares, column for comparison.

Accounting Application of Electronic Spread Sheet: frequently asked questions