Plus Two Computerised Accounting Solved Practical Questions

By HSSLiVE.IN - Tuesday, September 26, 2017 - 3 Comments

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 and fourth units deal with electronics spreadsheet 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 spread sheets.

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 Part A questions,Spread sheet files and Computerised Accounting Study Notes prepared by E Sasidharan,HSST Commerce,Karimpuzha HSS Thottara, Palakkad and Sirajudheen M,HSST,Commerce,Chakkalakkal HSS,Madavoor,Kozhikode are given here for downloading.

Part A Solved

Accounting Solved Practical Questions-Part A

Plus Two Commerce-Computerised Accounting-Practical Question Pool(Solved) (Part A) Prepared by Sasidharan E,HSST Commerce,Karimpuzha HSS Thottara,Palakkad

Plus Two Commerce-Computerised Accounting-Practical Question Pool(Part A Solved worksheet in Libre office Calc) Prepared by Sasidharan E,HSST Commerce,Karimpuzha HSS Thottara,Palakkad

QUESTION NO. 1
Given below is a table showing the Name, Designation and Monthly Salary paid for different employees in Royal Traders for March 2017.

Find out the following:
A) The total monthly salary using the Naming Function give the name as
“TOTAL_SALARY”
B) The total monthly salary paid to the Finance Manager (FM) in the firm
C) The Name of employee with monthly salary of ₹40,000 by using “LOOKUP”
Function

Procedure and Answers
i) Open Libre Office Calc.
ii) Enter column headings (Labels) in the spread sheet.
A1Name
of the Employee, B1Designation,
C1Monthly
salary and enter the all
details given in the questions.
iii) Select the range of cells (C2:C7)
iv) Data >
Define Range
v) Type “TOTAL_SALARY” against the Name box,in the dialogue box, Then click OK
button.
vi) Calculate total monthly salary in cell C8 by the formula
=SUM(TOTAL_SALARY)
Answer A) Total Salary ₹260,000
vii).Calculate the monthly salary paid to FM in the cell C9 by the formula
=SUMIF(B2:B7,”FM”,TOTAL_SALARY)
Answer B) Total Salary of FM ₹85,000
viii). The Name of employee with monthly salary of ₹40,000 in the cell C10 by the
formula
=LOOKUP(40000,TOTAL_SALARY,A2:A7)
Answer C) Employee Name is SIJO

QUESTION NO.2
Binu obtained the following Scores out of 100 in his Higher Secondary Examination,
March 2017

Convert the above Scores into Grades for each subject using the following criteria by
using IF function

Procedure and Answers
i) Open Libre Office Calc.
ii) Enter all Labels in the spread sheet A1Subjects,
B1Scores,
C1Grades
and enter all
the details as given in the questions
iii) Enter the formula in the cell C2
=IF(B2>=90,”A+”,IF(B2>=80,”A”,IF(B2>=70,”B+”,IF(B2>=60,”B”,
IF(B2>=50,”C+”,IF(B2>=40,”C”,IF(B2>=30,”D+”,IF(B2>=20,”D”,”E”))))))))
iv) To copy formula Select the range then press Key Stroke Ctrl+D
OR drag and copy the formula to the cells required
Answer

QUESTION NO.3
The Following Table is given to you find solution for the following Questions.

A) How many cells contains Numbers only
B) Count the Number of cells contains any value
C) Count the Number of cells containing the value exceeding 1000
Procedure and Answers
i) Open Libre Office Calc.
ii) Enter the data in cells from A1 to J2 as in the question
iii) To get the Number of cells contains Numbers only , Set the formula in B3
=COUNT(A1:J2)
Answer A) 12
iv) To get Number of cells that contains any value, Set the formula in B4
=COUNTA(A1:J2)
Answer B) 18
v) To get the Number of cells which have values exceeding 1000, Set the formula in B5
=COUNTIF(A1:J2,”>1000”)
Answer C) 2

QUESTION NO.4
From the following information create a Pivot Table to give country wise sales of the
products

Procedures and Answers
Step 1 Open Libre Office Calc
Step 2 Input the entire data into cells
Step 3 Select the entire data to create the pivot table
Step 4 Select Pivot Table from Data menu and then click on Create
Step 5 In the Pivot Table Layout, drag the available fields to the row field and data field
(only numerical values) in the desired position.
Step 6 By clicking on Source and Destination tab, we can select the Destination of
the pivot table, either in a new sheet or in a desired cell (Default destination is new
sheet)
Answer

QUESTION NO.5
The Following information relates to products of a business

Enter the details into a text file (Notepad/Text Editor) and import the same to a
Spreadsheet file
Procedure and Answers
i) Open a Text Editor file. Applications >
Accessories → Tex Editor
ii) Enter the given data in the Tex Editor file. In the first line give the column headings
separated by coma.
iii) In the next line onwards give the data separated by comma in each row .
iv) Save the Text Editor file with a file name. (e.g. .Product info)
v) Open worksheet in Libre Office Calc.
vi) File>
open>
(browse and select the note pad file) >
Open
(Text import Note pad file dialogue box will be displayed) then click OK
Answer

QUESTION NO.6
Ms. Sajeev intends to apply for Civil Service examination this year . But the upper age
limit is 32 as on 01/08/2016. Determine whether he is eligible to apply or not. Based
on the cut off age . His date of birth is 06/09/1982 using appropriate Spreadsheet
function
Procedure and Answers
Step 1 Open Libre Office Calc
Step 2 Enter the date in the spread sheet B101/
08/2016, B206/
09/1982
Step 3 Compute the date value of such date in B3 and B4 by the formula
B3=DATEVALUE(“01/08/2016”)
B4=DATEVALUE(“06/09/1982”)
Step 4 Calculate difference between these date values in the cell B5 by the formula
=B3B4
Step 5 Calculate the age of the person in the cell B6 by the formula
=Round(B5/365.25)
Step 6 Determine the Eligibility with the formula in cell E2
=IF(D2>=32,”Eligible”,”Not Eligible”)
ANSWER:AGE:
34
Not Eligible.

QUESTION NO.7
7 A) The following are the scores obtained by some students in s competitive
examination. Find out the HIGHEST, LOWEST, and AVERAGE score using
appropriate function in Spreadsheet.

7B) From the data given below Fill the Address in F2 using CONCATENATE Function

Procedure and Answers
7A)
i) Open Libre Office Calc
ii). Enter all given values as given in the question.
iii). Calculate the highest Score in cell B3 by the Formula
=MAX(B2:H2)
Answer Highest Score is 515
iv). Find the lowest rank in cell B4 by the Formula
=MIN(B2:H2)
Answer Lowest Score is 150
v). Find the Average mark in cell B5 by the formula
= AVERAGE(B2:H2)
Answer Average score 308
7B)
i).Open Libre Office Calc
ii). Enter all given values as given in the question.
iii). Enter the formula in the cell F2 as
=(CONCATENATE(A2," ",B2," ",C2," ",D2," ",E2))
Answer :JAYA
DEEPAM NEWSTREET KOZHIKODE 680534

QUESTION NO.8
8 A) From the following Table find out the basic pay of Mr. Ajith EMPCODE 1846
using VLOOKUP Function.

8 B) From the following details, Find out the actual profit for Quarter II using
HLOOKUP Function

Procedure and Answers
8A) i). Open Libre Office Calc
ii). Enter all Labels as, A1EmpCode,
B1Name,
C1BasicPay
and also enter all table
values in the corresponding cells.
iii). Find out the basic pay of EmpCode 1846 in the cell B7 by the Formula
=VLOOKUP(1846,A2:C5,3,0) OR
=VLOOKUP(1846,A2:C5,3,FALSE)
ANSWER: Basic Pay of employee with EmpCode 1846 is ₹8500
8B) i).Open Libre Office Calc
ii) Enter the all labels as B1Quarter
I, C1Quarter
II, D1Quarter
III, E1Quarter
IV, A2Total
Sales, A3Total
Cost and A4Profit,
then enter all table values in the
corresponding cells.
iii). Find the Profit of Quarter II in the cell B6 by the formula
=HLOOKUP(C1,B1:E4,4,FALSE) OR
=HLOOKUP(C1,B1:E4,4,0)
ANSWER : Actual profit for Quarter II ₹12000

QUESTION NO.9
The XYZ Company Ltd. Furnishes you the list of their employees and their taxable
income

Compute tax based on the following criteria by using appropriate function in
Spreadssheet.
A) If Taxable Income is below 250,000 Tax is NIL
B) If Taxable income is 250,000 to 500,000 Tax rate is 10%
C) If Taxable Income is above 500,000 Tax rate is 20%
Procedure and Answers
i).Open a new spread sheet in Calc.
ii). enter all labels in the spread sheet as A1Name,
B1Sex,
C1Taxable
Income and D1Tax,
Then enter all values in the corresponding cells.
Iii) select the cell D2 and type the formulas
=IF(C2>=500000,C2*20/100,IF(C2>=250000,C2*10/100,"NIL"))
iV) To copy formula Select range D2:D7 Press Ctrl+D.
Answer

QUESTION NO.10
Assume that your School have only Commerce and Science batches . You are required
to enter the following list of students after creating the data validation .
Data validation Rules are
a) Age should be between 15 and 20
b) The options must limit to Commerce and Science

Procedure and Answers
1) Open the new spread sheet.
2) Enter all labels in the spread sheet. A1Admission
No, B1Name,
C1Batches,
D1Age.
3) Enter Admission No from A2:A6 and Name from B2:B6
4) Select the range of cell C2:C6, then
5) Select validity from Data Menu then Set the dialogue box fields as
6) Allow cell ranges from validity window and input Source the ranges from F1 :F2
(the cells where Batches “Commerce”, and “Science” are entered.
7) Select the ranges from D2 : D6
8) Select validity from Data Menu then Set the dialogue box fields as
Allow : Select “whole Numbers”
Data : Select “Valid Range” enter minimum as “15” and maximum as “17”
Output

QUESTION NO.11
List of Debtors and the amount due from them are given below. Apply Conditional
formatting to high light receivables with date that have expired on 31/01/2016. Also
highlight the debts more than 35000 ₹ with red colour.

Procedure and Answers
Step i) Open LibreOffice Calc
Step ii) Enter labels in the spread sheet A1Sl.
No, B1Name,
C1Amount
and D1 31/01/2016. Then enter corresponding values
Step iii) Select the range D2:D6, select Conditional Formatting from Format menu
click on Condition
Set the condition in dialogue box
Select Cell value is >
less than>
click on the next column and select Cell D1
In apply style select new style from the drop down menu and click on Background
and select RED colour then Click on OK button.
Step v) Select the range C2:C6, Select Conditional Formatting from Format menu
click on Condition
Set the condition in dialogue box
Select Cell value is > greater than and enter the amount in column 35000
In apply style select new style from the drop down menu and click on Background
and select RED colour then Click on OK button.
Output

QUESTION NO.12
A company proposes to invest 10,00,000 by installing a plant and machinery with
expected cash inflow of Rs. 400,000 and Rs. 350,000 ₹275,000 and 225,000
respectively for 4 years of its life . Find out the Net Present Value of the project using
appropriate Spreadsheet Function. The Normal rate of return of business is 20%
Procedure and Answers
1).Open LibreOffice Calc.
ii) Enter the values as given below

iii) Apply the formula
=NPV(B1,B2,B3,B4,B5,B6) then press Enter.
Output ₹
1,29,967.21.

QUESTION NO.13
Consider the following information
Loan amount ₹300,000
No. Of Payment periods 48 months
Annual Rate of interest 10%
Prepare a one variable table showing the repayment of the above loan in different
number of payment such as 12 months, 24 months, 36 months 48 months 60 moths
and 72 months Use PMT Function
Procedure and Answers
i) Open Libreoffice Calc.
ii) Enter labels A1:A4 Loan amount, Annual rate, Type, No of payment and fill all
corresponding cell with the values
iii) Select cell A7 and cell B7, Give label “No of Months” and “Monthly Instalments”
respectively.
iv) Select cells A9:A14, enter No of months (12,24,36,48,60,72) in the respective
column.
v) Select the cell B6, Enter the formula, =PMT(B2/12,B4,B1,B3)
Returns the value ₹
7608.78
vi) Select cell A8:B14, Click on Data Menu then Click on Multiple Operation.
Set the dialogue box as
Formula: $B$6
Row Input cell: Leave it Blank
Column Input cell: $B$4 Press OK

QUESTION No. 14
Mr. ShyamLal took a loan of 200,000 fro State Bank of India ₹ Cherukara and No of
Instalments is 84 months. Calculate the rate assuming payments ₹3300 per month using
appropriate appropriate Function
Procedure and Answers
i).Open Libreoffice Calc.
ii). Enter values in the cells as given below

iii) Compute RATE in the cell B4 by the formula
=RATE(B1,B2,B3,B4,B5)
Returns 0.82%
iv) multiply by 12 to convert rate into Annual rate
=B6*12 OR =RATE(B1,B2,B3,B4,B5)*12
Output 10%

Part B Solved

Accounting Solved Practical Questions-Part B

Plus Two Commerce-Computerised Accounting-Practical Question Pool(Part B Solved worksheet in Libre office Calc) Prepared by Sasidharan E,HSST Commerce,Karimpuzha HSS Thottara,Palakkad

Related Downloads

Plus Two Commerce-Computerised Accounting-Database Management system using MS-Access(Class Notes and Practicals) by Sirajudheen

Plus Two Commerce-Computerised Accounting-Database Management System using Base(Class Notes and Practicals) by Sirajudheen

Plus Two Commerce-Computerised Accounting-Solved Practical Model Questions by Alrahiman

Plus Two Commerce-Computerised Accounting-Solved Practical Model Questions by Johnson Koshy

Plus Two Commerce-Computerised Accounting-Spread sheet- Study Notes and Practical Works (Explained using Ms-Excel and Libre office Calc, 35 MB) Prepared by Sirajudheen M,HSST Commerce, Chakkalakkal HSS,Madavoor,Kozhikkode

Accountancy & Computerised Accounting Practical Exam Guidelines 2017-18 & Practical Question Pool

Computerised Accounting Notes

Accountancy Class Notes