CBSE Sample Papers For Class 12 Accountancy Mock Paper 1

Q1. P and Q are in partnership sharing profits equally. R is admitted as a new partner. R brings ₹ 30,000 as his share of goodwill for 1/4^th share in cash which is entirely credited to the Capital Account of P. What will be the New profit-sharing ratio?

(a) 1:2:1

(b) Equal

(c) 1:1:4

(d) 2:1:1

Ans:

Answer (a)

Explanation:

R’s entire share is contributed by the P.New ratio =P=21​−41​=41​Q=21​R=41​

Q2. Assertion (A): Partnership is the relation between persons who have agreed to share the profits of a business carried on by all or any of them acting for all.

Reason (R): It is defined in the partnership Act, 1932.

In the context of the above two statements, which of the following is correct?

(a) Assertion (A) and Reason (R) are correct, but Reason (R) is not the correct explanation of Assertion (A).

(b) Both Assertion (A) and Reason (R) are correct, and Reason (R) is the correct explanation of Assertion (A).

(c) Assertion (A) is correct, but Reason (R) is not correct.

(d) Both Assertion (A) and Reason (R) are not correct.

Ans: b)

explanation: business of the partnership can be carried on by all the partners or by any of them for all the partners. In other words, partners are agents as well as the principals.

Q3. A company forfeited 1,000 shares of ₹ 10 each at a premium of ₹ 2 each fully called ₹ 5 (including premium) has been paid, the amount shown under the ‘Calls unpaid Account’ will be

(a) ₹ 2,000.

(b) ₹ 5,000.

(c) ₹ 7,000.

(d) ₹ 9,000.

OR
Debentures against which a charge has been created on assets of company, are called

(a) unsecured debentures.

(b) secured debentures.

(c) shares.

(d) shares charged by specific assets.

Ans: (c) ₹ 7,000.

Explanation: The price of a share is ₹ 12 (including premium) and ₹ 5 (including premium) has been paid. The amount left unpaid per share is ₹ 7.

OR
Answer (b) secured debentures.

Explanation: Secured debentures are those which are secured either on a particular asset or on all the assets of the company in general.

Q4. Param is a partner in a firm, he withdraws ₹3,000 at the starting of each month for 12 months. The books of the firm closes on 31st March every year. Calculate the interest on drawings, if rate of drawings is @ 10%.

(a) ₹2000

(b) ₹ 2950

(c) ₹ 1900

(d) ₹ 1950

OR
X, Y and Z are partners in a firm. There was a dispute among the partners at the time of division of profits for the year. The amount of profits before interest on partners’ capital was ₹6,000. Y computed interest @ 24% p.a. on his loan of ₹80,000. There was no agreement on this point. The amount payable to X, Y and Z is

(a) ₹2,000 to each partner.

(b) Loss of ₹4,400 for X, and Z and Y will take home ₹14,800.

(c) ₹400 for X, ₹5,200 for Y and ₹400 for Z.

(d) ₹2,400 to each partner.

Ans:

Answer (d)

Explanation:

Calculation of Interest on drawings of Param:

Total amount withdrawn = ₹ 3000 X 12 =  ₹ 36,000

Interest on drawings = ₹ 36,000 X 6.5/12 X 10%

= ₹ 1,950

OR
Answer: (c)

Explanation:

Interest on loan will be given to Y @ 6% p.a. and the rest of the profits will be divided among the partners equally.

Q5. One of the following, items, which appears on the debit side of the capital account of a partner, when capitals are fluctuating, is?

(a) share of loss.

(b) share of profit.

(c) salary to a partner.

(d) commission to a partner.

Ans:

Answer: (a)

Explanation: When capitals are fluctuating, share of loss appears on the debit side of the capital account of a partner.

Q6. A company has ₹ 4,40,000, 7.5% Debentures of ₹ 100 each of which 25% the amount is due for redemption at a premium of 10%. The company has in its Debenture Redemption Reserve Account a balance of ₹ 45,500. The minimum amount of profit required to be transferred to Debenture Redemption Reserve before the redemption begins will be

a. ₹ 27,500

b. ₹64,500

c. ₹30,250

d. NIL

OR

A company secured a loan of ₹ 25,90,000 from a Bank on mortgage of Plant and machinery and issue of 9,000, 6% Debentures of ₹ 100 each as collateral security. While passing the journal entry, the account to be debited will be

a. Debenture suspense account with ₹ 9,00,000

b. 6% debentures account with ₹ 9,00,000

c. Bank loan account with ₹ 25,90,000

d. Debenture suspense account with ₹ 25,90,000

Ans: The minimum amount required = 4,40,000 x 25/100 = ₹ 1,10,000. Since there is already a balance of ₹ 45,500 in the DRR. Amount required to be transferred = 1,10,000 – 45,500 = ₹ 64,500.

OR

Q7. A company invited applications for 1,00,000 shares and it received applications for 1,50,000 shares. Applications for 30,000 shares were rejected and the remaining were allotted shares on prorate basis. How many shares an applicant for 3,000 shares will be allotted?

a. 2,500 shares

b. 3,600 shares

c. 2,000 shares

d. 4,500 shares

Ans: He will be allotted lesser number of shares as he has applied for 3,000 shares.

3000 x 1,00,000/ 1,20,000 = 2,500 shares

Q8. He will be allotted lesser number of shares as he has applied for 3,000 shares.

3000 x 1,00,000/ 1,20,000 = 2,500 shares

Ans:

OR

Amount should be credited to A and B = ₹3,000 and ₹1,000 (= ₹4,000)

Amount wrongly credited as profit is ₹2,000 each (₹4,000 divided equally)

Q9. M and N are partners in a firm. Their capitals were

₹ 2,20 000 and $₹$1,98,000  M was to get a commission of 10% on the net profits before charging any commission. However, N was to get a commission of 10% on the net profits after charging all commissions.

Fill in the missing figures in the following Profit & Loss Appropriation Account for the year ended 31^st March, 2021:

N’s Commission will be-

(a) ₹18,000

(b) ₹1,98,000

(c) ₹2,20,000

(d) ₹90,000

Ans: The correct option is (a).

$WorkingNotes:(i)CalculationofprofitbeforecharginganycommisionMsCommission@10\%onthenetprofitsbeforecharginganycommission=₹22,000\therefore TotalProfitbeforecharginganycommission=₹22,000\times \genfrac{}{}{0ex}{}{100}{10}=₹2,20,000(ii)CalculationofNscommissionProfitafterchargingMscommission=₹1,98,000\left(₹2,20,000-22,000\right)CommissionofN=₹1,98,000\times \genfrac{}{}{0ex}{}{10}{110}=₹18,000$

Q10. M and N are partners in a firm. Their capitals were M was to get a commission of 10% on the net profits before charging any commission. However, N was to get a commission of 10% on the net profits after charging all commissions.

Fill in the missing figures in the following Profit & Loss Appropriation Account for the year ended 31^st March, 2021:

N’s share of profit will be: –

(a)

₹ 90,000​

(b)

₹ 1,80,000

(c)

₹ 36,000​

(d)

₹18,000

Ans: The correct option is (a).

explanation:

Total profit before charging any commission of M – M’s Commission – N’s Commission

(2,20,000 – 22,000 – 18,000) = 1,80,000/2 = 90,000

Q11. A, B and C are partners sharing profits and losses equally. According to the partnership agreement, B is to get a minimum amount of ₹25,000 as his share of profits every year.

The net profit for the year ended 31^st March 2021 amounted to ₹60,000.

Determine the excess of the guaranteed amount which will be borne by A and B in their profit-sharing ratio.

a. ₹5,000

b. ₹20,000

c. ₹25,000

d. ₹30,000

Ans:

Share of profit (1:1:1)

A = ₹20,000

B = ₹20,000

C = ₹20,000

Since the minimum amount guaranteed to C is ₹25,000. The excess of guaranteed amount is

₹25,000 – ₹20,000 =₹ 5,000

Q12. H Ltd. issued 20,000 shares of ₹10 each payable ₹2 on application and ₹5 on allotment. Applications received were for 24,000 shares and pro-rata allotment was made to all the applicants. Money over paid on application will be utilised for sum due on allotment. Ramesh to whom 400 shares were allotted failed to pay allotment and his shares were forfeited immediately. The amount of share forfeiture account will be

a. ₹800.

b. ₹960.

c. ₹1,600.

d. ₹1,920.

Ans: Ramesh has applied for 480 shares.

Hence the amount paid by him will be 480 x ₹2 = ₹960.

Q13. A company purchased a running business from Tee Ltd. for a sum of ₹ 6,65,000 payable ₹  1,65,000 by a cheque and balance by the issue of fully paid 8% Debentures of ₹ 100 each at a premium of 25%. In this case securities premium reserve account will be credited with

a. ₹ 4,00,000

b. ₹ 1,00,000

c. ₹ 1,66,250

d. ₹ 1,25,000

Ans: Value of debentures to be issued = 6,65,000 – 1,65,000 = ₹ 5,00,000.

s + 25 % of x = ₹ 5,00,000

x = ₹  4,00,000 Premium = 25 % of 4,00,000 = ₹ 1,00,000

Q14. A and B are in partnership sharing profits and losses equally. The capitals of A and B after all adjustments is ₹1,20,000 each. They admit C as a third partner who is to contribute proportionate capital to acquire a 1/5^th share of capital of the new firm equally from A and B. What will be the capital to be brought in by C?

a. ₹60,000

b. ₹1,20,000

c. ₹2,40,000

d. ₹3,00,000

Ans:

Let the total share = 1

Samira’s share = 1/5

Remaining share of A and B = 1-1/5 = 4/5

Adjusted combined capital of Aand B = ₹2,40,000

Computing the total capital of the new firm

= ₹2,40,000 x 5/4 (Reciprocal of total share of A and B) = ₹3,00,000

Proportionate capital of C = ₹3,00,000 x 1/5 = ₹60,000

Q15. P and Q are partners in a firm with the capitals of   ₹ 1,00,000 & ₹ 50,000 respectively. They agreed that interest on capital be allowed as well as be charged on drawings at @ 12% p.a. Q’s drawings were ₹ 6,000 during the year. There was no other provision in their partnership deed. A presented the following Profit & Loss Appropriation A/c according to which the profit was ₹ 77,280.

Choose from the following, profits or losses that will be shared between partners.

a. Losses: P 30,000 & Q 15,000

b. Profits: P 30,000 & Q 15,000

c. Losses: P 45,000 & Q 30,000

d. Profits: P 45,000 & Q 30,000

OR

What shall be the interest on drawings of Paul @ 10% per annum for the year ended 31^st March, 2021 in each of the following alternative cases:

Case 1: Withdraw ₹ 12,000 at the beginning of each quarter.

Case 2: Withdraw ₹ 12,000 at the end of each quarter.

Case 3: Withdraw ₹ 18,000 during the middle of each quarter.

a. 3000, 1800 & 3600

b. 1800, 3000 & 3600

c. 3600, 1800 & 3000

d. 2600, 1800 & 3000

Ans:

Profit & Loss Appropriation A/c

For the year ended ……..

OR

Case 1: (Beginning  of each quarter)

Interest on Drawings = ₹ 48,000 X 7.5/12 X 10% = ₹ 3,000

Case 2 : (End of each quarter)

Interest on Drawings = ₹ 48,000 X 4.5/12 X 10% = ₹ 1,800

Case 3: (During the middle of each quarter)

Interest on Drawings = ₹ 72,000 X 6/12 X 10% = ₹ 3,600

Q16. On dissolution of a firm, firm’s balance sheet total is ₹80,000. On the assets side of the balance sheet items shown were preliminary expenses ₹2,000; profit and loss account (debit balance) ₹4,000 and cash balance ₹1,800. Loss on realisation was ₹6,300. Total assets (including cash) realised will be

a. ₹71,200

b. ₹74,000

c. ₹67,700

d. ₹65,900

Ans:

Value of Sundry assets (including cash) = 80,000 – 2,000 – 4,000 = ₹74,000

Realised value of total assets (including cash) = 74,000 – 6,300 = ₹67,700

Q17. P, R and S are partners in a firm. R died three months after the last balance sheet date. His share of goodwill amounted to ₹ 1,45,000.

New profit profit-sharing ratio between P and S in future will be 4:1.

Treatment of goodwill is to be done by first raising the goodwill account and then writing off the value of goodwill.

Ans:

Q18. P and Q are partners in a firm. They share profits and losses in the ratio of 2:5. They admit R the new profit-sharing ratio is 3:2:2 respectively. R is to be given profits with guaranteed amount of ₹55,000. Deficiency, if any shall be borne by P and Q in the ratio of 3:2. The profits for the year 2020-2021 (after admission) amounted to ₹1,40,000. Give the necessary journal entries in the books of the firm assuming partners have fixed capital accounts.

OR

P, Q and R were partners in a firm having capitals of ₹30,000; ₹30,000 and ₹40,000 respectively. Their Current Account balances were, P: ₹5,000; Q: ₹2,500 and R: ₹1,000 (Dr.). As per the deed, the partners were entitled to interest on capital @5% p.a. Z, being the working partner, was also entitled to a salary of ₹3,000 p.a. The profits were to be divided as:a) The first ₹10,000 in proportion to their capitalsb) Next ₹15,000 in the ratio of 5:3:2c) Remaining profits to be shared equallyThe firm made a profit of ₹81,000 before any of the above items. Prepare the Profit and Loss Appropriation Account and pass the necessary Journal entry for apportionment of profit.

Ans:

Journal

R’s Actual Share of Profit = 72​of ₹1,40,000 = ₹40,000Deficiency = ₹ 55,000 – ₹ 40,000 = ₹ 15,000Deficiency is to be borne by P and Q in the ratio of 3:2 as follows:Deficiency to be borne by P = 53​ × ₹.15,000 = ₹.9,000Deficiency to be borne by Q =52​× ₹.15,000 = ₹.6,000​

OR

Journal Entry:

Working Note:

1. Division of Profits

Q19. (a) Differentiate between ‘Discount on Issue of Debentures’ and ‘Loss on Issue of debentures.’

(b) Aisha Ltd. issued ₹1,00,000; 15% Debentures of  ₹100 each at a premium of 5%, redeemable at a premium of 10% at the end of 4 years. The Board of Directors decided to transfer the minimum required amount to Debenture Redemption Reserve Account at the time of redemption.

Pass the Journal entries at the time of Redemption of Debentures.

OR

​BEE, CEE and DEE are partners in a firm. They share profits and losses in the ratio of 3:2:2, respectively. The new profit-sharing ratio of P and R will be 1:3. Value of stock increased by ₹ 800 be provided for. A debtor whose dues of ₹ 7,300 were written off as bad debts last year paid ₹ 3,200 in full Settlement. There is a liability of ₹ 3,000, included in Sundry Creditors that is not likely to arise. Pass the necessary journal entries.​​

Ans: (a) Discount on issue of debentures is the amount of loss of the company, which is incurred on issue of debentures. While loss on issue is the amount of loss which is incurred at the time of issue debentures and also on redemption of debentures.

b)

Q20. P and Q are partners in a firm. They share profits and losses in the ratio of 4:1. Their capitals are ₹ 25,000 and ₹ 20,000 respectively. The partnership deed provides for Interest on Capital @ 5% p.a. as a charge against the profits. The firm earned profits of ₹ 1,850 (before interest on capitals) during the period. Which account will you prepare in this case profit and loss account or profit and loss appropriation account? Show the above treatments.

Ans:

P & L Account

In this case profit and loss account should be prepared instead of profit and loss appropriation account because all charges against profits are shown in the profit and loss account.

Q21. On 1^st April, 2018, Ashok Ltd. was formed with an authorized capital of ₹1,00,00,000 divided into 2,00,000 equity shares of ₹50 each. The company issued prospectus inviting applications for 1,50,000 shares. These issue price was payable as under.

On Application: ₹15

On Allotment: ₹20

On Call: Balance.

The issue was fully subscribed and the company allotted shares to all the applicants.

The Company did not make the call during the year.

The company also issued 5,000 shares of ₹50 each fully paid up to the vendor for purchase of office premises.

Show the:

1. Share Capital in the Balance Sheet of the Company as per Schedule III of the Companies Act, 2013.
2. Also prepare ‘Notes to Accounts’

Ans:

(a)

(b)

Notes to Accounts (1)

Q22. P, Q and R were partners. They decided to dissolve their firm.
(a) There were total debtors of ₹ 75,500. A provision of bad and doubtful debts also stood in the books at ₹ 6,500. ₹ 15,500 debtors proved bad and rest paid the amount due.
(b) An unrecorded liability of ₹ 6,000 was discharged at a discount of ₹ 100.
(c) An equipment which was not recorded in the books was taken over by R at ₹ 2,200, whereas its expected value was ₹ 3,500.

Pass necessary journal entries for the above after various assets and the third-party liabilities have been transferred to Realisation Account.

Ans:

(a)

(b)

(c)

Q23. X Ltd. has an Authorized capital of ₹1,50,000 divided into 1,00,000 equity shares of ₹10 each and 50,000- 9% Preference shares of ₹10 each.

The company invited applications for all the preference shares but only 90,000 equity shares.

All the preference shares were subscribed, called and paid while subscriptions were received for only 85,000 equity shares.

During the first year ₹8 per share were called.

Ram holding 1,000 shares and shyam holding 2,000 shares did not pay first call of ₹2.

Shyam’s shares were forfeited after the first call and later on 1,500 of the forfeited shares were reissued at ₹6 per share ₹8 called up.

1) Show Share capital in the Balance Sheet as per schedule III as at 31^st March 2019.

2) Prepare relevant ‘Notes to Accounts’

OR

Dyne Ltd. Invited applications for issuing 10,000 Equity shares of ₹10 each. The amount was payable as follows:

On Application: ₹1

On Allotment: ₹2

On First Call: ₹3

On Second and Final Call: Balance amount

The issue was fully subscribed. Roy to whom 100 shares were allotted failed to pay the allotment money and his shares were forfeited immediately after allotment.

Sam, to whom 150 shares allotted, failed to pay the first call. His shares were also forfeited after the first call. Afterwards the second and final call was made. Myke to whom 50 shares were allotted failed to pay the second and final call. His shares were also forfeited. All the forfeited shares were re-issued at ₹9 per share fully paid up.

Pass necessary journal entries in the books of Dyne Ltd.

Ans:

2)

Notes to Accounts (1)

OR

Notes to Accounts:

Q24. A, B and C are partners in a firm. Their Balance Sheet as at 31^st March, 2020 was as follows:

They decided to change their profit-sharing ratio from 10/20:6/20:4/20 to 1:1:1w.e.f. 1^st April, 2020. The following information is given on that date:

(i) Value of Investments be appreciated by 10%

(ii) Sundry Creditors will allow a discount of 10%.

(iii) Depreciate Plant and machinery by 15%

(iv) Value of stock is increased by ₹5,000.

(v) A Reserve for Doubtful Debts be created @ 5% on Debtors.

Pass necessary Journal entries.

OR

X, Y and Z were carrying on partnership business sharing profits in the ratio of 2:2:1 respectively on March 31, 2018.

The balance sheet of the firm stood as follows:

Y retired on the above mentioned date on the following terms:

Building to be appreciated by ₹14,000.

Provision for doubtful debts to be made at 10% on debtors.

Goodwill of the firm is valued at ₹36,000 and adjustments in this respect to be made in the continuing partner’s capital accounts without raising goodwill account.

₹6,000 to be paid to Y immediately and the balance in his capital account to be paid after one year along with interest @10% p.a.

Prepare Revaluation Account, Y’s Capital Account and his Loan Account till it is finally paid off.

Ans:

Q25. P, Q and R are partners in a business.

BALANCE SHEET as at 31^st March 2019

R died on 31^st December, 2019 and they are given the following information:
(i) They share profits and losses in the ratio of 6:1:1 respectively.
(ii) The deceased partner’s share of profits will be computed on the basis of average profits of past two years which is ₹ 2,00,000.
(iii) His share of goodwill amounted ₹ 1,87,500.
(iv) R’s Drawing up to the date of death was ₹ 20,000. Interest thereon amounted to ₹ 1,000.

You are required to compute the amount payable to the legal representatives of the deceased partner by preparing the necessary accounts.

Ans:

R’s CAPITAL ACCOUNT

R’s EXECUTOR’S ACCOUNT

Since there is no information of rate of interest on R’s loan, the Provision of Indian partnership Act, 1932 will apply and R will be paid interest in loan @ 6% p.a. R’s Loan Account (₹ 50,000) and Interest on R’s Loan Account (₹.2,250).

Q26. A, B, C and D are debenture holders of PQR Ltd. Each of them is holding 9%,1000 debentures of ₹ 100 each. A needs some money urgently as his wife is hospitalised. He contacts a stockbroker to dispose off his debentures. B also needs the money from the company to pay off his housing loan. For this, he wants to sell debentures at end of each year, till all the debentures are paid off. C got back his money (invested in debentures) from the company when the company held lottery for the debenture holders. (6 marks)

1. How would the stockbroker help A to get money urgently for him?
2. What option is available to B to pay off his housing loan with the help of money invested in debentures?
3. Which method did the company adopt to return the money to C?

Ans:

1. Stock broker will sell the debentures in the stock market. For this service, he will charge some money which is known as brokerage. This way A will get instant money for the treatment for his wife.
2. B will choose the method of redemption of debentures on fixed instalment basis because he needs money to pay off his instalments regularly.
3. The Company adopted the redemption of debentures by lottery draw and paid the money to C. Under lottery system, the company redeems the shares by selecting some names randomly through lucky draw and makes the payment to the winners.

Q27. Financial statements are expressed in terms of

a. quantity

b. money

c. Quality and quantity both

d. quality

OR

You are required to compute the Proprietary Ratio.

a. 28.33%

b. 33.33%

c. 41.46%

d. 66.66%

Ans: The financial statements are expressed in monetary terms. Thus, option b is correct.

OR

Proprietary Ratio = Proprietors’ Funds/Total Assets × 100 = ₹10,00,000/₹ 30,00,000 × 100 = 33.33%

Notes:

Shareholders’ Fund = Equity Share Capital + Accumulated Reserves

= ₹ 8,50,000 + ₹ 1,50,000 = ₹ 10,00,000.

Total Assets = Non-current Assets + Current Assets

= ₹ 20,50,000 + ₹ 9,50,000 = ₹ 30,00,000

Thus, option b is correct.

Q28.

Compute Inventory Turnover Ratio.

Opt:

4 times

5 times

6.66 times

1.66 times

Ans: 5 times

Q29. Operating profit before working capital changes are ₹ 2,65,000.

You are required to calculate Cash flow from Operating Activities.

a. ₹ 2,75,000

b. ₹ 2,85,000

c. ₹ 2,45,000

d. ₹ 2,55,000

OR

Conversion of debentures into share capital is not recorded into cash flow statement because

a. this activity involves cash flows.

b. this activity does not involve cash flow.

c. this is a financing activity.

d. this relates to debentures.

Ans:

2,65,000 + 5,000 (Decrease in current assets) – 15,000 (Decrease in current liabilities) = ₹ 2,55,000

Thus, option d is correct.

OR

Conversion of debentures into share capital is not recorded into cash flow statement because this activity does not involve cash flow. Thus, option b is correct.

Q30. Which of the following is the part of Cash and cash equivalent, in the cash flow statement?

Opt:

Discount allowed to customers.

Increase in balance of Cash Credit.

Short term deposits in Bank.

Repayment of Short-term Loan.

Ans:

Short term deposits in Bank.

Q31. Under what headings will you show the following items in a Company’s Balance Sheet:a) Public Deposits
b) Forfeited Shares Account
c) Interest Accrued and Due on Debentures
d) Acceptances
e) Sundry Creditors
f) Calls in Arrears

Ans:

Q32. Calculate Quick Ratio from the following information:

Ans:

Quick Ratio = Quick Assets / Current Liabilities

Quick Assets =

(₹ 50,000 + ₹ 30,000)

= ₹ 80,000

Current Liabilities = ( ₹ 1,00,000 + ₹ 4,000)

= ₹ 1,04,000

Thus Quick Ratio = ₹ 80,000 / ₹ 1,04,000 = 0.77:1

Q33. ​Which of the following formulas, if entered into the cell, will calculate the total number of payments or months that the loan will be paid off over?

a) =PMT(B2,B3,B5)

b) =PV(B2,B3,B5)

c) =NPER(B3,B2,B5)

d) =PMT(B3, B2,B5)

OR

​Segregating numbers into relevant groups, taking ratios, plotting and making tables are examples of

(a) Reporting System

(b) Back-end Database

(c) Front end Interface

(d) Data Processing​​

Ans: The NPER function allows you to calculate the number of periods for a payment based on variables for PMT, RATE and PV. Thus, option c is correct.

OR

Data processing actions are taken to transform data into information. An example of data processing is: – Segregating numbers into relevant groups, taking ratios, plotting and making tables. Thus, option d is correct.​

Q34. Which formulae would result in TRUE if C4 is less than 10 and D4 is less than 100?

(A) =AND(C4>10, D4>10)
(B) =AND(C4>10, C4<100)
(C) =AND(C4>10, D4<10)
(D) =AND (C4<10, D4,100)

Ans:

d) =AND (C4<10, D4,100)

Explanation: If C4 is less than 10 and D4 is less than 100, then formula =AND(C4<10, D4<100) would result in TRUE. In the formula, C4<10 indicates that C4 is less than 10, and D4<100 indicates that D4 is less than 100, which satisfies the given condition and therefore, the result is TRUE.

Q35. To login into the control center for account management, the shortcut key is:

a) Alt + K

b) CTRL + K

c) Alt + L

d) CTRL + L

OR

Match the following-

a) i-c, ii-d, iii-b, iv-a

b) i-b, ii-a, iii-d, iv-c

c) i-a, ii-c, iii-d, iv-b

d) i-d, ii-b, iii-a, iv- c

Ans: ​Support Centre button is available on the Horizontal Button Bar, which has the shortcut key CTRL+ K. This is to login control centre for account management. Thus, option b is correct.

OR

Explanation:

Thus, option a is correct.

Q36. The need for accounting software arises in:
a) When the computerised accounting system is implemented to replace the manual system.
b) When the manual accounting system is implemented to replace the computerised accounting system.
c) When a single-entry system is implemented to replace the double entry system.
d) When double entry system is implemented to replace the single-entry system.

Ans:

a) When the computerized accounting system is implemented to replace the manual system.

Explanation: The need for accounting software arises in that situation when the computerized accounting system is implemented to replace the manual system.

Q37. Discuss the various steps involved in designing an accounting report from accounting data.

Ans:

The various steps involved in designing accounting reports from accounting data are as follows:-
Step I Defining the Objectives: The objectives of the report must be clearly defined, who are the users of the report and the decision to be taken on the basis of the report so it should define all the accounting data in a simple manner.
Step II Structure of the Report: It includes the information to be contained therein and the style of presentation.
Step III Querying with the Database: The accounting information queries must be clearly defined and the methodology to be adopted while interacting with the database must be defined.
Step IV Finalizing the Report: The report should be complete and should end with proper analysis and suggestions related to the accounting data so that decisions can be made easily and quickly.

Q38. The processing of data is accomplished either through batch processing or real time processing.
In the light of the above statement, explain batch processing and real time processing.

Ans:

Batch Processing: It applies to large and voluminous data that is accumulated offline from various units i.e., branches or departments. The entire accumulated data is processed in one shot to generate the desired reports according to decision requirements. Batch processing requires separate programs for input, process and output. An example is Payroll and billing system.
Real-time Processing: It provides the online outcome in the form of information and reports without time lag between the transaction and its processing. The accounting reports are generated by query language popularly called Structured Query Language (SQL). It allows the user to retrieve report-relevant information that is capable of being laid out in a pre-designed accounting report. Real – Time Data Processing is also known as Stream Processing. Example: ATMs, Radar systems.

Q39. When can a Computerised Accounting System be used?

OR

State the four basic requirements of database applications.

Ans:

A Computerised Accounting System can be used under the following conditions:

1. High Speed Required: When accounts are to be processed at high speed. For example, in case of accounting for Credit Card, Debit Card, ATM Card.

2. Large Volume of Transactions: When the volume of transaction is very large.

3. Accuracy Required: When accounts are to be maintained error free.

4. Storage Required: When a large amount of accounting data is required to be stored.

5. Modification Required: When accounting data are to be updated, added or deleted on consistent basis.

6. Data Sharing Required: When accounting data are to be shared by several persons for several function at the same time.

OR

A modern computerised accounting system is based on the concept of the database. A database is implemented using a database management system, which is defined as a set of computer programs that manages and organises data effectively and provide access to stored data by the means of application programs. Every computerised accounting system has two basic requirements:

• Accounting framework
• Operating procedure

The use of computers in any database-oriented application has four basic requirements:

• Front-end database: It is an interactive link or a dialog between a user and database-oriented software through which the user communicates with the back-end database.
• Back-end database: It is a data storage system that is hidden from a user and responds to the requirement of the user.
• Data-processing: These are actions done on data to get information.
• Reporting system: It is an interface to generate reports, for example, application software like Visual Basic.

Q40. What are the Generic Considerations before Sourcing an Accounting Software?

Ans:

Generic Consideration before Sourcing Accounting software:

a) Flexibility: An important consideration before sourcing accounting software is flexibility, viz. data entry and the availability and design of various reports expected from it. It should offer some flexibility between the user of the software, the switch over between the accountants, operating systems and the hardware.

b) Cost of installation and maintenance: The choice of the software obviously requires consideration of organisation ability to afford the hardware and software. A simple guideline to take such a decision is the cost-benefit analysis of the available options and the financing opportunities available to the firm.

c) Size of Organisation: The size of the Organisation and the volume of business transactions do affect the software choices. A large organisation requires supplicated software to meet the multi-user requirements, geographically scattered and connected through a complex network.

d) Ease of Adaptation and Training needs: Some accounting software is user-friendly requiring simple training to the users. However, some other complex software packages linked to other information systems require intensive training on a continuous basis.

e) Utilities/MIS Reports: The MIS reports and the degree to which they are used in the organisation also determine the acquisition of software.

f)  Expected Level of Secrecy (Software and Data): Another consideration before buying accounting software is the security features, which prevent unauthorised personnel from accessing and manipulating data in the accounting system.

g) Exporting/Importing Data Facility: The transfer of database to other systems or software is sometimes expected from the accounting software.

h) Vendors Reputation and Capability: Another important consideration is the reputation and capability of the vendor. This depends upon how long has been the vendor is in the business of software development, whether there are other users of the software and extent of the availability of support mechanisms outside the premises of the vendor.