# Plus Two Computerised Accounting Solved Practical Questions

Recently DHSE published

**Part A Solved**

**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

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**

**Related Downloads**

### Share This:

Advertisement

## No Comment to " Plus Two Computerised Accounting Solved Practical Questions "