CLASS 12 CBSE TERM1 ACCOUNTS SPECIMEN 2022

BOARD -

CLASS -

SUBJECT -

CBSE

12th

ACCOUNTS

Paper Pattern for MCQ Term-I

TIME -

MARKS -

1.5 Hour

40

Visit CBSE OFFICIAL PAGE for Regulations and Syllabus of Class 12th CBSE

Solved Specimen Paper Semester-I 2021

PART - I

SECTION- A

Q.1 Gain / loss on revaluation at the time of change in profit sharing ratio of existing partners is shared by ___(i)______ whereas in case of admission of a partner it is shared by____(ii)_____

  1. (i) Remaining Partners, (ii) All Partners.
  2. (i) All Partners, (ii) Old partners
  3. (i) New Partner, (ii) All partner
  4. (i) Sacrificing Partner, (ii) Incoming partner

Solution

Q.2 Calculate the amount of second & final call when Abhijit Ltd, issues Equity shares of ₹10 each at a premium of 40% payable on Application ₹3, On Allotment ₹5, On First Call ₹2

  1. Second & final call ₹3
  2. Second & final call ₹4
  3. Second & final call ₹1
  4. Second & final call ₹14

Solution

Q.3 Anish Ltd, issued a prospectus inviting applications for 2,000 shares. Applications were received for 3,000 shares and pro- rata allotment was made to the applicants of 2,400 shares. If Dhruv has been allotted 40 shares, how many shares he must have applied for?

  1. 40
  2. 44
  3. 48
  4. 52

Solution

Q.4 Ambrish Ltd offered 2,00,000 Equity Shares of ₹10 each, of these 1,98,000 shares were subscribed. The amount was payable as ₹3 on application, ₹4 an allotment and balance on first call. If a shareholder holding 3,000 shares has defaulted on first call, what is the amount of money received on first call?

  1. ₹9,000.
  2. ₹5,85,000
  3. ₹5,91,000
  4. ₹6,09,000

Solution

Q.5 What will be the correct sequence of events?

Which letter denotes the area of the graph where both acid and salt are present?(i) Forfeiture of shares. (ii) Default on Calls. (iii) Re-issue of shares. (iv) Amount transferred to capital reserve. Options:
  1. (i), (iv), (ii), (iii)
  2. (ii), (iv), (i), (iii)
  3. (ii), (i), (iii), (iv)
  4. (iii), (iv), (i) (ii)

Solution

Q.6 Arun and Vijay are partners in a firm sharing profits and losses in the ratio of 5:1.

If the value of machinery reflected in the balance sheet is overvalued by 33 1/3 %, find out the value of Machinery to be shown in the new Balance Sheet:

  1. ₹ 44,000
  2. ₹48,000
  3. ₹ 32,000
  4. ₹30,000

Solution

Q.7 Which of the following is true regarding Salary to a partner when the firm maintains fluctuating capital accounts?

  1. Debit Partner’s Loan A/c and Credit P & L Appropriation A/c
  2. Debit P & L A/c and Credit Partner’s Capital A/c
  3. Debit P & L Appropriation A/c and Credit Partner’s Current A/c
  4. Debit P & L Appropriation A/c and Credit Partner’s Capital A/c

Solution

Q.8 At the time of reconstitution of a partnership firm, recording of an unrecorded liability will lead to:

  1. Gain to the existing partners
  2. Loss to the existing partners
  3. Neither gain nor loss to the existing partners
  4. None of the above

Solution

Q.9 E, F and G are partners sharing profits in the ratio of 3:3:2. According to the partnership agreement, G is to get a minimum amount of ₹80,000 as his share of profits every year and any deficiency on this account is to be personally borne by E. The net profit for the year ended 31st March 2021 amounted to ₹3,12 ,000. Calculate the amount of deficiency to be borne by E?

  1. ₹1,000
  2. ₹4,000
  3. ₹8,000
  4. ₹2,000

Solution

Q.10 At the time of admission of a partner, what will be the effect of the following information? Balance in Workmen compensation reserve ₹40,000. Claim for workmen compensation ₹45,000.

  1. ₹45,000 Debited to the Partner’s capital Accounts
  2. ₹40,000 Debited to Revaluation Account
  3. ₹5,000 Debited to Revaluation Account
  4. ₹5,000 Credited to Revaluation Account

Solution

Q.11 In the absence of partnership deed, a partner is entitled to an interest on the amount of additional capital advanced by him to the firm at a rate of:

  1. entitled for 6% p.a. on their additional capital, only when there are profits
  2. entitled for 10% p.a. on their additional capital
  3. entitled for 12% p.a. on their additional capital
  4. not entitled for any interest on their additional capitals

Solution

Q.12 Revaluation of assets at the time of reconstitution is necessary because their present value may be different from their:

  1. Market Value
  2. Net Value
  3. Cost of Asset
  4. Book Value

Solution

Q.13 If average capital employed in a firm is ₹8,00,000, average of actual profits is ₹1,80,000 and normal rate of return is10%, then value of goodwill as per capitalization of average profits is:

  1. ₹10,00,000
  2. ₹18,00,000
  3. ₹80,00,000
  4. ₹78,20,000

Solution

Q.14 In which of the following situation Companies Act 2013 allows for issue of shares at discount?

  1. Issued to vendors.
  2. Issued to public
  3. Issued as sweat equity
  4. None of the above

Solution

Q.15 As per Section 52 of Companies Act 2013, Securities Premium Reserve cannot be utilised for:

  1. Writing off capital losses
  2. Issue of fully paid bonus shares
  3. Writing off discount on issue of securities.
  4. Writing off preliminary expenses

Solution

Q.16 Net Assets minus Capital Reserve is:

  1. Purchase consideration
  2. Goodwill
  3. Total assets
  4. Liquid assets

Solution

Q.17 Kalki and Kumud were partners sharing profits and losses in the ratio of 5:3. On 1st April,2021 they admitted Kaushtubh as a new partner and new ratio was decided as 3:2:1. Goodwill of the firm was valued as ₹3,60,000. Kaushtubh couldn’t bring any amount for goodwill. Amount of goodwill share to be credited to Kalki and Kumud Account’s will be: -

  1. ₹ 37,500 and ₹22,500 respectively
  2. ₹ 30,000 and ₹30,000 respectively
  3. ₹ 36,000 and ₹24,000 respectively
  4. ₹ 45,000 and ₹15,000 respectively

Solution

Q.18 Sarvesh, Sriniketan and Srinivas are partners in the ratio of 5:3: 2. If Sriniketan’s share of profit at the end of the year amounted to ₹1,50,000, what will be Sarvesh’s share of profits?

  1. ₹5,00,000
  2. ₹1,50,000.
  3. ₹3,00,000
  4. ₹2,50,000

Solution

PART - I

SECTION- B

Q.19 Angle and Circle ware partners in a firm. Their Balance Sheet showed Furniture at ₹2,00,000; Stock at ₹1,40,000; Debtors at ₹1,62,000 and Creditors at ₹60,000. Square was admitted and new profit-sharing ratio was agreed at 2:3:5. Stock was revalued at ₹1,00,000, Creditors of ₹15,000 are not likely to be claimed, Debtors for ₹2,000 have become irrecoverable and Provision for doubtful debts to be provided @ 10%. Angle’s share in loss on revaluation amounted to ₹30,000. Revalued value of Furniture will be:

  1. ₹2,17,000
  2. ₹1,03,000
  3. ₹3,03,000
  4. ₹1,83,000

Solution

Q.20 Asha and Nisha are partner’s sharing profits in the ratio of 2:1. Kashish was admitted for 1/4 share of which 1/8 was gifted by Asha. The remaining was contributed by Nisha. Goodwill of the firm is valued at ₹ 40,000. How much amount for goodwill will be credited to Nisha’s Capital account?

  1. ₹2,500
  2. ₹5,000
  3. ₹20,000
  4. ₹ 40,000

Solution

>

Q.21 At the time of admission of new partner Vasu, Old partners Paresh and Prabhav had debtors of ₹6,20,000 and a provision for doubtful debts of ₹20,000 in their books. As per terms of admission, assets were revalued, and it was found that debtors worth ₹15,000 had turned bad and hence should be written off. Which journal entry reflects the correct accounting treatment of the above situation

Solution

Q.22 Given below are two statements, one labelled as Assertion (A) and the other labelled as Reason (R) Assertion (A): Transfer to reserves is shown in P & L Appropriation A/c. Reason (R): Reserves are charge against the profits. In the context of the above statements, which one of the following is correct?

  1. (A) is correct, but (R) is wrong
  2. Both (A) and (R) are correct.
  3. (A) is wrong, but (R) is correct
  4. Both (A) and (R) are wrong

Solution

Q.23 Anubhav, Shagun and Pulkit are partners in a firm sharing profits and losses in the ratio of 2:2:1. On 1st April 2021, they decided to change their profit-sharing ratio to 5:3:2. On that date, debit balance of Profit & Loss A/c ₹30,000 appeared in the balance sheet and partners decided to pass an adjusting entry for it. Which of the undermentioned options reflect correct treatment for the above treatment?

  1. Shagun's capital account will be debited by ₹3,000 and Anubhav’s capital account credited by ₹3,000
  2. Pulkit's capital account will be credited by ₹3,000 and Shagun's capital account will be credited by ₹3,000
  3. Shagun's capital account will be debited by ₹30,000 and Anubhav’s capital account credited by ₹30,000
  4. Shagun's capital account will be debited by ₹3,000 and Anubhav’s and Pulkit’s capital account credited by ₹2,000 and ₹1,000 respectively

Solution

Q.24 A, B and C are partners, their partnership deed provides for interest on drawings at 8% per annum. B withdrew a fixed amount in the middle of every month and his interest on drawings amounted to ₹4,800 at the end of the year. What was the amount of his monthly drawings?

  1. ₹10,000
  2. ₹5,000
  3. ₹1,20,000
  4. ₹48,000

Solution

SECTION- B

Q.25 Abhay and Baldwin are partners sharing profit in the ratio 3:1. On 31st March 2021, firm’s net profit is ₹1,25,000. The partnership deed provided interest on capital to Abhay and Baldwin ₹15,000 & ₹10,000 respectively and Interest on drawings for the year amounted to ₹6000 from Abhay and ₹4000 from Baldwin. Abhay is also entitled to commission @10% on net divisible profits. Calculate profit to be transferred to Partners Capital A/c’s

  1. ₹1,00,000
  2. ₹1,10,000
  3. ₹1,07,000
  4. ₹90,000

Solution

Q.26 Given below are two statements, one labelled as Assertion (A) and the other labelled as Reason (R): Assertion (A): Revaluation A/c is prepared at the time of Admission of a partner. Reason (R): It is required to adjust the values of assets and liabilities at the time of admission of a partner, so that the true financial position of the firm is reflected. In the context of the above two statements, which of the following is correct?

  1. Both (A) and (R) are correct and (R) is the correct reason of (A)
  2. Both (A) and (R) are correct but (R) is not the correct reason of (A)
  3. Only (R) is correct
  4. Both (A) and (R) are wrong

Solution

Q.27 Apaar Ltd forfeited 4,000 shares of ₹20 each, fully called up, on which only application money of ₹6 has been paid. Out of these 2,000 shares were reissued and ₹8,000 has been transferred to capital reserve. Calculate the rate at which these shares were reissued

  1. ₹20 Per share
  2. ₹18 Per share
  3. ₹22 Per share
  4. ₹8 Per share

Solution

Q.28 Which of the following statement is/are true? (i) Authorized Capital < Issued Capital (ii) Authorized Capital ≥ Issued Capital (iii) Subscribed Capital ≤ Issued Capital (iv) Subscribed Capital> Issued Capital

<
  1. (i) only
  2. (i) and (iv) Both
  3. (ii) and (iii) Both
  4. (ii) only

Solution

Q.29 Mickey, Tom and Jerry were partners in the ratio of 5:3:2. On 31st March 2021, their books reflected a net profit of ₹2,10,000. As per the terms of the partnership deed they were entitled for interest on capital which amounted to ₹80,000, ₹60,000 and ₹40,000 respectively. Besides this a salary of ₹60,000 each was payable to Mickey and Tom. Calculate the ratio in which the profits would be appropriated

  1. 1:1:1
  2. 5:3:2
  3. 7:6:2
  4. 4:3:2

Solution

Q30. Mohit had been allotted for 600 shares by a Govinda Ltd on pro rata basis which had issued two shares for every three applied. He had paid application money of ₹3 per share and could not pay allotment money of ₹5 per share. First and final call of ₹2 per share was not yet made by the company. His shares were forfeited. the following entry will be passed:
Here X, Y and Z are:

  1. ₹ 6,000; ₹2,700; ₹3,000 respectively
  2. ₹ 9,000; ₹2,700; ₹4,500 respectively
  3. ₹ 4,800; ₹2,700; ₹2,100 respectively
  4. ₹ 7,200; ₹2,700; ₹4,500 respectively

Solution

Q.31 Given below are two statements, one labelled as Assertion (A) and the other labelled as Reason (R): Assertion (A): In case of shares issued on Pro–rata basis, excess money received at the time of application can be utilised till allotment only. Reason (R): Company has to pay interest on calls in advance @12% p.a. for amount adjusted towards calls (if any). In the context of the above two statements, which of the following is correct?

  1. Both (A) and (R) are true, but (R) is not the explanation of working capital management.
  2. Both(A) and (R) are true and (R) is a correct explanation of (A)
  3. Both (A) and (R) are false
  4. (A) is false, but (R) is true

Solution

Q.32 Ajay and Vinod are partners in the ratio of 3:2. Their fixed Capital were ₹3,00,000 and ₹4,00,000 respectively. After the close of accounts for the year it was observed that the Interest on Capital which was agreed to be provided at 5% pa was erroneously provided at 10%p.a. By what amount will Ajay’s account be affected if partners decide to pass an adjustment entry for the same?

  1. Ajay’s Current A/c will be Debited by ₹15,000
  2. Ajay’s Current A/c will be Credited by ₹6,000
  3. Ajay’s Current A/c will be Credited by ₹35,000
  4. Ajay’s Current A/c will be Debited by ₹20,000

Solution

Q.33 Vishnu Ltd. forfeited 20 shares of ₹10 each, ₹8 called up, on which John had paid application and allotment money of ₹5 per share, of these, 15 shares were reissued to Parker as fully paid up for ₹6 per share. What is the balance in the share Forfeiture Account after the relevant amount has been transferred to Capital Reserve Account?

  1. ₹0
  2. ₹5
  3. ₹25
  4. ₹100

Solution

Q.34 Newfound Ltd took over business of Old land ltd and paid for it by issue of 30,000, Equity Shares of ₹100 each at a par along with 6% Preference Shares of ₹1,00,00,000 at a premium of 5% and a cheque of ₹8,00,000. What was the total agreed purchase consideration payable to Old Land ltd.

  1. ₹1,05,00,000
  2. ₹1,43,00,000
  3. ₹1,40,00,000
  4. ₹1,35,00,000

Solution

Q.35 A and B are partners in the ratio of 3:2. C is admitted as a partner and he takes ¼th of his share from A. B gives 3/16 from his share to C. What is the share of C?

  1. 1/4
  2. 1/16
  3. 1/6
  4. 1/16

Solution

Q.36 Krishan Ltd has Issued Capital of 20, 00,000 Equity shares of ₹10 each. Till Date ₹8 per share have been called up and the entire amount received except calls of ₹4 per share on 800 shares and ₹3 per share from another holder who held 500 shares. What will be amount appearing as ‘Subscribed but not fully paid capital’ in the balance sheet of the company?

  1. ₹ 2,00,00,000
  2. ₹ 1,95,99,000
  3. ₹ 1,59,95,300
  4. ₹ 1,99,95,300

Solution

PART - I

SECTION- C

Question no.’s 37 and 38 are based on the hypothetical situation given below. Bright Star Limited is engaged in manufacture of high-end medical equipment. Considering the prospects of high growth in this segment the company has decided to expand and for this purpose additional investment of ₹50,00,00,000 is required. Directors have decided that 20% of this requirement would be financed by raising long term debts and balance by issue of Equity shares. As per memorandum of association of the company the face value of Equity shares is ₹100 each. Also, considering the market standing of the company these shares would be issued at a premium of 25%. Directors decided to issue sufficient shares to collect the desired amount (including premium). The prospectus was issued to public, and the issue was oversubscribed by 2,00,000 shares which were issued letters of regret. Answer the below mentioned questions considering that the entire amount was payable on application.

Q.37 What is the total amount collected on application?

  1. ₹42,50,00,000
  2. ₹40,00,00,000
  3. ₹32,00,00,000
  4. None of the above

Solution

Q.38 How many Equity shares were offered for issue by Bright Star Ltd?

  1. 40,00,000 shares
  2. 50,00,000 shares
  3. 35,00,000 shares
  4. 32,00,000 shares

Solution

Question no.’s 39, 40 and 41 are based on the hypothetical situation given below. On 1st September 2020, twenty students of Modern College started their Partnership Firm in the name of “Be Safe” for selling sanitisers on digital mode. Since they were good friends of each other, they were not having any explicit agreement in place. All of them have agreed to invest ₹15,000/- each as capital. The books were closed on 31st March 2021, on which date the following information was provided by the firm:


Q.39 Calculate the amount of profits to be transferred to Profit and Loss Appropriation Account. -

  1. Profit ₹58,000
  2. Profit ₹44,000
  3. Profit ₹59,200
  4. Profit ₹58,700

Solution

Q.40 On 31st March 2021, Remuneration to Partners will be provided to the partners of “Be Safe” but only out of:

  1. Profits for the accounting year
  2. Reserves
  3. Accumulated Profits
  4. Goodwill

Solution

Q.41 On 01st December 2020 one of the partners of the firm introduced additional capital of ₹30,000 and also advanced a loan of ₹40,000 to the firm. Calculate the amount of interest that Partner will receive for the current accounting period-

  1. ₹4,200
  2. ₹1,400
  3. ₹ 1575
  4. ₹ 800

Solution

PART - II

SECTION- A

Q.42 Given below are two statements, one labelled as Assertion (A) and the other labelled as Reason (R): Assertion (A): The focus of calculation of working capital revolves around managing the operating cycle of the business. Reason (R): It is because the concept of operating cycle is required to ascertain the liquidity of assets and urgency of payments to liabilities. In the context of the above two statements, which of the following is correct?

  1. Both (A) and (R) are true, but (R) is not the explanation of working capital management
  2. Both(A) and (R) are true and (R) is a correct explanation of (A)
  3. Both (A) and (R) are false
  4. (A) is false, but (R) is true.

Solution

Q.43 Which of the following are included in traditional classification of ratios? (i) Liquidity Ratios. (ii) Statement of Profit and loss Ratios. (iii) Balance Sheet Ratios. (iv) Profitability Ratios. (v) Composite Ratios. (vi) Solvency Ratios.

  1. (ii), (iii) and (v)
  2. (i), (iv) and (vi)
  3. (i), (ii) and (vi)
  4. All (i), (ii), (iii), (iv), (v), (vi)

Solution

Q.44 The following groups of ratios primarily measure risk:

  1. solvency, activity, and profitability
  2. liquidity, efficiency, and solvency
  3. liquidity, activity, and profitability
  4. liquidity, solvency, and profitability

Solution

Q.45 Which one of the following is correct?

(i) A ratio is an arithmetical relationship of one number to another number. (ii) Liquid ratio is also known as acid test ratio. (iii) Ideally accepted current ratio is 1: 1. (iv) Debt equity ratio is the relationship between outsider’s funds and shareholders’ funds. In the context of the above two statements, which of the following options is correct?
  1. All (i), (ii), (iii) and (iv) are correct
  2. Only (i), (ii) and (iv) are correct
  3. Only (ii), (iii) and (iv) are correct
  4. Only (ii) and (iv) are correct

Solution

Q.46 Which of the following are the tools of Vertical Analysis? (i) Ratio Analysis. (ii) Comparative Statements. (iii) Common Size Statements

  1. Only (iii)
  2. Both (i) and (iii)
  3. Both (i) and (ii)
  4. Only (i)

Solution

Q.47 Match the items given in Column I with the headings/subheadings (Balance sheet) as defined in Schedule III of Companies Act 2013.
Choose the correct option:

  1. (I)-(a), (II)-(b), (III)- (d), (IV)- (c), (V)-(e)
  2. (I)-(d), (II)- (a), (III)-(b), (IV)- (c), (V)-(e)
  3. (I)-(d), (II)- (a), (III)-(b), (IV)-(e), (V)-(c)
  4. (I)- (e), (II)- (d), (III)- (a), (IV)-(b), (V)-(b)

Solution

Q.48 Which ratio indicates the proportion of assets financed out of shareholders’ funds?

  1. Debt equity ratio
  2. Fixed assets turnover ratio
  3. Proprietary ratio
  4. Total assets to debt ratio

Solution

PART - II

SECTION- B

Q.49 If Total sales is ₹2,50,000 and credit sales is 25% of Cash sales. The amount of credit sales is:

  1. ₹50,000
  2. ₹2,50,000
  3. ₹16,000
  4. ₹3,00,000

Solution

Q.50What will be the amount of gross profit of a firm if its average inventory is ₹80,000, Inventory turnover ratio is 6 times, and the Selling price is 25% above cost?

  1. ₹1,20,000
  2. ₹1,60,000
  3. ₹2,00,000
  4. None of the above

Solution

Q.51Which of the following statements are false? a) When all the comparative figures in a balance sheet are stated as percentage of the total, it is termed as horizontal analysis. b) When financial statements of several years are analysed, it is termed as vertical analysis. c) Vertical Analysis is also termed as time series analysis. Choose from the following options:

  1. Both (a) and (b)
  2. Both (a) and (c)
  3. Both (b) and (c)
  4. All three (a), (b), (c)

Solution

Q.52Given below are two statements, one labelled as Assertion (A) and the other labelled as Reason (R): Assertion (A): Increasing the value of closing inventory increases profit. Reason (R): Increasing the value of closing inventory reduces cost of goods sold. In the context of the above two statements, which of the following is correct?

  1. Both (A) and (R) are correct and (R) is the correct reason of (A)
  2. Both (A) and (R) are correct but (R) is not the correct reason of (A)
  3. Only (R) is correct
  4. Both (A) and (R) are wrong

Solution

Q.53 Given below are two statements, one labelled as Assertion (A) and the other labelled as Reason (R): Assertion (A): A high operating ratio indicates a favourable position. Reasoning (R): A high operating ratio leaves a high margin to meet non-operating expenses. In the context of the above two statements, which of the following is correct?

  1. (A) and (R) both are correct and (R) correctly explains (A)
  2. Both (A) and (R) are correct but (R) does not explain (A)
  3. Both (A) and (R) are incorrect
  4. (A) is correct but (R) is incorrect

Solution

Q.54Current ratio of Adaar Ltd. is 2.5:1. Accountant wants to maintain it at 2:1. Following options are available. (i) He can repay Bills Payable (ii) He can purchase goods on credit (iii) He can take short term loan Choose the correct option.

  1. Only (i) is correct
  2. Only (ii) is correct
  3. Only (i) and (iii) are correct
  4. Only (ii) and (iii) are correct

Solution

Q.55A company has an operating cycle of eight months. It has accounts receivables amounting to ₹1,00,000 out of which ₹60,000 have a maturity period of 11 months. How would this information be presented in the balance sheet?

  1. ₹40000 as current assets and ₹60,000 as non-current assets
  2. ₹60,000 as current assets and ₹40,000 as non-current assets
  3. ₹1,00,000 as non-current assets
  4. ₹1,00,000 as Current assets

Solution

PART - III

SECTION- A

Q.56Which key combination collapses the ribbon?

  1. [Ctrl]+[F1]
  2. [Ctrl]+[F3]
  3. [Ctrl]+[F5]
  4. [Ctrl]+[F7]

Solution

Q.57 The CAS should be-

  1. Simple and integrated, transparent, accurate, scalability, reliability.
  2. Complex, Accurate, Transparent, faster to work
  3. Able to transform the manual accounting system to computerised accounting system
  4. None of the above

Solution

Q.58The components of Computerised Accounting System are:

  1. Data, Report, Ledger, Hardware, Software
  2. Data, People, Procedure, Hardware, Software
  3. People, Procedure, Ledger, Data, Chart of Accounts
  4. Data, Coding, Procedure, Rules, Output

Solution

Q.59Where are amounts owed by customers for credit purchases found?

  1. accounts receivable journal
  2. general ledger
  3. sales journal
  4. accounts receivable subsidiary ledger

Solution

Q.60What is the activity sequence of the basic information processing model?

  1. Organise data, process data, and collect data
  2. Collect data, organise and process data, and communicate information
  3. Process data, organise data, and collect data
  4. Organise data, collect data, and communicate information

Solution

Q.61Codification of Accounts required for the purpose of:

  1. Hierarchical relationship between groups and components
  2. Data processing faster and preparing of final accounts
  3. Keeping data and information secured
  4. None of the above.

Solution

Q.62Which mathematical operator is represented by an asterisk (*)?

  1. Exponentiation
  2. Addition
  3. Subtraction
  4. Multiplication

Solution

PART - III

SECTION- B

Q.63What category of functions is used in this formula: =PMT (C10/12, C8, C9,1)

  1. Logical
  2. Financial
  3. Payment
  4. Statistical

Solution

Q.64When Extend Selection is active, what is the keyboard shortcut for selecting all data up to and including the last row?

  1. [Ctrl]+[Down-arrow]
  2. [Ctrl]+[Home]
  3. [Ctrl]+[Shift]
  4. [Ctrl]+ [Up Arrow]

Solution

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

  1. =AND(C4>10, D4>10)
  2. =AND(C4>10, C4<100)
  3. =AND(C4>10, D4<10)
  4. =AND (C4<10, D4,100)

Solution

Q.66Where is the address of the active cell displayed?

  1. Row heading
  2. Status bar
  3. Name Box
  4. Formula bar

Solution

Q.67Which of the following arguments in a financial function represents the total number of payments?

  1. FV
  2. PV
  3. Nper
  4. Rate

Solution

Q.68Which function results can be displayed in Auto Calculate?

  1. SUM and AVERAGE
  2. MAX and LOOK
  3. LABEL and AVERAGE
  4. MIN and BLANK

Solution

Q.69When navigating in a workbook, which command is used to move to the beginning of the current row?

  1. [Ctrl]+[Home]
  2. [Page Up]
  3. [Home]
  4. [Ctrl]+[Backspace]

Solution

Reach Us

SERVICES

  • ACADEMIC
  • ON-LINE PREPARATION
  • FOUNDATION & CRASH COURSES

CONTACT

B-54, Krishna Bhawan, Parag Narain Road, Near Butler Palace Colony Lucknow
Contact:+918081967119