India's #1 AI Tutorworksheet · Accountancy · Chapter 10

CBSE Class 11 Accountancy Chapter 10 Computers in Accounting Worksheet with Answers

Chapter 10 of CBSE Class 11 Accountancy introduces students to the transformative role of computers in modern accounting. From understanding computerised accounting systems to mastering spreadsheet applications like Tally and Excel, this chapter forms a bridge between traditional book-keeping and digital financial management. This printable worksheet is structured to test your conceptual clarity, application skills, and analytical thinking across multiple question formats, mirroring the latest CBSE evaluation standards.

Your child's private AI tutor — trained on NCERT.

3-day free trial · ₹1 to start · Cancel anytime.

Start 3-day free trial →

Key takeaways

✓This worksheet covers both major topics from NCERT Class 11 Accountancy Chapter 10: computerised accounting systems and spreadsheets in accounting.
✓Difficulty level is moderate to high, designed for thorough board exam preparation with 90 minutes suggested completion time.
✓Section-wise progression from MCQs to case-study questions helps build conceptual depth systematically.
✓The complete answer key with explanations enables independent learning and self-correction at home.
✓Practice includes HOTS questions that mirror the 2025 CBSE Class 11 evaluation pattern for Accountancy.
✓Ideal for weekend revision, pre-exam practice, or as a chapter-end assessment tool for teachers and students.
✓Questions emphasise real-world application of accounting software concepts, database management, and electronic spreadsheet functions.

Worksheet Overview and Instructions

This worksheet is designed for CBSE Class 11 students studying NCERT Accountancy Chapter 10 Computers in Accounting. The difficulty level is moderate to challenging, incorporating questions from basic recall to higher-order thinking skills (HOTS). Students should attempt this worksheet in examination conditions for best results. Allocate 90 minutes for completion, distributing time as follows: Section A (MCQs) 12 minutes, Section B (Fill-in-the-blanks) 8 minutes, Section C (Match/True-False) 10 minutes, Section D (Short answers) 25 minutes, Section E (Long answers and HOTS) 30 minutes, and the case study 15 minutes. Use the answer key only after completing all sections to maximise learning. Keep your NCERT Class 11 Accountancy textbook aside during the test but refer to it during answer-checking to reinforce concepts.

Total marks: 60 (each section weighted differently)
Suggested time: 90 minutes under exam conditions
Difficulty: Moderate to High, aligned with 2025 CBSE pattern
Materials needed: pen, calculator (for numerical problems), ruler
Answer key provided at the end with explanations for self-assessment

Quick Chapter Recap: Computers in Accounting

Before attempting the worksheet, refresh your understanding of the core concepts. Chapter 10 focuses on two main pillars: computerised accounting systems and the use of spreadsheets in accounting. A computerised accounting system automates ledger posting, trial balance preparation, and financial statement generation through software like Tally.ERP 9 or SAP. Key advantages include speed, accuracy, scalability, and real-time reporting. Spreadsheets such as Microsoft Excel enable accountants to perform calculations, create charts, manage databases, and build financial models using formulas, functions, and pivot tables. Understanding the limitations of computerised systems—such as initial setup cost, training requirements, and data security risks—is equally important. The NCERT textbook emphasises both the technical workflow (data entry, processing, storage, output) and the conceptual framework (double-entry principles remain unchanged). Revise terms like MIS (Management Information System), ERP (Enterprise Resource Planning), and DBMS (Database Management System) as these appear frequently in board exams.

Computerised accounting system: definition, components (hardware, software, procedures), advantages and limitations
Spreadsheets in accounting: structure (rows, columns, cells), formulas, functions (SUM, AVERAGE, IF, VLOOKUP), charts
Comparison between manual and computerised accounting
Role of accounting software: Tally, QuickBooks, SAP for transaction recording and report generation
Security and control aspects: passwords, backups, audit trails

Section A: Multiple Choice Questions (1 mark each, 6 questions)

This section tests your foundational knowledge and ability to identify correct definitions, features, and examples related to computerised accounting systems and spreadsheets. Read each question carefully; some options may appear similar but differ in subtle yet critical ways. Negative marking is not applied, so attempt all questions. Each MCQ carries one mark, totaling six marks for this section. These questions mirror the pattern seen in CBSE Class 11 Accountancy term exams and are essential for scoring well in objective-type assessments introduced in recent board reforms.

Section B: Fill in the Blanks (1 mark each, 5 questions)

Complete each sentence with the most appropriate term or phrase from Chapter 10. This section assesses recall and precise terminology usage. Marks are awarded only for exact or contextually correct answers—spelling and phrasing matter. Each blank carries one mark, summing to five marks. These questions often appear in the theory portion of CBSE Class 11 Accountancy exams and help reinforce key vocabulary such as 'DBMS', 'voucher entry', 'ledger', and 'backup'. Write answers neatly in the space provided, and cross-check with NCERT Class 11 Accountancy textbook definitions when reviewing.

Section C: Match the Following (1 mark each, 5 pairs)

Match each term in Column A with the correct description or example in Column B. Write the letter corresponding to your choice in the answer column. Each correct match earns one mark, totaling five marks. This format tests your ability to link concepts with their applications or definitions—a skill crucial for understanding the integrated nature of computerised accounting. No negative marking applies, so attempt all pairs. Carefully read both columns before matching to avoid confusion between similar-sounding terms like ERP and MIS or between different spreadsheet functions.

Section D: Short Answer Questions (3 marks each, 5 questions)

Answer each question in about 60-80 words. These questions require you to explain concepts, list features, or provide brief comparisons. Marks are allocated for clarity, coverage of key points, and correct use of terminology from the NCERT Class 11 Accountancy syllabus. Each question carries three marks, totaling fifteen marks for this section. Structure your answers in points wherever possible to ensure all aspects are covered. These short-answer questions are a staple of CBSE board exams and often draw directly from chapter headings and sub-headings in the textbook. Practice writing concise, focused responses to maximise scoring efficiency.

Section E: Long Answer and HOTS Questions (5 marks each, 3 questions)

These questions demand in-depth explanation, critical analysis, or application of multiple concepts. Write 150-200 words per answer, organising your response into clear paragraphs or numbered points. Each question carries five marks, summing to fifteen marks. HOTS (Higher Order Thinking Skills) questions test your ability to evaluate, compare, and synthesise information rather than merely recall facts. For instance, you may be asked to assess the limitations of computerised accounting or design a simple spreadsheet solution for a given accounting problem. Reference real-world scenarios, such as how a small business might implement Tally for GST compliance or how Excel pivot tables aid monthly sales analysis. These questions mirror the analytical depth expected in CBSE Class 11 board exams and competitive commerce assessments.

Section F: Case Study Question (5 marks)

Read the case scenario carefully and answer the questions that follow. Case studies test your ability to apply theoretical knowledge to real-world business situations—a skill highly valued in CBSE evaluations. This question carries five marks and typically includes 2-3 sub-questions. Pay attention to details in the scenario such as company size, type of transactions, software used, and challenges faced. Your answers should be practical, grounded in Chapter 10 concepts, and demonstrate understanding of both computerised accounting systems and spreadsheet applications. Such questions have appeared in recent CBSE Class 11 sample papers and are an excellent predictor of exam performance.

Answer Key: Section A (MCQs)

Below are the correct answers with brief explanations. Cross-check your responses and award yourself one mark for each correct answer. If you scored fewer than four marks, revisit the corresponding sections in your NCERT Class 11 Accountancy textbook and class notes. Understanding why an answer is correct is as important as knowing the answer itself—this will deepen your conceptual grasp and prepare you for application-based questions in board exams. Total marks for Section A: 6.

1. (c) Elimination of all accounting errors — Computerised systems reduce errors but cannot eliminate them entirely; data entry mistakes and logic errors can still occur.
2. (c) Cell — The intersection of a row and column in a spreadsheet (e.g., B5) is called a cell.
3. (b) Accounting software — Tally.ERP 9 is widely used accounting software in India for recording transactions, inventory, and GST compliance.
4. (b) SUM — The SUM function in Excel adds a range of cells, e.g., =SUM(A1:A10).
5. (b) Hard disk / SSD — Permanent storage in computers is provided by hard disks or solid-state drives, not volatile memory like RAM.
6. (b) Management Information System — MIS refers to systems that provide managers with information for decision-making.

Answer Key: Sections B, C, D, E and Case Study

Section B (Fill in the Blanks): 1. DBMS (Database Management System); 2. Voucher; 3. Backup; 4. ERP (Enterprise Resource Planning); 5. =AVERAGE(A1:A10). Section C (Match the Following): 1-c, 2-b, 3-d, 4-e, 5-a. Section D (Short Answers): Q1: Advantages include speed (instant posting), accuracy (reduced human error), and scalability (handles growing data). Q2: Spreadsheets perform calculations (SUM, AVERAGE), create charts for visualisation, and manage databases (sorting, filtering). Examples: preparing budgets in Excel, generating ageing reports. Q3: Voucher entry is recording a transaction in accounting software; types include Payment Voucher and Receipt Voucher. Q4: Hardware comprises physical devices (CPU, printer); software includes operating systems and application programs (Tally, Excel). Q5: Backup prevents data loss from crashes or cyberattacks; methods include cloud storage and external hard drives. Section E (Long Answers): Q1: Components—hardware (computer, printer), software (OS, Tally), personnel (accountants), procedures (voucher entry workflow); limitations—high initial cost, training needed, risk of data theft. Q2: Spreadsheets automate calculations (IF for conditionals, VLOOKUP for data retrieval, SUM for totals), create visual reports (charts), and enable what-if analysis. Q3: Manual accounting is flexible and low-cost but slow and error-prone; computerised accounting is fast, accurate, and integrates functions but costly and requires training; recommend computerised for retail due to high transaction volume. Case Study: (a) Advantages—automated ledger posting, GST-compliant reports. (b) Measures—regular backups (daily/weekly), UPS for power protection, antivirus software. (c) Errors occur due to incorrect data entry; control—validation checks and user training.

Section B total: 5 marks (1 per blank)
Section C total: 5 marks (1 per match)
Section D total: 15 marks (3 per question)
Section E total: 15 marks (5 per question)
Case Study total: 5 marks (allocated as per sub-questions)
Grand total for worksheet: 60 marks

How CBSETUTOR.ai Supports Chapter 10 Mastery

Many Class 11 students find the transition from manual to computerised accounting concepts challenging, especially when juggling practical software skills with theoretical knowledge. CBSETUTOR.ai offers a 24×7 AI tutor that helps students master CBSE Class 11 Accountancy Chapter 10 by answering doubts instantly, explaining complex topics like DBMS architecture or pivot table creation, and even solving worksheet problems step-by-step. Students can upload photos of their homework or practice questions and receive detailed, curriculum-aligned explanations within seconds. Unlike traditional coaching that operates on fixed schedules, CBSETUTOR.ai is accessible anytime, making it ideal for last-minute revisions or clarifying concepts while solving worksheets like this one. The platform covers every NCERT chapter for Classes 6-12 across all subjects at a single flat fee of ₹999 per month—no hidden charges, no per-subject billing. A 3-day free trial lets students and parents experience the AI tutor risk-free before committing, making quality academic support accessible and affordable for every Indian household.

Instant doubt resolution for Computers in Accounting concepts, available 24×7
Photo-upload feature to solve worksheet questions with step-by-step explanations
Covers full NCERT Class 11 Accountancy syllabus plus other subjects for Classes 6-12
Flat ₹999/month subscription for unlimited access—one price for all classes and subjects
3-day free trial to test the platform before purchase, no credit card required upfront
Ideal for students in areas with limited access to quality Accountancy coaching

Tips for Scoring High in Chapter 10 Board Exams

Chapter 10 Computers in Accounting typically carries 6-8 marks in the CBSE Class 11 Accountancy final exam, split between theory questions and practical application scenarios. To maximise your score, focus on understanding the workflow of computerised accounting—from voucher entry to report generation—rather than rote memorisation. Practice drawing block diagrams of computerised accounting systems, labeling components like input devices, CPU, storage, and output devices. Familiarise yourself with Tally screen navigation and basic Excel formulas; examiners often ask for examples. When answering limitations of computerised systems, balance your response by also stating advantages to show holistic understanding. Use proper accounting terminology: write 'ledger posting' instead of 'writing in the book', and 'backup' instead of 'copy'. Revise NCERT examples verbatim, as CBSE often frames questions around textbook illustrations. Finally, manage time during exams—short questions should not exceed five minutes each, leaving ample time for long-answer and case-study problems.

Memorise definitions: computerised accounting system, DBMS, MIS, ERP, spreadsheet cell
Practice diagrammatic representation of system components and data flow
List advantages and limitations in tabular form for quick revision
Solve previous years' CBSE Class 11 Accountancy question papers focusing on this chapter
Understand real-world software examples: Tally for SMEs, Excel for financial modeling
Write answers in points for theory questions to ensure comprehensive coverage

Frequently asked questions

What is the suggested time to complete this CBSE Class 11 Accountancy Chapter 10 worksheet?+

Students should allocate 90 minutes under exam conditions. Distribute time as follows: MCQs 12 minutes, fill-in-the-blanks 8 minutes, matching 10 minutes, short answers 25 minutes, long answers 30 minutes, and case study 15 minutes for optimal practice.

How many marks does Chapter 10 Computers in Accounting carry in CBSE Class 11 final exams?+

Chapter 10 typically carries 6-8 marks in the annual CBSE Class 11 Accountancy examination. Questions can be theory-based (definitions, advantages, limitations) or application-based (case studies, spreadsheet problems), so thorough conceptual and practical preparation is essential.

Are Tally or Excel practicals mandatory for CBSE Class 11 Accountancy board exams?+

CBSE does not mandate hands-on practical exams for Class 11 Accountancy. However, understanding Tally voucher entries and basic Excel formulas (SUM, AVERAGE, IF) is crucial as theory questions often ask for examples or workflows involving these tools.

What are the most important topics within Chapter 10 to focus on for board exams?+

Focus on the definition and components of computerised accounting systems, advantages and limitations compared to manual systems, role of DBMS and MIS, spreadsheet structure and functions (SUM, AVERAGE, IF, VLOOKUP), and data security measures like backup and passwords.

How can I remember the differences between manual and computerised accounting?+

Create a comparison table with parameters: speed, accuracy, cost, flexibility, scalability, and reporting. Write 2-3 points for each under both systems. Visual tables aid memory retention and are easy to reproduce in exams for 3-5 mark questions.

Is the answer key in this worksheet aligned with NCERT solutions and CBSE marking scheme?+

Yes. All answers follow NCERT Class 11 Accountancy textbook terminology and align with the latest CBSE marking guidelines. Explanations are provided to help students understand why an answer is correct, reinforcing conceptual clarity beyond rote learning.

Can this worksheet be used for school internal assessments or periodic tests?+

Absolutely. Teachers often use such worksheets for internal assessments, unit tests, or revision sessions. Students can also print and solve it at home for self-evaluation, tracking progress against the answer key to identify weak areas needing more practice.

What is the difficulty level of this worksheet compared to actual CBSE exams?+

The worksheet is designed at moderate to high difficulty, slightly tougher than typical board questions to challenge students and build confidence. Solving this thoroughly prepares you for both expected and surprise questions in CBSE Class 11 Accountancy exams.

Where can I find additional practice questions for Chapter 10 beyond this worksheet?+

Refer to NCERT exemplar problems, CBSE sample papers for Class 11 Accountancy, and previous years' board question papers. Online platforms like CBSETUTOR.ai offer instant doubt-solving and additional question banks with step-by-step solutions to supplement your preparation.

How does CBSETUTOR.ai help with Accountancy worksheets and homework?+

CBSETUTOR.ai provides a 24×7 AI tutor where students upload photos of worksheet questions and receive detailed, step-by-step solutions instantly. It covers all NCERT chapters for Classes 6-12 at ₹999/month with a 3-day free trial, making expert help affordable and accessible anytime.

Related resources

Important Questions: CBSE Class 11 Accountancy Chapter 10 Computers in Accounting Class 11 Accountancy Chapter 10 Computers in Accounting — Formulas & Key Points CBSE Class 11 Accountancy Chapter 9 Financial Statements — I & II Worksheet with Answers Class 11 Accountancy Chapter 9 Financial Statements — I & II — Formulas & Key Points AI Tutor for Class 11: The Smart Alternative to Tuition AI Tutor for Class 11 Accountancy: Learn Faster with Instant Help Class 9 Accountancy Chapter 1: Introduction to Accounting Previous Year Questions (2020–2025) with Solutions CBSE Class 9 Mathematics Chapter 1 Number Systems Worksheet with Answers

Keep learning — related guides

Class 11Accountancy

Class 11 Accountancy Chapter 10 Computers in Accounting — Formulas & Key Points

Class 11Accountancy

Important Questions: CBSE Class 11 Accountancy Chapter 10 Computers in Accounting

Class 11Accountancy

Important Questions: CBSE Class 11 Accountancy Chapter 9 Financial Statements — I & II

Class 11Accountancy

Class 11 Accountancy Chapter 9 Financial Statements — I & II — Formulas & Key Points

Class 11Accountancy

CBSE Class 11 Accountancy Chapter 9 Financial Statements — I & II Worksheet with Answers

Class 11Accountancy

Class 11 Accountancy Chapter 8 Bills of Exchange — Formulas & Key Points

Ready to give your Class 11 child the tutor that never sleeps?

CBSETUTOR.ai covers every chapter in the Class 11 NCERT syllabus — Maths, Science, Social Science, English, Hindi and more. 24×7. Patient. Unlimited. 3-day free trial.

Start your child's 3-day free trial →