ACCOUNTANCY
Class 12
Time Allowed : 3 Hours
Most Marks : 80
Paper Code : 67/4/1(CBSE 2020)
Common Directions :
Learn the next directions very rigorously and strictly observe them :
(i) This query paper contains two Components – A and B. There are 32 questions within the query paper. All questions are obligatory.
(ii) Half A is obligatory for all candidates.
(iii) Half B has two choices i.e. (1) Evaluation of Monetary Statements and (2) Computerized Accounting. It’s important to try solely one of the given choices.
(iv) Heading of the choice opted should be written on the Reply-E-book earlier than trying the questions of that exact OPTION.
(v) Query nos. 1 to 13 and 23 to 29 are very brief reply sort questions carrying 1 mark every.
(vi) Query nos. 14 and 30 are brief reply sort–I questions carrying 3 marks every.
(vii) Query nos. 15 to 18 and 31 are brief reply sort–II questions carrying 4 marks every.
(viii) Query nos. 19, 20, and 32 are lengthy reply sort–I questions carrying 6 marks every.
(ix) Query nos. 21 and 22 are lengthy reply sort–II questions carrying 8 marks every.
(x) Solutions needs to be transient and to the purpose. The reply of every half needs to be written at one place.
(xi) There isn’t any total alternative. Nonetheless, an inner alternative has been offered in 2 questions of three marks, 2 questions of 4 marks, 1 query of six marks, and 2 questions of eight marks. It’s important to try solely one of many decisions in such questions.
(xii) Nonetheless, separate directions are given with every half and query, wherever mandatory.
PART A
(Accounting for Not-for-Revenue Organizations, Partnership Corporations and Firms)
1. When an organization plans to redeem its debentures out of earnings, it ought to switch a minimal ______ % of the face worth of the excellent debentures to Debenture Redemption Reserve out of surplus obtainable for cost of dividend.
Reply: 25%
2. _______ capital accounts at all times present a credit score steadiness.
Reply: Fastened capital accounts at all times present a credit score steadiness.
3. Within the case of retirement, if full or a part of the quantity payable to the retiring associate nonetheless stays to be paid, and there’s no settlement among the many companions then retiring associate will get
(i) Curiosity @ 6% p.a on the Stability quantity.
(ii) Share of revenue earned proportionate to his quantity excellent to complete capital of the agency.
(iii) Curiosity @ 9% p.a. on the steadiness quantity. Which of the next is appropriate ?
(a) (i)
(b) (ii)
(c) (iii)
(d) Have a option to get both (i) or (ii)
Reply: (d) Have a option to get both (i) or (ii)
4. The next data has been extracted from the monetary statements of a not-for-profit group for the yr ended thirty first March, 2019.
Which of the next statements is appropriate for the presentation of the above gadgets within the monetary statements of the not-for-profit group?
(a) Unfavorable Stability of Match fund ₹ 1,000 can be proven on the liabilities facet of the Stability sheet as at thirty first March, 2019.
(b) Opening Stability of Match Fund ₹ 5,00,000 can be proven on the liabilities facet of Stability Sheet as at 1-4-2018.
(c) Unfavorable steadiness of match fund, ₹ 1,000 can be proven on the expenditure facet of the Earnings and Expenditure Account for the yr ended 31-3-2019.
(d) Each (b) and (c).
Reply: (d) Each (b) and (c).
Rationalization:
Match Bills exceed the steadiness within the Match Fund by ₹ 1,000, so this quantity is debited to Earnings and Expenditure A/c.
5. Anita and Babita have been companions sharing earnings and losses within the ratio of three : 1. Savita was admitted for 1/fifth share within the earnings. Savita was unable to deliver her share of goodwill premium in money. The journal entry recorded for goodwill premium is given beneath :
The brand new revenue sharing ratio of Anita, Babita and Savita, can be
(a) 41 : 7 : 12
(b) 13 : 12 : 10
(c) 3 : 1 : 1
(d) 5 : 3 : 2 1
Reply: (a) 41 : 7 : 12
Rationalization:
Outdated Ratio = 3 : 1
Sacrificing Ratio Anita and Babita = 1 : 2
Sacrificing Share of Anita =
Sacrificing Share of Babita =
So, New Ratio of Anita =
New Ratio of Babita =
New Ratio of Savita =
6. Amla, Bimla and Kavita have been companions sharing earnings and losses within the ratio of 4 : 3 : 1. Bimla retires and provides her share of revenue to Amla for ₹3,600 and to Kavita for ₹ 3,000. The gaining ratio of Amla and Kavita can be :
(a) 4 : 5
(b) 2 : 1
(c) 6 : 5
(d) 4 : 1 1
Reply: (c) 6 : 5
Rationalization:
Revenue of Bimla is shared between Amla and Kavita in ratio of 3600:3000 or 6 : 5.
7. Capital Reserve is created out of ______ earnings.
Reply: Capital Reserve is created out of Capital earnings.
8. Avya, Divya and Kavya have been equal companions. They determined to alter the revenue sharing ratio to 4 : 3 : 2. For this objective the goodwill of the agency was valued at ₹ 90,000. The journal entry for the remedy of Goodwill on change in revenue sharing ratio can be :
Reply:
(d)
Rationalization:
Outdated Ratio = 1 : 1 : 1
New Ratio = 4 : 3 : 2
so, Sacrificing or Gaining Ratio:
Avya =
Divya =
Kavya =
Share of Goodwill =
9. Mohit, Shobhit and Rohit are companions sharing earnings and losses within the ratio 2 : 1 : 1. Rohit is assured a revenue of ₹ 14,000. The agency incurred a revenue of ₹ 20,000 in the course of the yr. Calculate the quantity of deficiency borne by Mohit and Shobhit.
Reply:
Revenue distributed among the many Companions:
Mohit =
Shobhit =
Rohit =
Quantity of Revenue Guranteed to Rohit = ₹ 14,000
so, Deciciency = 14,000 − 5,000 = ₹ 9,000
Quantity of deficiency borne by Mohit and Shobhit of their Revenue-Sharing Ratio:
Mohit =
Shobhit =
10. Which of the next is NOT a objective for which the Securities Premium quantity can be utilized?
(A) Issuing totally paid bonus shares to shareholders.
(B) Issuing partly paid up bonus shares to shareholders.
(C) Writing off preliminary bills of the corporate.
(D) In buying its personal shares (purchase again)
Reply: B) Issuing partly paid-up bonus shares to shareholders.
11. Tangible Belongings of the agency are ₹ 14,00,000 and out of doors liabilities are ₹ 4,00,000. Revenue of the agency is ₹ 1,50,000 and regular charge of return is 10%. The quantity of Capital employed can be
(a) ₹ 10,00,000
(b) ₹ 1,00,000
(c) ₹ 50,000
(d) ₹ 20,000
Reply: (a) ₹ 10,00,000
Rationalization:
Capital Employed (Belongings Strategy) = Non-Present asset + Non-Present Investments + Long run Loans + Working Capital
Working Capital = Present Belongings − Present Liabilities
Working Capital = − 4,00,000
Capital Employed (Belongings Strategy) = 14,00,000 − 4,00,000 = ₹ 10,00,000
12. Earnings and Expenditure Account data :
(A) Receipts and Funds of Income and Capital nature each.
(B) Earnings and Expenditure of Income nature solely.
(C) Expenditure of Capital nature solely.
(D) Receipts of Income nature solely.
Reply: (B) Earnings and Expenditure of Income nature solely.
13. When the enterprise of the agency turns into unlawful, the way in which of dissolution of the agency is ________.
Reply: When the enterprise of the agency turns into unlawful, the way in which of dissolution of the agency is Obligatory Dissolution.
14. On thirty first March 2018 SS Ltd. had 50,000 10% debentures of ₹ 100 every excellent. These debentures have been due for redemption on thirty first March, 2019. Debenture Redemption Reserve has a steadiness of ₹ 5,00,000 on thirty first March, 2018. Ignoring the entries for curiosity, cross the mandatory journal entries for redemption of debentures.
Reply:
Working Word:
1. Whole Quantity to be transferred to Debenture Redemption Reserve = 25% of fifty,00,000 = ₹12,50,000
Quantity to be transferred to Debenture Redemption Reserve within the yr 2019 = 12,50,000 − 5,00,000 = ₹7,50,000
OR
X Ltd. has 4,000 12% debentures of ₹ 100 every on 1st April, 2018. In accordance with the phrases of difficulty curiosity on debentures is payable half yearly on thirtieth September and thirty first March and the speed of tax deducted at supply is 10%. Cross mandatory journal entries for curiosity on debentures for the yr 2018-19.
Reply:
15. From the next data, calculate the quantity of sports activities materials that can be debited to the ‘Earnings and Expenditure Account’ of Shiny Sports activities Membership for the yr ended 31-3-2019.
Extra Data :
Money buy of sports activities materials in the course of the yr was ₹ 2,50,000. ₹ 1,50,000 have been paid to the collectors of sports activities materials.
Reply:
16. A and B are companions sharing earnings and losses within the ratio of three : 2. Their capital on thirty first March, 2018 in spite of everything changes stood at ₹ 1,65,500 and ₹ 1,27,600 respectively. Earnings amounting to ₹ 50,000 for the yr 2017-18 have been distributed after permitting curiosity on drawings @ 12% p.a. Throughout the yr A withdrew ₹ 15,000 at the start of each quarter and B withdrew ₹ 40,000 in the course of the yr. Partnership deed is silent on curiosity on drawings however supplies for curiosity on Capital @ 5% p.a. Curiosity on Capital has not been offered. Exhibiting your workings clearly, cross the mandatory adjustment entry to rectify the above errors.
Reply:
Workings:
Curiosity on Drawings:
A = 
B = 
OR
Arun, Shobha and Yuvraj have been companions in a agency. On 1st April, 2018 their Fastened Capitals Stood at ₹ 1,00,000, ₹ 50,000 and ₹ 50,000 respectively. As per the provisions of partnership deed,
(i) Companions have been entitled to an annual wage of ₹ 20,000 every.
(ii) Curiosity on Capital @ 10% p.a. was to be offered.
(iii) Earnings have been to be shared within the ratio 3 : 1 : 1. Web revenue for the yr ended thirty first March, 2019 was ₹ 90,000.
Cross Journal Entries for the above within the books of the agency.
Reply:
17. From the next Receipts and Funds Account of Shyam Music Membership for the yr ended thirty first March, 2019 and extra data, put together Earnings and Expenditure Account for the yr ended 31-3-2019.
Extra Data :
(i) The Membership had 225 members every paying an annual subscription of ₹ 1,000.
(ii) Musical devices have been bought on 1-10-2018. Depreciation @ 15% p.a. was to be charged on musical devices.
Reply:
Working Notes:
1. Calculation of Depreciation on Musical Devices:
18. X, Y and Z have been companions in a agency sharing earnings and losses within the ratio of two : 2 : 1. The agency closes its books on thirty first March yearly. Y died on twenty fourth June, 2018. On Y’s dying goodwill of the agency was valued at ₹ 1,20,000. Y’s share within the earnings of the agency until the date of dying from the final Stability Sheet was to be calculated on the premise of gross sales. Gross sales in the course of the yr 2017-18 was ₹ 15,00,000 and revenue earned in the course of the yr was ₹ 3,00,000. Gross sales from 1st April, 2018 to twenty fourth June, 2018 have been ₹ 2,00,000. The overall quantity payable to Y’s executors on his dying was ₹1,75,000. This quantity was paid to them on 15-7-2018. Cross the mandatory journal entries for the above transactions within the books of the agency.
Reply:
Working Notes:
1. Calculating New Ratio and Gaining Ratio:
When one associate dies and no details about the New Ratio is given. It’s assumed that Remaining Companions will share earnings and losses of their Outdated Ratio.
Subsequently, New Ratio and Gaining Ratio of X and Z = 2 : 1
2. Calculating Share of Goodwill of Y:
Share of Goodwill of Y = 
Goodwill paid by X = 
Goodwill paid by Z = 
3. Calculation share of revenue of Y until the date of dying on Gross sales foundation:
Y’s share of revenue = 
19. Harish and Gopal have been companions in a agency sharing earnings within the ratio of three : 2. On thirty first March, 2018, their Stability Sheet was as follows :
On the above date the agency was dissolved. The assorted belongings have been realized and liabilities have been settled as underneath :
(i) Gopal agreed to pay his spouse’s mortgage.
(ii) Leasehold premises realised ₹ 1,50,000 and Debtors ₹ 12,000 much less.
(iii) Half of the collectors agreed to simply accept furnishings of the agency as full settlement of their declare and remaining half agreed to simply accept 10% much less.
(iv) 50% inventory was taken over by Harish on cost by cheque of ₹ 90,000 and remaining inventory was bought for ₹ 94,000.
(v) Realization bills of ₹ 10,000 have been paid by Gopal on behalf of the agency.
Put together Realization Account.
Answer:
Working Word:
Half of collectors = 18,000
Quantity payable to collectors = 18,000 − 1,800 = ₹ 16,200
OR
Sudha, Naresh and Geeta have been companions in a agency sharing earnings within the ratio of 5 : 3 : 2. Their mounted capitals have been ₹ 6,00,000; ₹ 4,00,000 and ₹2,00,000 respectively. In addition to her capital Geeta had given a mortgage of ₹ 75,000 to the agency. Their partnership deed offered for the next :
(i) Curiosity on capital @ 9% p.a.
(ii) Curiosity on companions’ drawings @ 12% p.a.
(iii) Wage to Sudha ₹ 30,000 per 30 days and to Naresh ₹ 40,000 per quarter.
(iv) Curiosity on Geeta’s mortgage @ 9% p.a. Throughout the yr Sudha withdrew ₹ 50,000 on the finish of every quarter; Naresh withdrew ₹ 50,000 at first of every half yr and Geeta withdrew₹ 70,000 on the finish of every half yr.
The revenue of the agency for the yr ended 31-3-2019 earlier than permitting curiosity on Geeta’s mortgage was ₹ 7,06,750.
Put together Revenue and Loss Appropriation Account.
Reply:
Working Word:
1. Calculation of Web Revenue:
Web Revenue earlier than Curiosity on Mortgage = ₹7,06,750.
Curiosity on Geets’s Mortgage = 
Web Revenue after Curiosity on Mortgage = 7,06,750 − 6,750 = ₹7,00,000.
2. Calculation of Curiosity on Drawings:
Sudha = 
Naresh = 
Geeta = 
20. Cross journal entries within the e-book of X Ltd. within the following instances :
(i) The Firm took a mortgage of ₹ 1,60,000 from SBI and issued 2,000, 12% debentures of ₹ 100 every as collateral safety.
(ii) Issued 1,000, 12% debentures of ₹ 100 every at 10% premium, redeemable at a premium of 5%.
(iii) Bought equipment ₹ 4,60,000, from Beta Ltd. Cost was made by difficulty of 9% debentures of ₹ 100 every at a premium of 15%
redeemable at par.
Reply:
(i)
(ii)
(iii)
21. Zee Ltd. invited purposes for issuing 3,40,000 fairness shares of ₹ 10 every at a premium of ₹ 5 per share. The quantity was payable as follows:
On utility ₹ 4 per share (together with ₹ 2 premium)
On allotment ₹ 5 per share (together with ₹ 2 premium)
On First and Remaining name – Stability. Purposes for six,00,000 shares have been obtained. Software for 1,80,000 shares was rejected and utility cash was refunded. Shares have been allotted on pro-rata foundation to the remaining candidates. Extra cash obtained with purposes was adjusted in direction of sum due on allotment. Yamini who had utilized for 2100 shares did not pay allotment cash and her shares have been forfeited instantly. Vani to whom 6800 shares have been allotted paid her total share cash due on allotment. Afterwards First and Remaining name was made and was duly obtained. Out of the forfeited shares 850 shares have been reissued to Vansh at ₹ 8 per share totally paid up.
Cross mandatory journal entries for the above transactions within the books of the corporate by opening calls-in-arrears and calls-in-advance accounts.
Reply:
Working Notes:
1.
2. Calculating Yamini’s Calls-in-Arrear:
No. of shares utilized by her = 2,100 shares
No. of shares allotted to her = x
subsequently, x =
Advance paid by her on the time of utility = 
Quantity payable by her on allotment =
so, Calls-in-Arrears of Yamini = 8,500 − 1,600 = ₹ 6,900
3. Calculating Advance paid by Vani:
No. of Shares allotted to her = 6,800 shares
Quantity payable at First and Remaining Name =
4. Calculating Precise Quantity to be obtained at time of Allotment:
5. Calculating Quantity to be transferred to Capital Reserve:
Stability in Share Forfeiture A/c for 1,700 shares = ₹ 5,000
So, For 850 shares = 
Quantity to be transferred to Capital Reserve = 2,500 − 1,700 = ₹ 800.
OR
Okay.N. Ltd. invited purposes for issuing 6,00,000 fairness shares of ₹ 10 every at a premium of ₹ 3 per share. The quantity was payable as follows:
On Software and Allotment ₹ 3 per share.
On First Name ₹ 4 per share
On Second and Remaining Name Stability (together with premium).
Purposes for 8,00,000 shares have been obtained. Purposes for 50,000 shares have been rejected and the applying cash was refunded. Shares Class I : Those that had utilized for 4,00,000 share have been allotted 3,00,000 shares on pro-rata foundation.
Class II : The remaining candidates have been allotted the remaining shares on pro-rata foundation. Extra utility cash obtained with purposes was adjusted in direction of sums due on first name. Rakesh to whom 6,000 shares have been allotted did not pay the primary name cash. Rakesh belonged to class I. His shares have been forfeited. The forfeited shares have been re-issued at ₹13 per share totally paid up. The second name was made afterwards and was duly obtained. Cross mandatory journal entries for the above transactions within the books of Okay.N. Ltd.
Reply:
Working Notes:
1.
2. Calculating Rakesh’s Calls-in-Arrear:
No. of shares utilized by him = x
No. of shares allotted to him = 6,000 shares
Subsequently, x = 
Advance paid by him on the time of utility and allotment = 
Quantity payable by him on First Name = 
so, Calls-in-Arrears of Rakesh = 24,000 − 6,000 = ₹ 18,000
22. Raman and Aman have been companions in a agency and have been sharing earnings in 3 : 1 ratio. On 31-3-2019 their steadiness sheet was as follows:
On the above date Suman was admitted as a brand new associate for 1/fifth share within the earnings on the next circumstances :
(i) Suman will deliver ₹ 2,00,000 as her capital and the mandatory quantity for her share of goodwill premium. The goodwill of the agency on Suman’s
Share admission was valued at ₹ 1,00,000.
(ii) Excellent bills can be paid off. ₹ 5,000 can be written off as unhealthy money owed and a provision of 5% for unhealthy money owed on debtors was to maintained.
(iii) The legal responsibility in direction of workmen compensation was estimated at ₹ 60,000.
(iv) Equipment was to be depreciated by ₹ 18,000 and Land and Constructing was to be depreciated by ₹ 54,000.
Cross mandatory journal entries for the above transactions within the books of the agency.
Reply:
Working Notes:
1. Calculation of New Ratio and Sacrificing Ratio:
Let the full share of the New agency be 1
So, the Remaining share of Raman and Aman = 
New Ratio of Raman = 
New Ratio of Aman = 
New Ratio of Suman = 
New Ratio of the companions = 3 : 1 : 1
Sacrificing Ratio of Raman = 
Sacrificing Ratio of Aman = 
Sacrificing Ratio = 3 : 1
2. Calculating Share of Goodwill:
Premium for Goodwill to be introduced in by Suman =
Share of Raman in Premium for Goodwill = 
Share of Aman in Premium for Goodwill = 
OR
A, B and C have been companions in a agency. Their Stability Sheet as at thirty first March, 2019 was as follows :
B retired on 1st April, 2019. A and C determined to share earnings within the ratio of two : 1. The next phrases have been agreed upon :
(i) Goodwill of the agency was valued at ₹ 30,000.
(ii) Unhealthy-debts ₹ 4,000 have been written off. The availability for uncertain money owed was to be maintained @ 10% on debtors.
(iii) Land and Constructing was to be elevated to ₹ 1,32,000.
(iv) Furnishings was bought for ₹ 20,000 and the cost was obtained by cheque.
(v) Legal responsibility in direction of Workmen Compensation was estimated at ₹ 1,500.
(vi) B was to be paid ₹ 20,000 by way of a cheque and the steadiness was transferred to his mortgage account.
Put together Revaluation Account, Companions’ Capital Accounts and Financial institution Account.
Reply:
PART – B
Possibility – I
(Evaluation of Monetary Statements)
23. The fast ratio of an organization is 0.5 : 0.75. Will money gross sales of ₹ 5,000 improve, lower or not change the ratio ? Give cause in assist of your reply.
Reply: Money gross sales will improve the Fast Ratio as a result of money being a fast asset will improve the full of fast belongings, with out altering the Present Liabilities.
24. Worker profit bills embrace ___________. (bonus/depreciation/earnings tax)
Reply: Worker profit bills embrace Bonus.
25. Which of the next is NOT a limitation of the evaluation of economic statements?
(a) Window Dressing
(b) Worth degree adjustments ignored
(c) Subjectivity
(d) Intra-firm comparability doable
Reply: (d) Intra-firm comparability doable
26. Beneath which of the next headings/sub-headings, Calls upfront can be introduced within the Stability Sheet of a Firm as per Schedule III Half I of the Firms Act, 2013?
(a) Present Liabilities
(b) Share Capital
(c) Share Software Cash Pending Allotment
(d) Reserves and Surplus.
Reply: (a) Present Liabilities
27. Curiosity obtained in money from loans and advances is taken into account as _____ exercise whereas making ready money circulation assertion.
Reply: Curiosity obtained in money from loans and advances is taken into account as Investing exercise whereas making ready money circulation assertion.
28. Listing any two gadgets apart from money in hand and cheques in hand which are introduced underneath the sub-heading ‘Money and Money Equivalents’ within the Stability Sheet of an organization.
Reply: Two gadgets apart from money in hand and cheques in hand which are introduced underneath the sub-heading ‘Money and Money Equivalents’ within the Stability Sheet of an organization are:
- Financial institution Stability
- Present Investments
29. Whereas making ready money circulation assertion, will ‘Money withdrawn from financial institution’ end result into influx, outflow or no circulation of money? Give cause in assist of your reply.
Reply: No Circulation as a result of withdrawal from the financial institution doesn’t have an effect on the ‘Money and Money Equivalents’.
30. The Income from operations of a agency is ₹ 6,00,000. Its stock turnover ratio is 3 instances. If gross revenue ratio is 25%, calculate its opening stock and shutting stock. The opening stock is 25% of closing stock.
Reply:
Income = ₹ 6,00,000
Gross Revenue = 25% 0f 6,00,000 = ₹ 1,50,000
Stock Turnover Ratio = 
Common Stock = 1,50,000
Let Closing Stock be x; then Opening Stock =
of x
x = 2,40,000 (Closing Capital)
Opening Capital = 
OR
From the next data, calculate ‘Curiosity protection Ratio’:
Revenue after curiosity and tax ₹ 6,00,000
10% Debentures ₹ 8,00,000
Fee of Earnings Tax 40%
Reply:
Curiosity on Debt = 
Tax = 
Revenue earlier than Curiosity and Tax = 6,00,000 + 80,000 + 4,00,000 = ₹ 10,80,000
Curiosity Protection Ratio = 
= 13.5 instances
31. Fill within the quantities left clean within the following Frequent Dimension Assertion of Revenue and Loss for the yr ended thirty first March, 2019.
Reply:
OR
From the next Assertion of Revenue and Lack of Expertise India Ltd. for the yr ended thirty first March, 2018 and 2019, put together a Comparative Assertion of Revenue and Loss.
Reply:
32. From the next Stability Sheet of Gopal Ltd. and the extra data as at thirty first March, 2019, put together a Money Circulation assertion when money flows from financing actions is₹ 2,32,000.
Extra Data :
Tax ₹ 1,50,000 was paid in the course of the yr.
Reply:
Working Word:
OPTION – II
(Computerized Accounting)
23. The method of evaluating enter knowledge with some recognized knowledge is named
(a) storage knowledge
(b) data knowledge
(c) knowledge validation
(d) knowledge entry
Reply: (c) knowledge validation
24. A ______ attribute might be divided into smaller sub-parts however a _____ attribute can’t be additional sub divided.
Reply: A Composite attribute might be divided into smaller sub-parts however a Easy attribute can’t be additional sub divided.
25. Title the accounting data sub-system which offers with receipt and cost of bodily money and digital fund switch.
(a) Money and Financial institution sub-system.
(b) Gross sales and accounts receivable sub-system.
(c) Buy and accounts payable sub-system.
(d) Costing sub-system.
Reply: (a) Money and Financial institution sub-system.
26. Match the motion of mouse with the important thing strokes.
(i) One cell down
(ii) One cell up
(a) Down arrow key (⇣) or enter
(b) Up arrow key (⇡)
(c) Proper arrow key (⇢)
(d) Left arrow key (⇠)
(i) (ii)
(A) (a) (d)
(B) (b) (c)
(C) (d) (a)
(D) (a) (c)
Reply: (D) (a) (c)
27. _______ prompts the person to enter parameters or standards by way of an enter field for choosing a set of data with completely different standards.
Reply: Parameter Question prompts the person to enter parameters or standards by way of an enter field for choosing a set of data with completely different standards.
28. {Hardware} refers to
(a) System software program and utility software program.
(b) Laptop related peripherals and their community.
(c) A logical sequence of actions to carry out a job.
(d) All the above.
Reply: (b) Laptop related peripherals and their community.
29. Rows are referred by alpha characters and columns are numerically numbered from high to backside. (True/False)
Reply: False
30. State any three options of fine Accounting Software program.
Reply: Three options of fine Accounting Software program are:
- Performs all primary accounting actions
- Manages all of the saved Knowledge
- Manges Pay Roll
OR
Title the operate of Excel which converts numeric worth to textual content in a particular quantity format. Clarify its syntax.
Reply: The operate of Excel which converts numeric worth to textual content in a particular quantity format is named ‘TEXT’.
Syntax: ‘TEXT’ (Worth,format__text)
Worth: A numeric worth that evaluates a numeric worth or the involved cell containing the numeric worth.
Type Textual content: A textual content string enclosed in citation mark in a numeric kind.
31. Why is it essential to have security options in accounting software program? Clarify any two instruments which give knowledge safety.
Reply: It’s essential to have security options in accounting software program to make sure the secrecy and integrity of accounting knowledge.
Two such instruments used are:
1. Password Safety: Password is probably the most generally used safety software. Solely a licensed individual conscious of the password can entry the info. It ensures the protection and integrity of the accounting data.
2. Knowledge Vault: Knowledge Vault ensures the historic presentation of knowledge. The Knowledge Vault can’t be hacked and even makes use of knowledge encryption strategies for safety functions.
OR
What is supposed by # DIV/O ! Error? State the explanations for the error.
Reply: # DIV/O ! Error means an error occurred because of dividing any quantity by Zero.
There might be two causes for the error:
i. When a method is entered that comprises specific division by zero. E.g. = 5/0
ii. Utilizing the cell reference to a clean cell or to a cell that comprises zero as a division
32. ‘A Ltd.’ desires to enter their gross sales associated knowledge on excel sheet, for his or her three merchandise to organize a graphic presentation to be introduced within the Board Of Administrators assembly. State the essential steps to organize presentation.
Reply: These are the essential steps to organize a presentation to current sales-related knowledge:
1. Knowledge needs to be collected from varied departments, heads/divisions for every quarter.
2. The info for various quarters needs to be entered on an excel sheet earlier than the product is taken into account.
3. Whole gross sales for all of the merchandise and single product for all completely different quarters needs to be calculated by summing up rows and columns.
4. By utilizing the insert tab and clicking on ‘Chart’, product smart complete gross sales is chosen right into a chart by deciding on chart sort.
5. The info worksheet needs to be reorganised to attract a chart/graph for the given knowledge.
6. Chart or number of charts needs to be drawn mixing up the choices to be introduced within the assembly.
