Plus Two Computerised Accounting Solved Practical Questions

The Part 3 Optional subject for Higher Secondary Class XII Commerce is Computerised Accounting System. The syllabus for Computerised Accounting is divided in to six units.The first unit is theoretical. There is no lab work for the first unit. The second, third, fourth, fifth and sixth units deal with electronics spreadsheet, GNUKhatha, DBMS and its lab work.

The question paper for Computerised Accounting System Practical Examination contains four parts(Part A, B, C and D). In each question paper, part A and B consists of spread sheets, Part C Consists of GNU Khatha and Part D Consist of Database Management System.

Recently DHSE published a Pool of questions under Part A,B,C and D for Practical Evaluation of Computerised accounting. The solved Questions for the lab questions prepared by Sri.Harikumar A, V.V HSS Thamarakkulam Alappuzha is given here for downloading.

Computerised Accounting Solved Practical Questions 2023 by Hari Kumar
1. Use of SUM, SUMIF, Lookup functions(Libre Office Calc)
2. Use of IF function(Libre Office Calc)
3. Use of COUNT function(Libre Office Calc)
4. Spreadsheet – Preparation of Pivot Table(Libre Office Calc)
5. Spreadsheet – Use of Minimum, Maximum, Average and Concatenate functions(Libre Office Calc)
6. Spreadsheet – Use of One Variable Table(Libre Office Calc)
7. Preparation of Column Chart(Libre Office Calc)
8. Preparation of Pie Chart(Libre Office Calc)
9. Depreciation – SLN Method(Libre Office Calc)
10. Depreciation – DB Method(Libre Office Calc)
11. Preparation of Payroll(Libre Office Calc)
12. Loan Repayment Schedule(Libre Office Calc)
13. Preparation of Cashbook(GNU Khata)
14. Preparation of Final Accounts(GNU Khata)
15. Bank Reconciliation Statement(GNU Khata)
16. Preparation and Display of Trial Balance(GNU Khata)
17. Creation of Table in Design view(Libre Office Base)
18. Creating Relationship between Tables(Libre Office Base)
19. Preparation of Payroll(Libre Office Base)
20. Preparation of Report(Libre Office Base)
Accounting Solved Practical Questions
Plus Two Commerce-Computerised Accounting-Practical Question & Procedures by Bindu C
Plus Two Commerce-Computerised Accounting-Practical Question & Procedures by Binoy George
Plus Two Commerce-Computerised Accounting-Practical Question & Procedures by Ajith Kanthi