Free Printable Accounts and Finance

1.

Do you have experience of working in Tally?

a)

yes

b)

no

2.

Do you have experience of working in MS Excel?

a)

Yes

b)

No

3.

Do you have experience of working in MS Word?

a)

Yes

b)

No

4.

Do you have knowledge of basic formulas of Subtotal in Excel?

a)

Yes

b)

No

5.

Do you have knowledge of basic formulas of Vlookup in Excel?

a)

Yes

b)

No

6.

Do you have knowledge of basic formulas of Sumif in Excel?

a)

Yes

b)

No

7.

Do you have knowledge of basic formulas of Filter in Excel?

a)

Yes

b)

No

8.

Do you have knowledge of basic formulas of Sorting in Excel?

a)

Yes

b)

No

9.

Do you have knowledge of basic formulas of Pivot in Excel?

a)

Yes

b)

No

10.

Mohan started business with cash

a)

Cash a/c…… DR

To capital ….a/c

b)

Capital a/c…DR

To cash….a/c

c)

Bank a/c….DR

To cash…..a/c

d)

Mohan a/c….DR

To business….a/c

11.

Purchase goods for cash

a)

Purchase a/c…..DR

Creditors……a/c

b)

Goods a/c……Dr

To cash…..a/c

c)

Purchase a/c…..DR

To Cash……a/c

d)

Creditors a/c…..DR

To Purchase ……a/c

12.

Received interest in cash from Ram

a)

Interest a/c……DR

To Cash……a/c

b)

Ram a/c…..DR

To Interest ……a/c

c)

Cash a/c….DR

To Interest…….a/c

d)

Cash a/c…DR

To Ram……a/c

13.

Sold goods to Ashok

a)

Sales a/c….Dr

To Ashok……a/c

b)

Cash a/c……DR

To Sales……a/c

c)

Ashok a/c…….Dr

To Sales….a/c

d)

None of this

14.

Purchase furniture for cash

a)

Purchase a/c…..DR

To Cash……a/c

b)

Cash a/c……DR

To Purchase …….a/c

c)

Purchase a/c…..DR

To Creditors……a/c

d)

Purchase a/c……DR

To Cash……a/c

15.

Wages paid

a)

Wages a/c….DR

To Creditors…….a/c

b)

Wages a/c…..Dr

To cash……a/c

c)

Bank a/c……DR

To Wages……a/c

d)

None of this

16.

Borrowed from Naresh

a)

Naresh a/c……Dr

To borrowed ……a/c

b)

Loan a/c….. Dr

To Bank ……a/c

c)

Cash a/c…..Dr

To Loan From Naresh…..a/c

d)

Naresh a/c…..Dr

To Loan From Naresh….a/c

17.

Sold goods to Shyam on credit

a)

Sales a/c….Dr

To Shyam…..a/c

b)

Shyam a/c….Dr

To Sales…..a/c

c)

Shyam a/c….Dr

To Cash…….a/c

d)

Cash a/c….Dr

To Sales…..a/c

18.

Withdrew Cash from Bank for office use

a)

Bank a/c…..Dr

To Cash….a/c

b)

Drawing a/c…..Dr

To capital …….a/c

c)

Cash a/c…..Dr

To Bank…..a/c

d)

Capital a/c….Dr

To drawing …..a/c

19.

Paid interest on Loan

a)

Bank a/c…..Dr

To cash…..a/c

b)

Interest a/c….Dr

To interest payable

c)

Bank a/c…Dr

To Interest…..a/c

d)

Interest a/c…..Dr

To Bank…..a/c

20.

Depreciation on Furniture

a)

Furniture a/c….Dr

To Depreciation….a/c

b)

Depreciation a/c….Dr

To Profit&loss….a/c

c)

Profit&loss a/c…..Dr

To Depreciation….a/c

d)

Depreciation a/c….Dr

To furniture….a/c

21.

Purchase return

a)

Creditor a/c….Dr

To purchase…..a/c

b)

Purchase a/c….Dr

To creditors….a/c

c)

Debtors a/c….Dr

To creditors…..a/c

d)

Cash a/c….Dr

To purchase….a/c

22.

Rent paid to nitin by cheque

a)

Nitin a/c….Dr

To cash…..a/c

b)

Rent a/c……Dr

To Nitin

c)

Nitin a/c….Dr

To Rent ….a/c

d)

Rent a/c….Dr

To Bank….a/c

23.

Received from Debtors by cheque

a)

Debtors a/c….Dr

To Bank….a/c

b)

Cash a/c….Dr

To Debtors….a/c

c)

Debtors a/c….Dr

To sales return….a/c

d)

Bank a/c….Dr

To Debtors….a/c

24.

5000rs due from Ramesh are irrecoverable

a)

Cash a/c…..Dr

To ramesh…..a/c

b)

Ramesh a/c……Dr

To bank…..a/c

c)

Baddebt a/c….Dr

To cash…..a/c

d)

Baddebt a/c….Dr

To Debtors…… a/c

25.

Withdrawn goods for personal use.

a)

Purchase a/c….Dr

To cash….a/c

b)

Purchase a/c….Dr

To creditors ….a/c

c)

Drawings a/c….Dr

To purchase …….a/c

d)

Purchase a/c…..Dr

To Drawings…..a/c

26.

What is the shortcut key for 'Page up' in Excel?

4 lines

27.

What is the shortcut key for 'Page down' in Excel?

4 lines

28.

What is the shortcut key for 'Sum' in Excel?

4 lines

29.

What is the shortcut key for 'Find/Replace' in Excel?

4 lines

30.

What is the shortcut key for 'Insert a row' in Excel?

4 lines

31.

What is the shortcut key for 'deletion of a column' in Excel?

4 lines

32.

Write the Journal Entry for the following:

Purchase Goods by Mr Y located at Kolkata from Mr. X located at Delhi whose taxable value is worth Rs. 1,00,000/- and GST applicable on such Purchase is 18% on 10.08.2021. Payment of Rs. 1,10,000 Made in Full and Final Settlement on 01.09.2021 (Pass Journal Entry in the Books of Y)

4 lines

33.

Write the Journal Entry for the following:

Good Sold to Mr. Y, Located in Kolkata by Mr. A Located in Kolkata ,Worth Taxable Value Rs. 50,000/- (GST Applicable @ 18%) on 01st October,2021. Total Amount received in Bank on 11th November,2021. (Pass entries in the Books of Mr. A)

4 lines

34.

Write the Journal Entry for the following:

Cash Deposited into Bank amounting to Rs. 80,000/- on 8th November,2021.

4 lines

35.

Write the Journal Entry for the following:

Expenses w.r.t. Professional Fees for the period April’21 to September’21 amounting to Rs. 2,00,000/- to be paid to Mr. Z. Pass the journal Entry along with the Relevant TDS Provision.

4 lines

36.

Write the Provisions & Percentage of the Following TDS Sections :-

I. 194C

II. 194J

III. 194I

4 lines

37.

Draft a Mail for Asking Client to provide us the Documents required for the purpose of Audit of Accounts.

4 lines

Accounts and Finance

Total questions: 37

Worksheet time: 1hrs 20mins

Similar Resources on Wayground