MABS Institution
11th Accountancy Weekly Test - 1 ( Computerised Accounting )-Aug 2020
-
-
-
-
-
-
-
-
-
-
-
-
-
-
What is meant by software?
-
Explain the codification of accounts.
-
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 are the three types, of procedures in a computer system?
-
-
Mr. Vivek took a loan of Rs.2,00,000 from State Bank of India, Chennai and number of instalments is 84 months. Calculate the rate assuming payments Rs.3,300 per month using the appropriate function.
-
The following table is given to you. Find solution for the following questions.
A B C D E F G H I J 1 550 156 852 584 TAX 573 GST 1234 2 340 1285 468 584 268 222 CASH BRS STOCK DEBT A) How many cells contain numbers only?
B) Count the number of cells that contain any value.
C) Count the number of cells containing the value exceeding 1000.
-
-
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
purchaseInstallation
chargeTransportation
chargeSalvage value Life in
years1. Machinery 200000 20000 5000 25000 10 2. Furniture 50000 4000 2000 5000 8 -
Explain the components of computerised accounting system.
-
-
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. -
Compare ready-to-use, customised and t.ailor-made accounting pacages.
-