Section – A<\/strong> Question 1. [6 \u00d7 2] (ii) (a) Interest on Debentures A\/c Dr. (iii) Balance in share forfeiture account is capital gain and can be used to reissue to some other shareholder.<\/p>\n (iv) (a) When a new partner is added to a partnership firm. (v) (a) Lump sum method (vi) Retiring Partner\u2019s Capital A\/c Dr. Part – II (48 Marks)<\/strong> Question 2. [8] On 31st December, 2018, the remaining debentures were purchased @ \u20b9 98 per debenture for immediate cancellation. Question 4. (a) Raina\u2019s loan was repaid by the firm along with interest of \u20b9 500. (B) Vinay, Usha and Punit are partners in a firm. They have been sharing profits and losses in the ratio of 3 : 4 : 1. [4] Question 5. (B) Aditi and Parul are partners in a firm with capitals of \u20b9 35.000 each. They shared profits and losses in the ratio of 3 : 1. [8] Working Notes: Question 6. [12] Question 7. [12] Question 8. [12] Note : Loss on issue A\/c has been debited by \u20b9 51.000. By grouping together the discount on issue \u20b9 21,000 and premium on redemption \u20b9 30,000.<\/p>\n Section – B<\/strong> Question 9. (B) (i) Cash and cash Equivalent (C) Question 10. Question 11. Additional Information: Section – C<\/strong> Question 12. Question 13. Question 14. (b) A unique key is a set of one or more than one fields of a table that uniquely identify a record in a database table. It can accept only one null value and it cannot have duplicate values.<\/p>\n (c) Relational database. Network database.<\/p>\n (d) A cell in a spreadsheet is an intersection of a column and row. It is represented by a combination of letter and numeral. For example B5 means, that the pointer is in column B and row number five.<\/p>\n (e) (i) Select the cells which are to be merged.
\nPart – I (12 Marks)<\/strong>
\nAnswer all questions.<\/strong><\/p>\n
\nAnswer briefly each of the following questions :
\n(i) List any two items which may appear on the credit side of a partner\u2019s fixed capital account,
\n(ii) Give the journal entries to be passed when :
\n(a) Interest is due on debentures.
\n(b) Interest is paid to debenture holders.
\n(iii) In what way, if any, can the balance in shares forfeited account be used ?
\n(iv) Mention any two circumstances when there is need to revalue goodwill of a partnership firm,
\n(v) Enumerate any two methods of redemption of debentures.
\n(vi) Give the journal entry for closing the retiring partner\u2019s capital account when his share is paid to him privately by the remaining partners.
\nAnswer:
\n(i) Opening Balance of Capital Accounts, Additional Capital of any partner<\/p>\n
\nTo Debentures holders A\/c
\nTo Income Tax Payable A\/c
\n(Being the Interest due to debenture holders and tax payable to Income tax Dept.)
\n(b) Debenture holders A\/c Dr.
\nTo Bank A\/c
\n(Being the amount of interest paid to debenture holders)<\/p>\n
\n(b) At the time of retirement of a partner.<\/p>\n
\n(b) Installment method<\/p>\n
\nTo Remaining Partner ‘s Capital A\/c
\n(Being the amount of share of the retiring partner discharged)<\/p>\n
\nAnswer any four questions.<\/strong><\/p>\n
\n(A) Meera Co. Ltd. invited applications of 50.000. equity shares of \u20b9 10 each at a premium of \u20b9 2 per share, payable as follows :
\nOn Application on 1st May. 2017 \u20b9 2
\nOn Allotment on 1st July. 2017 \u20b9 5 (including premium)
\nOn 1st and Final Call on 1st October. 2017 \u20b9 5
\nThe Company received applications for 62,500 shares.
\nIt was decided to :
\n(a) Refuse allotment to the applicants of 2,500 shares.
\n(b) Allot in full to the applicants of 10,000 shares.
\n(c) Allot the balance of the shares applied on a pro-rata basis among the other applicants.
\n(d) Utilize the excess application money in part payment of allotment money.
\n(e) Charge interest on calls-in-arrears, if any, @ 10% per annum.
\nAll the money due w as received except from one shareholder to whom 200 shares had been allotted in full. The amount was due by him to the company even till the date of the Balance Sheet, which was 31st March, 2018.
\nThe company charged interest on calls-in arrears from the shareholders from the date on which it was due till the Balance Sheet date. You are required to, for the year 2017-18.
\n(i) Prepare the Cash Book to record the above issue of shares.
\n(ii) Pass journal entries in the Journal Proper (including entries for interest on calls -in arrears).
\n(B) On 31st March, 2018, Vipul Ltd. had ? 30.00,000, 8% Debentures of \u20b9 100 each outstanding. [4]
\nOn 1st June, 2018, it purchased in the open market, 20,000 of its own debentures @ \u20b9 102 per debenture and cancelled these debentures immediately.<\/p>\n
\nYou are required to pass necessary journal entries for the redemption of debentures. (Ignore interest on debentures and entries for provisions regarding Debenture Redemption Reserve and Debenture Redemption investment).
\nAnswer:
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-1.png\")
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-2.png\")
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-3.png\")
\nWorking Notes .
\nCalculation of Interest
\nNo. of shares = 200
\nAmount due = 200 \u00d7 5 = \u20b9 1,000
\n\\(\\text { Interest }=\\frac{1000 \\times 10 \\times 6}{100 \\times 12}\\)
\n= \u20b9 50
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-4.png\")
\nQuestion 3.
\nMohit, Ali and John are partners in a firm, sharing profits and losses in the ratio of 3 : 1 : 1. Their Balance Sheet as at 31 st March, 2018, was as follows : [ 12]
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-5.png\")
\nMohit retired on 1st April, 2018, subject to the following adjustments :
\n(a) Goodwill of the firm to be valued at \u20b9 20,000.
\n(b) Mohit to take over the investments at the market value.
\n(c) 25% of the General Reserve to be transferred to Provision for Doubtful Debts and the balance to be distributed amongst all the partners.
\n(d) Creditors to be paid \u20b9 3,000 less.
\n(e) Investment Fluctuation Fund not to be distributed. For this, it was decided that the remaining partners would compensate the retiring partner through their capital accounts.
\n(f) Mohit to be paid \u20b9 20,000 immediately on retirement and the balance to be transferred to his loan account.
\nYou are required to :
\n(i) Pass journal entries on the date of Mohit ‘s retirement.
\n(ii) Prepare the Balance Sheet of the reconstituted firm.
\nAnswer:
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-6.png\")
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-7.png\")
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-8.png\")
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-9.png\")
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-10.png\")
<\/p>\n
\n(A) Raina and Meena were partners in a firm sharing profits and losses equally. [8]
\nThey dissolved their firm on 31st March, 2018.
\nOn this date, the Balance Sheet of the firm, apart from realizable assets and outside liabilities showed the following:
\nRaina\u2019s Capital \u20b9 40,000 (Cr.)
\nMeena\u2019s Capital \u20b9 20,000 (Dr.)
\nProfit and Loss Account \u20b9 10,000 (Dr.)
\nRaina\u2019s Loan to the firm \u20b9 15,000
\nContingency Reserve \u20b9 7,000
\nOn the date of dissolution of the firm :<\/p>\n
\n(b) The dissolution expenses of \u20b9 1,000 were paid by the firm on behalf of Raina who had to bear these expenses.
\n(c) An unrecorded asset of \u20b9 2,000 was taken over by Meena while Raina discharged an unrecorded liability of \u20b9 3,000.
\n(d) The dissolution resulted in a loss of \u20b9 60,000 from the realization of assets and settlement of liabilities.
\nYou are required to prepare :
\n(i) Partner\u2019s Capital Accounts.
\n(ii) Raina\u2019s Loan Account.<\/p>\n
\nPunit wants the profits to be shared equally amongst the partners. He further wants the change in profit sharing ratio to be applicable retrospectively for the last two years. Vinay and Usha have no objection to this. The profits for the last two years were \u20b9 70,000 and \u20b9 50,000. You are required to record the adjustment by means of a single journal entry. (Show the workings clearly).
\nAnswer:
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-11.png\")
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-12.png\")
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-13.png\")
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-14.png\")
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-15.png\")
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-16.png\")
<\/p>\n
\n(A) Peter, Max and Som were partners in a firm sharing profits and losses in the ratio of 4:2:1. [4] Their fixed capital were \u20b9 40,000, \u20b9 30.000, respectively. Som was guaranteed a profit of \u20b9 39,000 by the firm.
\nIt was decided that any loss arising because of the guarantee would be shared by Peter and Max equally.
\nThe trading profit of the firm for the year ended 31 st March, 2018, was \u20b9 1,47,000.
\nYou are required to prepare the Profit and Loss Appropriation Account for the year 2017-18, showing the distribution of profits.<\/p>\n
\nOn 1st April, 2017, they admit Chanda into their partnership with l\/5th share in the profits. Chanda brings in \u20b9 40,000 as her capital and her share of goodwill in cash.
\nHer share of goodwill is calculated on the basis of her capital contribution and her share of profits in the firm.
\nAt the time of Chanda ‘s admission :
\n(a) The firm had a Workman Compensation Reserve of \u20b9 60.000 against which there was a claim of \u20b9 20.000.
\n(b) Creditors of \u20b9 8.000 were paid by Aditi privately for which she is not to be reimbursed.
\n(c) There was no change in the value of other assets and liabilities.
\nYou are required to. on the date of Chanda’s admission :
\n(i) Calculate the good will of the firm. (Show the workings clearly).
\n(ii) Pass the necessary journal entries to record the above transactions.
\nAnswer:
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-17.png\")
\nWorking Notes:
\nProfit of Peter = \u20b9 1,47,000\u00a0\u00d7 4\/7 =\u00a0\u20b9 84,000
\nProfit of max =\u00a0\u20b9 1,47,000\u00a0\u00d7 2\/7 =\u00a0\u20b9 42,000
\nProfit of som =\u00a0\u00a0\u20b9 1,47,000\u00a0\u00d7 1\/7 =\u00a0 \u20b9 21,000
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-18.png\")
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-19.png\")
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-20.png\")
<\/p>\n
\nAssuming the capital of Chanda = \u20b9 35,000
\n(equal to Capital of both existing partners)
\nCalculation of Goodwill
\nOld Profit Sharing Ratio of Aditi and Parul = 3 : 1
\nNew Profit Sharing Ratio =\u00a0\\(\\frac{3}{5} : \\frac{1}{5}=\\frac{1}{5}\\)
\n= 3 : 1 = 1
\nSacrifice of Aditi =\u00a0\\(\\frac{3}{4}-\\frac{3}{5}=\\frac{3}{20}\\)
\nSacrifice of Parul = \u00a0\\(\\frac{1}{4}-\\frac{1}{5}=\\frac{1}{20}\\)
\nGain of Chanda = 1\/5
\nThe amount of goodwill of Chanda = \u20b9 5,000
\nTotal Goodwill of the firm = 5\/1\u00a0\u00d7 5,000\u00a0\u20b9 25,000
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-21.png\")
<\/p>\n
\nRavi and Tiku are partners in a firm. According to their partnership deed :
\n(i) Interest on capital will be allowed @ 5% per annum.
\n(ii) Interest on drawings will be charged @ 4% per annum.
\n(iii) Each partner will be given a salary of \u20b9 1,000 per month.
\n(iv) Partners will share profits and losses in the ratio of 2 : 1.
\nFollowing are the particulars of the capitals and drawings of the partners :
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-22.png\")
\nRavi had taken a loan of \u20b9 10,000 from the firm on which interest of \u20b9 200 was due by him to the firm.
\nThe accounts for the year 2017-18 showed that the firm had made a profit of \u20b9 77,000 before taken into account any interest, partners\u2019 salaries and manager\u2019s salary of \u20b9 18,000.
\nYou are required to prepare :
\n(i) Profit and Loss Appropriation Account for the year 2017-18.
\n(ii) Partners\u2019 Capital Accounts.
\nAnswer:
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-23.png\")
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-25.png\")
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-50.png\")
<\/p>\n
\nThe trainee accountant of Rudra Ltd. drafted the following Balance Sheet. He did not prepare it according to the format prescribed as per schedule III of the Companies Act, 2013 . He also classified a few items incorrectly.
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-26.png\")
\nFoot note : The company had an authorized capital of 2,00,000 Equity shares of \u20b9 10 each. You are required to prepare, as at 31st March, 2018:
\n(i) The Balance Sheet of Rudra Ltd. as per Schedule III of the Companies Act, 2013.
\n(ii) Notes to Accounts.
\nAnswer:
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-27.png\")
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-28.png\")
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-29.png\")
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-30.png\")
<\/p>\n
\nYou are required to pass journal entries to record the following issue of debentures and to write off any capital losses.
\n(a) Zoom Ltd. issues 6,000, 12% Debentures of \u20b9 100 each at par redeemable after 5 years also at par.
\n(b) Zola Ltd. issues 5,000, 13% Debentures of \u20b9 100 each at a discount of 10% to be redeemed at par after 7 years.
\n(c) Zubic Ltd. issues 11% Debentures of the total face value of \u20b912,00,000 at a premium of 5% to be redeemed at par after 6 years.
\n(d) Ruby Ltd. issues \u20b9 5,00,000, 12% Debentures at a premium of 5% to be redeemed at 10% premium after 10 years.
\n(e) Emerald Ltd. issues 3,000, 9% Debentures of \u20b9 100 each at a discount of 7% to be redeemed at a premium of 10% after 4 years.
\nNote: All the companies write off their capital losses in the year in which they occur.
\nAnswer:
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-31.png\")
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-32.png\")
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-33.png\")
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-34.png\")
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-35.png\")
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-36.png\")
<\/p>\n
\n(20 Marks)<\/strong>
\nAnswer any two questions<\/strong><\/p>\n
\n(A) Mention any two commonly used tools for comparison of financial statements. [2]
\n(B) While preparing a Cash Flow Statement, identify the following transactions as belonging to Operating Activities, Investing Activities, Financing Activities, Cash and Cash Equivalents : [2]
\n(i) Bank overdraft repaid.
\n(ii) Purchase of Marketable Securities to be sold within 90 days.
\n(C) From the following data, prepare a Common Size Balance Sheet of Palms Ltd. as at 31st March, 2018. [6]
\n(All calculations up to two decimal places)
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-37.png\")
\nAnswer:
\n(A) (i) Ratios
\n(ii) Balance sheet
\n(iii) Cash flow statement<\/p>\n
\n(ii) Cash and Cash Equivalent<\/p>\n
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-38.png\")
<\/p>\n
\n(A) Calculate the Gross Profit Ratio from the following information : [2]
\nParticulars
\nOpening Inventory \u20b980,000
\nClosing Inventory \u20b91,00,000
\nRevenue from Operations \u20b99,00,000
\nInventory Turnover Ratio 8 times
\n(B) From the following Statement of Profit and Loss of Gama Ltd. for the year 2017-18, calculate (up-to two decimal places): [8]
\n(i) Net Profit Ratio
\n(ii) Operating Profit Ratio
\n(iii) Current Ratio
\n(iv) Quick Ratio
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-39.png\")
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-40.png\")
\nAnswer:
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-41.png\")
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-42.png\")
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-43.png\")
<\/p>\n
\n(A) Mention whether the following would result in inflow, outflow or no flow of cash : |2 ]
\n(i) Issue of fully paid Bonus Shares
\n(ii) Cash withdrawn from Bank
\n(B) From the following information and extracts of Balance Sheets of Pioneer Ltd. as at 31st March, 2017 and 31st March 2018, calculate for the year 2017-18.\u00a0 [8]
\n(i) Cash from Operating Activities
\n(ii) Cash from Investing Activities
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-44.png\")
\nNote: Proposed dividends for the years 2016-17 and 2017-18 were \u20b9 40,000 and \u20b9 50,000 respectively.<\/p>\n
\nDuring the year 2017-18 :
\n(a) The company provided depreciation on Plant and Machinery amounting to \u20b924.000.
\n(b) A machine had been condemned and scrapped.
\n(c) Interest of \u20b912,000 paid on Debentures.
\n(d) Tax paid \u20b950,000.
\n(e) Patents worth \u20b9 30.000 were written off while some patents were sold for \u20b9 75,000 at a profit of \u20b9 5.000. No new patents were purchased.
\n(f) Dividend proposed in 2016-17 was approved by the shareholders and paid by the company.
\nAnswer:
\n(A) (i) Cash no flow
\n(ii) Cash no flow
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-45.png\")
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-46.png\")
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-47.png\")
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-48.png\")
<\/p>\n
\n(20 Marks)<\/strong>
\nAnswer any two questions<\/strong><\/p>\n
\nThe spreadsheet below shows the payroll structure of Pluto Ltd.
\n![\"ISC](\"https:\/\/cbselibrary.com\/wp-content\/uploads\/2020\/01\/ISC-Accounts-Question-Paper-2019-Solved-for-Class-12-49.png\")
\nBased on the information give in the spreadsheet, write the formula for calculating each of the
\nfollowing:
\n(a) Net Pay of EMP002 [2]
\n(b) Provident Fund (PF) amount of EMP004. [2]
\n(c) Income Tax (I TAX) of EMP003 [2]
\n(d) The total gross salary of all the employees. [2]
\n(e) The basic salary of EMP005 [2]
\nAnswer:
\n(a) Net pay of EMP002 = G3 \u2013 H3 \u2013 13 \u2013 J3
\n(b) Provident Fund amount of EMP004 = 10\/100*(B5 + C5)
\n(c) Income Tax of EMP003 = G4* 10\/100
\n(d) Total gross salary of all the employees = SUM (G2 : G6)
\n(e) The basic salary of EMP005 = G6 \u2013 C6 \u2013 D6 \u2013 E6 \u2013 F6<\/p>\n
\n(a) List any two types of entries that are allowed in a worksheet. [2]
\n(b) You enter 40-10 in a cell. The worksheet does not display the difference 30 in the cell, instead it shows 40-10. What is the reason for this ? [2]
\n(c) Give the full form of DBMS. [2]
\n(d) Explain the term \u2018Charts in MS Excel. [2]
\n(e) Write a shortcut key for each of the following [2]
\n(i) To minimize the worksheet
\n(ii) To redo an action.
\nAnswer:
\n(a) Text, Numbers, Formulas
\n(b) Put + sign before 40 – 10 i.e., = 40 \u2013 10. Without = sign, it understands the data as text.
\n(c) Database Management System.
\n(d) Chart is a visual representation of data in a worksheet showing the data along x-axis and y-axis.
\n(e) Ctrl + F9 keys
\nCtrl + Y<\/p>\n
\n(a) (i) What is the option used to adjust the text within a cell ? [2]
\n(ii) Give the procedure to use this option.
\n(b) What is a unique key ? [2]
\n(c) State any two types of data based structures. [2]
\n(d) What is meant by a cell in a spreadsheet ? [2]
\n(e) State the steps involved in merging two cells in a spreadsheet. [2]
\nAnswer:
\n(a) (i) Wrap text
\n(ii) (a) Right click the cell in which text is to be wrapped.
\n(b) Click Format Cells option.
\n(c) In Format Cells dialog box. click Alignment tab.
\n(d) Click Wrap text check box.
\n(e) Click OK.<\/p>\n
\n(ii) Right click on the selected cells.
\n(iii) Click Format Cells option.
\n(iv) In Format Cells dialog box, click Alignment tab.
\n(v) Click Merge cells check box.
\n(vi) Click OK.<\/p>\n ISC Class 12 Accounts Previous Year Question Papers<\/a><\/h4>\n","protected":false},"excerpt":{"rendered":"