11th Accountancy Monthly Test - 1 ( Computerised Accounting )

MABS Institution

11th Accountancy Monthly Test - 1 ( Computerised Accounting )-Aug 2020

Time : 2.30 Hours

Part - A

Multiple Choice Question - Answer All Question

In accounting, computer is commonly used in the following areas:

Recording of business transactions
Payroll accounting
Stores accounting
All the above

__________ packages are used by medium or large business enterprises.

Tailor made
customised
Ready-made
None of these

Components of CAS can be classified into _______ categories.

Six
Seven
Five
Three

Which one of the following is not a method of codification of accounts?

Access codes
Sequential codes
Block codes
Mnemonic codes

_________code, a range of numbers K partitioned into a desired number of sub-ranges and each sub-range is allotted to a specifc group.

Mnemonic codes
Block codes
Sequential codes
None of these

Which one is not a component of computer system?

Input unit
Output unit
Data
Central Processing Unit

Which device of computer operation dispenses with the use of the keyboard?

Joystick
Mouse
Light Peri
Touch pen

Which of the following produces high-quality output?

Impact Printer
Non-Impact Printer
Both (a) and (b)
one of the above

A computer system mainly has _________ components.

two
three
four
five

Tally package was developed by________

Tally solutions
Microsoft
Apple solutions
None of the above

Part - B

Generic 2 - Answer All Question

What is coding?

What is accounting software?

Give two examples each of the organisation whereready-to-use, 'customised' and 'tailored' accounting packages respectively are suitable to perform the accounting activity.
State the relationship between information and decision.

What is grouping of accounts?

What is a computer?

Language syntax is checked by which software?

What is hardware?

What is CAS?

Expands of MIS and CPU.

Part - C

Generic 3 - Answer All Question

The following are the scores obtained by some students in a competitive examination. Find out the average, the highest and the lowest score using appropriate function in spreadsheet.

A B C D E F G H

1 NAME Anbu Balu Gobu Ramu Somu Raju Anu

2 SCORES 60 80 164 192 104 64 204

Mention any three advantages of CAS.

Mention any three limitations of computerised accounting system.

Type the given below passage in MS-Word and format as directed.
Fra Luca Bartolomeo de Pacioli was an Italian mathematician (1447 – 1517). He is referred to as The Father of Accounting and Bookkeeping in Europe and he was the first person to publish a work on the double-entry system of bookkeeping.

What is opearating system? Give two examples.
Give the Block diagram of computer.

What are the types of people interacting with a computer system?

State the input and output devices of a computer system.

Find out from the following data, minimum collection of Rs.500 on any one day achieved by the sales counters.

Counter Day 1 sales Day 2 sales

Ground floor 600 600

First floor 850 300

Second floor 350 400

Explain the types of People Interact.

Part - D

Generic 5 - Answer All Question

From the data given below
i) Fill the address in B3 using CONCATENATE Function.
ii) Change KAMARAJAR SALAI given in C2 as lower case in C3
iii) Change Chennai given in D2 as upper case in D3

A B C D E

1 NAME HOUSE NO. STREET PLACE PINCODE

2 ANAND 123 KAMARAJAR SALAI Chennai 600018

Differentiate manual accounting with computerised accounting system.

Explain briefly the features of computerised accounting system.

Discuss the advantages of computerised accounting system in a business organisation.

Discuss the various categories of accounting packages.

The total sales volume (Product wise) of TECH Ltd for the year 2016-2017 is given below:

Product Sales

Toothpaste 22000

Toothbrush 11000

Hair Oil 9000

Shampoo 13000

Toilet Soap 9500

a) Present the data in a column chart
b) Change the chart type to line chart.
Prepare invoice for the following items.
1. Financial Accounting – RL Gupta - 40 Nos.
2. Advanced Accounting – MC Shukla - 20 Nos.
3. Income Tax Law & Practice – HC Mehrotra - 20 Nos.
4. Practical Auditing – B N Tandon - 30 Nos.

Product	Sales
Toothpaste	22000
Toothbrush	11000
Hair Oil	9000
Shampoo	13000
Toilet Soap	9500

Explain the components of computerised accounting system.

Calculate depreciation under Straight Line Method using Spreadsheet based on the details given below.

A B C D E F

Asset Cost of
purchase Installation
charge Transportation
charge Salvage value Life in
years

1. Machinery 200000 20000 5000 25000 10

2. Furniture 50000 4000 2000 5000 8

A	B	C	D	E	F
Asset	Cost of purchase	Installation charge	Transportation charge	Salvage value	Life in years
1. Machinery	200000	20000	5000	25000	10
2. Furniture	50000	4000	2000	5000	8

Prepare payroll of the following employees.

A B

1 Name Basic pay(Rs.)

2 Sasi 8000

3 Hari 10000

4 Karthi 6500

5 Viji 12000

6 Soni 9000

Additional information:
a. DA: 125% of basic pay
b. HRA: Rs.4,000 for employees basic pay greater than Rs.8,000, for others Rs.2,500.
c. PF Contribution: 12% of basic pay and DA
d. TDS: 10% for Gross pay greater than Rs.25,000, otherwise NIL.

Comment

Add Comment

	A	B	C	D	E	F	G	H
1	NAME	Anbu	Balu	Gobu	Ramu	Somu	Raju	Anu
2	SCORES	60	80	164	192	104	64	204

Counter	Day 1 sales	Day 2 sales
Ground floor	600	600
First floor	850	300
Second floor	350	400

	A	B	C	D	E
1	NAME	HOUSE NO.	STREET	PLACE	PINCODE
2	ANAND	123	KAMARAJAR SALAI	Chennai	600018

	A	B
1	Name	Basic pay(Rs.)
2	Sasi	8000
3	Hari	10000
4	Karthi	6500
5	Viji	12000
6	Soni	9000

InstaQB

Institutions

12th Standard English Medium

12th Standard Tamil Medium

11th Standard English Medium

11th Standard Tamil Medium

10th Standard English Medium

9th Standard English Medium

8th Standard English Medium

7th Standard English Medium

Class XII

Class XI

12Th Standard

11Th Standard

10Th Standard

9Th Standard

11th Accountancy Monthly Test - 1 ( Computerised Accounting )

MABS Institution

11th Accountancy Monthly Test - 1 ( Computerised Accounting )-Aug 2020

Part - A

Multiple Choice Question - Answer All Question

In accounting, computer is commonly used in the following areas:

__________ packages are used by medium or large business enterprises.

Components of CAS can be classified into _______ categories.

Which one of the following is not a method of codification of accounts?

_________code, a range of numbers K partitioned into a desired number of sub-ranges and each sub-range is allotted to a specifc group.

Which one is not a component of computer system?

Which device of computer operation dispenses with the use of the keyboard?

Which of the following produces high-quality output?

A computer system mainly has _________ components.

Tally package was developed by________

Part - B

Generic 2 - Answer All Question

What is coding?

What is accounting software?

Give two examples each of the organisation whereready-to-use, 'customised' and 'tailored' accounting packages respectively are suitable to perform the accounting activity.

State the relationship between information and decision.

What is grouping of accounts?

What is a computer?

Language syntax is checked by which software?

What is hardware?

What is CAS?

Expands of MIS and CPU.

Part - C

Generic 3 - Answer All Question

The following are the scores obtained by some students in a competitive examination. Find out the average, the highest and the lowest score using appropriate function in spreadsheet. A B C D E F G H 1 NAME Anbu Balu Gobu Ramu Somu Raju Anu 2 SCORES 60 80 164 192 104 64 204

Mention any three advantages of CAS.

Mention any three limitations of computerised accounting system.

What is opearating system? Give two examples.

Give the Block diagram of computer.

What are the types of people interacting with a computer system?

State the input and output devices of a computer system.

Find out from the following data, minimum collection of Rs.500 on any one day achieved by the sales counters. Counter Day 1 sales Day 2 sales Ground floor 600 600 First floor 850 300 Second floor 350 400

Explain the types of People Interact.

Part - D

Generic 5 - Answer All Question

From the data given below i) Fill the address in B3 using CONCATENATE Function. ii) Change KAMARAJAR SALAI given in C2 as lower case in C3 iii) Change Chennai given in D2 as upper case in D3 A B C D E 1 NAME HOUSE NO. STREET PLACE PINCODE 2 ANAND 123 KAMARAJAR SALAI Chennai 600018

Differentiate manual accounting with computerised accounting system.

Explain briefly the features of computerised accounting system.

Discuss the advantages of computerised accounting system in a business organisation.

Discuss the various categories of accounting packages.

The total sales volume (Product wise) of TECH Ltd for the year 2016-2017 is given below: Product Sales Toothpaste 22000 Toothbrush 11000 Hair Oil 9000 Shampoo 13000 Toilet Soap 9500 a) Present the data in a column chart b) Change the chart type to line chart.

Prepare invoice for the following items. 1. Financial Accounting – RL Gupta - 40 Nos. 2. Advanced Accounting – MC Shukla - 20 Nos. 3. Income Tax Law & Practice – HC Mehrotra - 20 Nos. 4. Practical Auditing – B N Tandon - 30 Nos.

Explain the components of computerised accounting system.

Calculate depreciation under Straight Line Method using Spreadsheet based on the details given below. A B C D E F Asset Cost of purchase Installation charge Transportation charge Salvage value Life in years 1. Machinery 200000 20000 5000 25000 10 2. Furniture 50000 4000 2000 5000 8

Comment

Other Study material

11th Accountancy Monthly Test - 2 ( Rectification

11th Accountancy Weekly Test - 2 ( Rectification o

11th Accountancy Weekly Test - 3 ( Rectification o

11th Accountancy Weekly Test - 4 ( Rectification o

11th Accountancy Monthly Test - 1 ( Rectification

11th Accountancy Weekly Test - 1 ( Rectification o

11th Accountancy Monthly Test - 4 (Computerised Ac

11th Accountancy Monthly Test - 3 ( Depreciation A

11th Accountancy Monthly Test - 2 ( Depreciation A

11th Accountancy Monthly Test - 1 ( Depreciation A

11th Accountancy Weekly Test - 4 ( Depreciation Ac

11th Accountancy Weekly Test - 3 ( Depreciation Ac

11th Accountancy Weekly Test - 2 ( Depreciation Ac

The following are the scores obtained by some students in a competitive examination. Find out the average, the highest and the lowest score using appropriate function in spreadsheet.

A B C D E F G H

1 NAME Anbu Balu Gobu Ramu Somu Raju Anu

2 SCORES 60 80 164 192 104 64 204

Find out from the following data, minimum collection of Rs.500 on any one day achieved by the sales counters.

Counter Day 1 sales Day 2 sales

Ground floor 600 600

First floor 850 300

Second floor 350 400

From the data given below
i) Fill the address in B3 using CONCATENATE Function.
ii) Change KAMARAJAR SALAI given in C2 as lower case in C3
iii) Change Chennai given in D2 as upper case in D3

A B C D E

1 NAME HOUSE NO. STREET PLACE PINCODE

2 ANAND 123 KAMARAJAR SALAI Chennai 600018

The total sales volume (Product wise) of TECH Ltd for the year 2016-2017 is given below:

Product Sales

Toothpaste 22000

Toothbrush 11000

Hair Oil 9000

Shampoo 13000

Toilet Soap 9500

a) Present the data in a column chart
b) Change the chart type to line chart.

Prepare invoice for the following items.
1. Financial Accounting – RL Gupta - 40 Nos.
2. Advanced Accounting – MC Shukla - 20 Nos.
3. Income Tax Law & Practice – HC Mehrotra - 20 Nos.
4. Practical Auditing – B N Tandon - 30 Nos.

Calculate depreciation under Straight Line Method using Spreadsheet based on the details given below.

A B C D E F

Asset Cost of
purchase Installation
charge Transportation
charge Salvage value Life in
years

1. Machinery 200000 20000 5000 25000 10

2. Furniture 50000 4000 2000 5000 8