Computerised Accounting – Previous year questions

Computerised Accounting Previous years’ Questions and Answers

Ch.1 – Overview of Computerised Accounting system

Each cell in a Spreadsheet is identified with a unique name, which is known as_______.
(a) Range (b) Columns (c) Cell address (d) Rows
Ans : (c) Cell address
Pick out the one, which is not a component of computerised accounting system.
(a) Procedure (b) Data (c) People (d) Virus
Ans : (d) Virus
In an organization, Code ‘PL’ is used for Purchase Ledger, ‘SL’ is used for Sales Ledger. Which type of Code is used here ?
(a) Block Code (b) Sequential Code (c) Mnemonic Code (d) None of these
Ans : (c) Mnemonic Code
The Code CS101, CS102, CS103 for customer x, y and z is an example of ______code.
(a) Mnemonic (b) Sequential (c) Block (d) None of these
Ans :(b) Sequential
Develop a coding structure and the code number with assumed figures for allotting register numbers for the students in higher secondary exam with district code, school code and admission number
Ans : District code – KKD
School code : 162
Admission No : 1120
Student Register no : KKD1621120.
Numbers and letters or both of them assigned in a consecutive order as code is a _____.

(a) Block code (b) Mnemonic code (c) Sequential code (d) Numeric code
Ans : (c) Sequential code

List out any four components of Computerised Accounting System. (2Marks)
Ans:People
Data
Procedure
Hardware
software
Describe any three merits of Computerised Accounting System.

Ans:
A- Instant and automatic processing of transactions
B- saves times and money
C- Storage and retrieval of data is very easy
D- Accuracy, Voucher and cheque printing is possible
E- transparency and reliability ensured, etc..
F – Timely generation of reports in desired format.
G – Alterations and addition in transactions are easy and gives changed results easily.
H – Ensures effective control over the system. ( Any four merits – one score each)

Briefly explain the features of computerised accounting system. (5 Marks)
Features of computerised accounting system.
1. Simplicity: Computerized Accounting System (CAS) is an easy way to process the accounting transactions.

2.Comprehensive nature: Most of the accounting packages are complete and comprehensive.

3. Accuracy: The reports that are generated by computerized accounting system are free from mistakes.

4. Speed: Computers can process data millions of times faster than human beings.

5. No difficulty in alterations: Alterations and additions in transactions can be affected easily in computerized accounting.
( 5 features. One score each for brief explanation. 1⁄2 score each for points only. Any other features may be considered. Max. 5 scores)

Identify the types of codes for the given examples from the items in brackets

(Sequential code, Block code, Mnemonic code)
(a) Code Name of Railway Station
QLN – Kollam
TCR – Thrissur

(b) Code Textile Item
100-199 – Gents Wear
200-299 – Ladies Wear
Ans : a) Mnemonic Code
b) Block code

Range of numbers are used for codification in :

(a) Sequential codes (b) Block codes (c) Mnemonic codes (d) Alpha Numeric codes

Ans :(b) Block codes

Explain any two security features of a Standard computerised AccountingSoftware.
Discuss any two security features of Computerised Accounting System.
Briefly explain any two security features of Computerised Accounting System. (2 Score – March 22)
Briefly explain any two security features of Computerised Accounting System
Ans :
1-Password: can restrict access to company’s data to authorised users using password.
2-Data audit: This feature is available to administrator to track any unauthorised changes that have taken place in the data.
3-Data vault:– This feature is encrypting data for additional security.
Business firms. more often, made use alphabets or symbols for codification’ Identify the type of codes referred here. Give a suitable example for this type of codes’
Ans:
Sequential Codes – In sequential code,numbers and/or letters are assigned in consecutive order. These codes are primarily applied to source documents such as invoices, cheques etc.

Ex : N001 – ABC Ltd
N002 – PQR Ltd
N003 – XYZ Ltd
Block codes
In block code, a range of numbers is partitioned into a desired number of sub ranges and each sub range is allotted to a specific group.

Code Account Groups
001 – 500 Direct Expense
501 – 1000 Indirect Expense
1001- 1500 Direct Income
1501- 2000 Indirect Income

Mnemonic Codes
A mnemonic code consists of alphabets or abbreviations as symbols to codify an Account. E.g. Salary Account can be coded as ‘SLR’, Building Account can be coded as ‘BLD’ and so on

Ch.2 – Spreadsheet

The default base date used in ‘DATEVALUE’ function in LibreOffice Calc., is :
(a) 01-01-1990 (b) 02-01-1899 (c) 02-01-1991 (d) 30-12-1899
Ans: (d) 30-12-1899
The function that returns current time along with current date is _______.

(a) DAY – (b) TODAY (c) NOW (d) DATEVALUE
Ans: (c) NOW

The function which counts the number of numeric values in a given range of cell_____.

(a) COUNTA (b) COUNTBLANK (c) COUNT (d) COUNTIF
Ans : (c) COUNT

Describe any two features of LibreOffice Calc.
Ans: 1- Easy calculations
2 – What-If calculations
3 – Server as a database
4 – Arranging data
5 – Dynamic charts
Pre-defined formulae in spreadsheets are called :

(a) Functions (b) Cell reference (c) Values (d) Operator
Ans :(a) Functions

Identify the function which displays the current system date.

(a) TODAY (b) NOW (c) DATE (d) DATEVALUE
Ans : (c) DATE

Complete the missing area as per the hint given below :

Name of Function	Type of Function	Purpose
TODAY	Date and Time Displays	current system date
COUNTBLANK	…………a………………	………b…….
SUM	………c……	………d…

Ans : a) STATISTICAL Function
b) Displays number of empty cells
c)MATHEMATICAL Function
d)Sum of values

Write down the 5 features of Libre Office Calc. Briefly explain. (5 Marks)

Ans : Features of LibreOfficeCalc/ SpreadSheet

1) Easy Calculations : In LibreOffice Calc there are lot of tools which help the user to perform even complex calculations on different data across sheets with ease.

2) Arranging Data :The data stored in LibreOffice calc can be organised or reorganised according to the needs of the user.

3) Serve as Database :This programme allows storing any number of data in different sheets. Storing, retrieving, filtering etc are easy in it.

4) Dynamic Charts :Different types of charts are available in LibreOffice Calc and are enable the user to present various data in an appealing manner.

5) What If calculations :This lets users to predict what will happen if conditions change.

( 5 features. One score each for brief explanation. 1⁄2 score each for points only. Any other features may be considered. Max. 5 scores)

Describe the use and Syntax of the following functions in Libre Office Calc : (5 Score -20 March)
(a) Now
(b) Count
(c) IF
(d) Rate
(e) Concatenate
Ans :
a) Now – It shows the current system date and type Syntax is =NOW()
(b) Count – it count the cells that contain numbers
(c) IF – It analyse a logical test and evaluate the condition is true or false
Syntax is =IF(Test,Then value,Other value)
(d) Rate – It is used to evaluate the rate of return on investment or interest on loan
Syntax is=RATE(Nper,PMT,PV,FV,Type,Guess)
(e) Concatenate – It is used to join two or more strings together
Syntax is =CONCATENATE(“Text 1”,text 2”……..)
Convert the ‘relative’ cell reference ‘A5’ into ‘absolute’ and ‘mixed’ cell references.
Ans : Absolute reference “ A5” – $A$
Mixed reference “A5” – $A5 or A$5
Briefly explain any two Logical functions in LibreOffice Calc.
Ans : 1 – IF Function
2 – AND Function
3 – OR Function
4 – NESTEDIF Function
write the result displayed on a cell, if the following spread-sheet function is used :

(a) : ROUND (999.99, 0)
(b) : ROUNDDOWN (999.99,0)
(c) : ROUND (123.45,-1)
(d) : ROUNDUP (123.45,0)
Ans :
a) 1000
b) 999
c) 120
d) 124

Give the syntax and explain the parameters of the following spreadsheet functions functions:

(a) SLN
(b) DB
(c) PMT
Ans : a) Syntax is =SLN(Cost,Salvage,Life)
b) = DB(Cost,Salvage,LIfe,Period,Month)
c)=PMT(rate,nper,pv,fv,type)
Rate – rate of interest
Nper – the number of periods for which the loan is to be repaid
Pv – The present value of the loan
Fv – future value of the loan
Type – whether the payment is made at the start /end of month

write any three mathematical functions commonly used in spreadsheets and briefly explain them.
Mr. Anjay a newly admitted student in the class have no idea about the mathematical functions in Spreadsheet. Can you help him to learn any three mathematical functions and its purpose ?
Ans : SUM – It is used to add all the numbers in a range of cells.
SUMIF – SUMIF Function ADD the cells specified by a given criteria
ROUND – It rounds a number to a specified number of digits asper normal rounding rules
ROUNDUP – This function is similar to ROUND function.This function rounds a number up away from zero.
ROUNDDOWN – Round a number down towards zero.This function always round a number to downward, without considering the value next to the rounding digit.
Write any 2 methods to add a new worksheet in a Spreadsheet (Libre Office calc). (2Marks)
Ans :
1 – Right click the mouse at the ‘sheet tab’ and select ‘Insert Sheet’ from the pop up menu or
2 – click the ‘plus mark (+) near the sheet tab. ( or any other answer)
Describe any two features of LibreOffice Calc.
Ans: 1- Easy calculations
2 – What-If calculations
3 – Server as a database
4 – Arranging data
5 – Dynamic charts
Briefly explain the commonly used Text Functions.
Ans: TEXT,CONCATENATE
Have a look on the Spreadsheet tables given below and explain the procedure to fill the data in both the cases :

Ans: Edit – Fill – Series Or
Select a cell and Drag using the fill handle.

Match the following items in Column – A with Column – B :

A B

(a) TEXT – To calculate the accrued interest on investment

(b) ACCRINT – To search certain values from a table

(b) ACCRINT – To calculate the accrued interest on investment

Numbers and letters or both of them assigned in a consecutive order as code is a _____.

(a) Block code (b) Mnemonic code (c) Sequential code (d) Numeric code
Ans : (c) Sequential code

The function that returns current time along with current date is _______.

(a) DAY – (b) TODAY (c) NOW (d) DATEVALUE
Ans: (c) NOW

The function which counts the number of numeric values in a given range of cell_____.

(a) COUNTA (b) COUNTBLANK (c) COUNT (d) COUNTIF
Ans : (c) COUNT

Identify the relevant functions used for the following purposes : (3 Marks)
(a) To count the total number of cells which contains any value.
(b) To join several text strings in different cells into one string.
(c) To count the empty cells from a given range.
Ans : a) COUNTA
b) CONCATENATE
c) COUNTBLANK
Briefly explain any two Logical functions in LibreOffice Calc.
Ans : 1 – IF Function
2 – AND Function
3 – OR Function
4 – NESTEDIF Function
Match the following items in Column – A with Column – B :

A B

(a) TEXT – To calculate the accrued interest on investment

(b) ACCRINT – To search certain values from a table

(b) ACCRINT – To calculate the accrued interest on investment

The financial function used for preparing loan repayment schedule is _______.

(a) ACCRINT (b) PMT (c) PV (d) RATE
Ans : (b) PMT

Give the syntax of the following functions used in Libre Office Calc. (3 Marks)
(a) PV Ans : =PV(rate,Nper,Pmt,Fv,Type)
(b) PMT Ans : =PMT(Rate,Nper,Pv,Fv,Type)
(c) NPV Ans : =NPV(Rate,Value1,Value2,…..,ValueN)
Identify the relevant functions in LibreOffice Calc used for the following purposes :

(a) To count the cells that contain numbers only.
(b) To count all types of data in a range of cells.

Ans : a) COUNT
b) COUNTA

Identify the function used for EMI (Equated Monthly Installment) calculation while preparing a Loan Repayment Schedule in LibreOffice Calc.

(a) PMT (b) FV (c) PV (d) NPV
Ans : (a) PMT

Name the functions and syntax used to display the following results in Libre Office Calc.

(a) Current system date
(b) Current date with time
(c) Count of numeric values in a given range of cells.
(d) To count the number of empty cells in a given range. (4 Marks)

Ans:

	Name of function	Syntax
(a) Current system date	TODAY	=TODAY()
(b) Current date with time	NOW	=NOW()
(c) Count of numeric values in a given range of cells.	COUNT	=COUNT(Range)
d) To count the number of empty cells in a given range.	COUNTBLANK	=COUNTBLANK(Range)

Ch.3 – Use of Spreadsheet in Business Application

Identify the function used to compute equated Donthlv installments (EMI) of a loan.
(a) PMT (c) PV (b) NPv (d) ACCRINT
Ans: (a) PMT
Identify the function used to compute equated Donthlv installments (EMI) of a loan.
(a) PMT (c) PV (b) NPv (d) ACCRINT
Ans: (a) PMT
Which among the following financial function is used for calculating straight line method of depreciation ?
(a) SLN (b) DB (c) PMT (d) PV
Ans : (a) SLN
Which one of the following is a deduction in the calculation of Net Pay in Pay roll statement ?
(a) HRA (b) PF (c) DA (d) BP
Ans : (b) PF
Which of the following is not a component of Payroll statement ?
Ans :(b) D.B.
(a) D.A. (b) D.B. (c) H.R.A. (d) P.F.
K

	A	B	C	D	E	F
1	PAY ROLL
2	Emp ID	Name of Employee	Basic Pay	DA	HRA	Gross Pay
3	E0101	Renjith	70000	?	5000	?

Write the formula to calculate DA and Gross Pay of Renjith if the DA is 7% of Basic pay.

Ans : DA in D3 =C3*7%
Gross Pay in F3

=SUM(C3:E3) Or C3+D3+E3

Write the equation to calculate Gross Salary and Net Salary, if B.P. (Basic Pay), DA, HRA and PF are given in a payroll statement. (3 Marks)
Ans :Gross Salary = Basic Pay + DA + HRA
Net Salary = Gross Salary – PF
( 1 1⁄2 scores each for one answer – Max 3 scores )
Name the functions used for calculating depreciation under straight line and written down value methods. Also, write their syntax in a spread sheet.
Narne the Spreadsheet function used for calculating the annual depreciation fixed installment method.
Ans : SLN
Find the odd one.

(Hint : one which is not an element of gross pay)
(a) HRA (c) PF (b) CCA (d) DA
Ans : (c) PF

The details of sales is given below in the following spread sheet :

	A	B	C	D
1	Code	Name of Salesman	Sales	Commission
2	101	Praveen	62000	?
3	102	Jaffar	74000
4	103	Johny	68000
5		Total Sales	? (a)

Write the formula to calculate :

(a) Total Sales in cell C5.

(b) 10% Sales Commission to Praveen in cell D2. (2 Score -20 March)
Ans : a) =SUM(A2:A4) OR =A2+A3+A4
b) =C2*10/100 OR = C2*10

One of your friends argued that there is no difference between SLN and DB functions in Spreadsheet. Do you agree with this ? Substantiate your answer.
ANS: No
SLN – Used for calculating depreciation under straight line(fixed installment) method
Syntax is =SLN(Cost,Salvage,Life)
Cost – Acquisition /Purchase cost of assets
Salvage – residual balance after useful life of assets
Life – Effective life of assets that can be put to use

DB – Used for calculating depreciation under DIMINISHING balance method
Syntax is = DB(Cost,Salvage,LIfe,Period,Month)
Cost – Acquisition /Purchase cost of assets
Salvage – residual balance after useful life of assets
Life – Effective life of assets that can be put to use
Period – period in years for which year depreciation is calculated
Month – It is the number of months in the first year of depreciation (Optional)
Identify the function used to compute equated monthly installments (EMI) of a loan.

(a) NPv (b) ACCRINT (c) PMT (d) PV
Ans: (c) PMT

Arun Traders took a loan of ` 1,00,000 for 24 months from SBI @ 12% interest for that period.

(a) Identify the financial function used for preparing loan repayment schedule in calc.
(b) Give its Syntax and explain its parameters. (3 Score -20 March)
Ans :
a) PMT
b) =PMT(Rate,Nper,Pv,Fv,type)
Rate is the periodic interest rate (if annual rate is given,find monthly rate
Nper is the number of periods over which the loan or investment is to be paid.
PV is the present value of loan or investment.
FV (optional) is the desired value (future value) to be reached at the end of the periodic payments
Type (optional) is the due date for the periodic payments. 1 for beginning and 0 for end of the period.

Ch.4 – Chart and Graphs

A chart is given for you.

(a) Identify the name of above chart type.
(b) Briefly explain any two advantages of preparing charts. (3 Score -20 March)
Ans : a) Column Chart
b) Advantages of Chart
1- Visual appeal
2-Read the data easily
3-Analyse and interpret data quickly
4- Know the trends
A chart which displays data in rings is a
(a) Pie Chart (c) Radar Chart (b) Column Chart (d) Doughnut Chart
Ans: (d) Doughnut Chart
The chart used to display trends over a period of time is _______.

(a) Pie chart (b) Radar Chart (c) Area Chart (d) Line Chart
Ans : (d) Line Chart

Name any four elements of a spread-sheet graph or chart.
Identify the elements of a chart 1 to 4 from the following figure :

Ans: 1- Chart Title
2 – Data point/ Data Series /Plot area
3 – Legend
4 – X Axis

Write the steps to create a chart in Libre Office Calc. (3 Marks)
Ans: 1 – Open Libre office Calc , Application >Office>Libre office Calc
2 – Entering of Date
3 – Select the data
4 – Plotting Chart : Insert ->Chart wizard->Type -> Finish
Identify the name of charts mentioned in the following :

(a) Charts with vertical bars.
(b) Charts with horizontal bars.
Ans : a) Column Chart
b)Bar Chart

In most Spread-sheets, ‘Graphs and charts’ are available in ———-tab
Ans : Insert
Identify the chart that display data in rings.

(a) Bar Chart (b) Column Chart (c) Area Chart (d) Donut Chart
Ans : (d) Donut Chart

Write any 4 elements of a chart. (2Marks)
Ans : Chart Area, Plot Area, Data Point, Data Series, Data labels, Grid Lines, Chart title, Legend ( any 4 elements – 1⁄2 score for each answer)
Write any two uses of the Pivot table. (2Marks)
Ans : Data can be organised ,summarised data,required data is available,quick and easy availability of data.
List out any 4 types of charts that can be prepared with the help of Libre Office calc. (2Marks)
Ans : Column Chart, Bar Chart, Line Chart, Pie Chart (1/2 scores each – Max 2 scores)
List out any two advantages of preparing Graphs and Charts.
Write any two advantages of chart and graph.
Ans : 1- It helps to create visual appeal
2- It helps to read the date easily
3 – It helps to analyse and interact the data quickly
4 – It helps to know the trends easily
5 = It helps to grasp the data quickly.
Identify the suitable argument in a financial function representing the number of payments from the following :
(a) FV (b) PV (c) Rate (d) Nper (MAR 19)
Ans : (d) Nper
Can you help Mr. Ajith Kumar by pointing out the missing steps to create a chart in Spreadsheet from the following :
Enter the data in cells Select the data __________ __________ Finish. (MAR 19)
Ans : Insert , Chart

Ch.5 – Accounting Package GNUKhata

Identify the group under which depreciation account is to be created in an accounting software.
(a) Current Asset
(c) Direct Expenses
(b) Fixed Asset
(d) Indirect Expenses
Ans: (d) Indirect Expenses
In an accounting software, the ledger’s ‘cash’ comes under __________ group.
(a) Investments (b) Current Assets (c) Fixed Assets (d) Capital (MAR 19)
Ans : (b) Current Assets
Which of the following is not a system generated ledger account in GNUKhata ?
List out any two system generated ledger accounts in GNUKhata. (2 Score – 22 March)

(a) Opening Stock (b) Closing Stock (c) Cash (d) Profit and Loss Account
Ans: (c) Cash

Explain the purposes of using the following voucher types in GNUKhata :

(a) Receipt Voucher

(b) Payment Voucher

Ans : (a) Receipt Voucher – For Recording cash and bank receipts

(b) Payment Voucher – For recording cash and bank payments

Which of the following voucher is used to make rectification entries ?

(a) Purchase Voucher (b) Sales Voucher (c) Receipt Voucher (d) Journal Voucher
Ans : Journal Voucher

State the accounting groups of the following accounts in GNUKhata :

(a) Cash in hand

(b) Machinery
Ans : (a) Cash in hand – Current assets

(b) Machinery – Fixed assets

Explain any three features of computerised accounting system.
Ans : 1 – Simple and Integrated
2 – Transparency and control
3 – Accuracy and speed
4 – Scalability
5 – Security
Explain the purposes of using the following voucher types in GNUKhata :

(a) Receipt Voucher

(b) Payment Voucher

Ans : (a) Receipt Voucher – For Recording cash and bank receipts

(b) Payment Voucher – For recording cash and bank payments

(c) Contra Voucher – For recording cash and bank transactions /Contra transactions.
How to delete a Ledger Account in GNUKhata ?
Ans : Delta a ledger by selecting “Edit Account” from master menu.Select the ledger Acount to be deleted ,Click on “delete “ button and confirm the deletion.
Master ->Edit Account ->Select ledger -> Delete.
Briefly explain any three Voucher types used in GNUKhata.
Ans : Receipt,Payment,Contra,Sales,Purchase,Journal,sales return,Purchase return
Explain the uses of any five default accounting voucher types in an accounting software.
Ans :
Contra (F8)- Contra voucher is used to record transactions involving bank and cash accounts or between two bank accounts or two cash accounts.
Payments(F5):-Used to record allpayments.(cash/bank)
Receipt(F4):- Used to record receipt of cah (cash/bank)
Journal(F9):- Used to record adjusting and closing entries, purchase and sale of fixed asset on credit etc.usually it is used as a non cash voucher.
Sales(F6) :-Used to record sale of goods( cash and credit)
Purchase(F7) :– used to record all purchase of goods( cash and credit)
Debit note(CTRL+4): Used to record purchase return or discount rebate received
Credit note(CTRL+3) :-used to record sales return or discount or rebate allowed.
Find the suitable voucher type used for recording ‘Payment by cash or cheque’ from the following in GNUKhata accounting software.
(a) Receipt (b) Purchase (c) Payment (d) Sales
Ans : (c) Payment
tate the accounting groups of the following accounts in GNUKhata :

(a) Cash in hand

(b) Machinery
Ans : (a) Cash in hand – Current assets

(b) Machinery – Fixed assets

Explain any three features of computerised accounting system.
Ans : 1 – Simple and Integrated
2 – Transparency and control
3 – Accuracy and speed
4 – Scalability
5 – Security
Which of the following is not a system generated ledger account in GNUKhata ?

(a) Opening Stock (b) Closing Stock (c) Cash (d) Profit and Loss Account
Ans: (c) Cash

Which one of the following is a Free and Open Source Accounting Software ?
(a) Tally (b) GNU Khata (c) Peachtree (d) Daceasy
Ans: (b) GNU Khata
Give any two system generated ledger accounts in GNU Khata. (2Marks)
Ans : Closing stock
Opening stock
Stock at the beginning
P & L A/c

Write any 3 features of GNUKhata Accounting Software. (3 Marks)
Features of GNUkhata
a) It is a free and open source accounting software
b) It is based on double entry book keeping
c) Comprehensive financial reports are available like Ledgers, Trial balance, Profit and loss Account, Balance sheet etc.
d) Source document can be attached along with the voucher entry.
e) Export and import of data from Spreadsheet is possible.
f) Password security and data audit facility provided.
( any 3 features – one scores each Max. 3 scores)
Explain the procedure of ‘Company Creation: in GNU Khata
Ans : Click on “Create Organisation” tab and enter “Organisation Name “
Case : As Is

Organisation Type : Profit Making

Financial year :01-01-2016 to 31-12-2016

Select “ Accounts only” and click “Proceed” button

Methods of maintaining Accounts
Accounts only: Select this option if financial accounts only are to be maintained
After entering the details save the screen.

Name the system generated ledger accounts in GNUkhata. (2 Score -20 March)
Ans : 1 – Opening stock
2 – Closing stock
3 – Stock at the beginning
4 – Profit and Loss Account

Read the following transactions. Then make up the following table for voucher entry in GNU Khata.
(a) Started business with cash worth ` 2,00,000
(b) Opened an account in SBI with ` 10,000
(c) Purchased goods worth ` 20,000
(d) Paid wages ` 5,000
(e) Cash sales ` 15,000

Account Name	Voucher	Dr/Cr	Amount

Ans :

Devika Agencies already created an organisation in GNUkhata. Now they want to create ledger accounts. Write the procedure to create the following ledger accounts by preparing a table showing relevant groups and subgroups, assuming that there is no opening balances.

(1) Capital
(2) Furniture
(3) Cash
(4) Debtors
(5) Creditors
(6) Purchases
(7) Sales
(8) Salary

Ans :

No	Ledger Account	Group	Sub group
1	Capital	Capital	None
2	Furniture	Fixed asset	Furniture
3	Cash	Current asset	Cash
4	Debtors	Current asset	Sundry debtors
5	Creditors	Current liability	Sundry creditors for Purchase
6	Purchases	Direct expenses	None
7	Sales	Direct income	None
8	Salary	Indirect expenses	None

Complete the given table based on the hint given : (2Marks)

Name of Ledger	Group
A – Purchases	Direct expenses
B – Sales	?
C- Wages	?
D – Discount received	?
E – Salary	?

Ans : B – Direct Income
C – Direct Expenses
D – Indirect Income
E – Indirect expenses ( 1⁄2 score each for one answer – Max. 2 scores)

Ms. Sunitha, a Commerce student, while presenting a seminar on accounting software package, commented that the procedure for entering closing stock and opening stock are one and same. Do you agree ? Explain the procedure in detail.
Ans : No,Opening Stock:-The stock of goods available at the beginning of current financial year is termed as opening stock.It is treated as Direct expenses and appears in the debit side of P&L A/c.

Stock at the Beginning:-If the accounts of business are computerised for the first time,the amount of opening stock can be inserted through the following steps:

Step 1 – Edit the Stock at the beginning Account
Master – -> Edit Accounts–>Select ‘Stock at the beginning Account’-> Click on Edit->Enter the Opening Balance
Step 2- Voucher->select Journal Voucher-> Enter Voucher No.& Opening date -> Debit Opening stock and credit stock at the beginning.

Identify the group under which depreciation account is to be created in an accounting software.

(a) Current Asset (c) Direct Expenses (b) Fixed Asset (d) Indirect Expenses
Ans: (d) Indirect Expenses

Ch.6 – Database Management System

Briefly explain how a ‘Table’ is created in Libre Office Base. (First 4 steps). (4 Marks)
Ans : 1. Application > Office > LibreOffice Base
2. Click on Create Table in Design View
3.. Enter the Field Name
4.. Enter the Field Type
5. Enter the Field Properties
Explain the procedure for creating ‘Table’ in a database and how to set the primary key.
Ans: Open Base – Application – Office – Base
Create new database – Database wizard-create new database-next- enter Finish Button.
From the database panel select the object table under design view ,Enter field type – save the table by selecting primary key.
_______ is used to retrieve information from a data base.
Ans : Query
A Data Base Management System (DBMS) has different components. List out any four of them.
Ans : Table,Form,Query,Report,Macro
The tool used to connect two tables in Libre Office Base.
(a) Report (b) Queries (c) Form (d) Relationship
Ans : (d) Relationship
Write the different steps for creating a Table in Libre Office Base. (3 Score -20 March)
Ans: Steps to create table in Libre Office base
1 – OPen LIbreOffice Base – Application>Office>Libreoffice base
2 – Create Table – Click on table > Create table in design view
3 – Enter the field name > Field Type > Set the primary ke > save
A Data Base Management System (DBMS) has different components. List out any four of them.
Ans : 1- Table
2 – Form
3 – Query
4 – Report
Write the steps to create a ‘Student’ Table and set the primary key in Libre Office base from the following details :
Admission No.
Name
Sex
Date of Birth
Class
Ans : Steps :
1 – Open Libre Office Base – Application ->Office -> LO Base
2 – Create Table , Name Student , Table – design view
3 – Enter field name ,data type as :

Admission no: – Text / Number
Name – Test
Sex – List
Date of birth – Date and Time
Class – Text
4 – Save : Give name “TBL student” – Ok
Set Primary key to Admission no. – left -cursor-click

List out any four “data types” available in “Libre Office Base”. (2 Score -20 March)
Ans : Text,Number.Date.Time,yes/No,Memo
Explain the terms ‘Entity’ and ‘Attribute’ with an example.
Ans : Entity – Anything in the real world with independent existence.Ex: Car ,person,Student,Employee Etc
Attribute: These are additional characteristics that further describe an entity . Ex: Height,Weight.DOB of a person
Explain the purpose of creating the following elements in a database management system.

(a) Table
(b) Forms
(c) Queries
Ans :
(a) Table – Tables are used to store the data in the database
(b) Forms – Forms are used to add,view and edit the data in the database.
(c) Queries – Queries are used to retrieve the data from database.

Name any four ‘DBMS, software firms.
Ans : MS Access, LIbre Office base,Oracle, MY SQL /SQL server
What is DBMS ? Give a suitable example for it.
Ans : Database Management System. Ex : LIbreOffice Base, MS Access, Oracle, SQL Server etc.
State the need for data validation in spreadsheet.
Ans : It is used to control the mistakes and repetitions in data entry.
A Spreadsheet ‘3D’ chart has :
(a) ‘X’axis (b) Y axis (c) ‘Z’ axis (d) All of these
List out the objects available in the database panel of LibreOffice Base ?
Ans : Tables,Forms,Queries and Reports
Find the odcl otle alnong the computer software given below :
(a) GNU Khata b)) TallY (c) SAP (d) Libreoffice Base
methods of creating ‘FORMS’ in a data base software’
Ans: Forms : Forms are screens that allow viewing ,adding and updating the data stored in the table.
Forms can be created :-

Create Table in design view
Use wizard to create table
Click on Forms under Database – Use Wizard to create form– Select the table or query to add the fields into the form – Select appropriate options from the coming windows – Finish.

For Computerised Accounting Practical -Questions,Procedure and videos : www.comlive.in/cas