Questions

M.C.Q (1 Marks)

🎯

Test yourself on this topic

12 questions · timed · auto-graded

MCQ 11 Mark
What category of functions is used in this formula: =PMT (C10/12, C8, C9,1)
  • A
    Logical
  • Financial
  • C
    Payment
  • D
    Statistical
Answer
Correct option: B.
Financial
B
View full question & answer
MCQ 21 Mark
When navigating in a workbook, which command is used to move to the beginning of the current row?
  • [Ctrl]+[Home]
  • B
    [Page Up]
  • C
    [Home]
  • D
    [Ctrl]+[Backspace]
Answer
Correct option: A.
[Ctrl]+[Home]
A
View full question & answer
MCQ 31 Mark
Which function results can be displayed in Auto Calculate?
  • SUM and AVERAGE
  • B
    MAX and LOOK
  • C
    LABEL and AVERAGE
  • D
    MIN and BLANK
Answer
Correct option: A.
SUM and AVERAGE
A
View full question & answer
MCQ 41 Mark
Which formulae would result in TRUE if C4 is less than 10 and D4 is less than 100?
  • =AND(C4>10, D4>10)
  • B
    =AND(C4>10, C4<100).
  • C
    =AND(C4>10, D4<10).
  • D
    =AND (C4<10, D4,100)
Answer
Correct option: A.
=AND(C4>10, D4>10)
A
View full question & answer
MCQ 51 Mark
In Excel, the chart tools provide three different options _________, _________ and _________ for formatting.
  • A
    Layout, Format, DataMaker
  • Design, Layout, Format
  • C
    Format, Layout, Label
  • D
    Design, DataMaker, Layout
Answer
Correct option: B.
Design, Layout, Format
B
View full question & answer
MCQ 61 Mark
The syntax of PMT Function is _________
  • A
    PMT (rate, pv, nper, [fv], [type])
  • PMT (rate, nper, pv, [fv], [type])
  • C
    PMT (rate, pv, nper, [type], [fv])
  • D
    PMT (rate, nper, pv, [type], [fv])
Answer
Correct option: B.
PMT (rate, nper, pv, [fv], [type])
B
View full question & answer
MCQ 71 Mark
Statement-I: 'Shree Ltd.' was carrying on a business of packaging in Delhi and earned good profits in the past years. The company wanted to expand its business and required additional funds. To meet its requirements the company issued equity shares of ₹ 30,00,000. It purchased a computerized machine of ₹ 20,00,000. During the current year the Net Profit of the company was ₹ 15,00,000. Cash flows from operating, investing and financing activities from the above transactions will be ₹ 15,00,000: (₹ 20,00,000); ₹  30,00,000 respectively.
Statement-II: The patents of X Ltd. increased from ₹ 3,00,000 in 2021-22 to ₹ 3,50,000 in 2022-23. It will be taken as purchase of Patents of 50,000 and will be shown under Cash outflow from Investing Activities.
  • Both the statements are true.
  • B
    Both the statements are false.
  • C
    Only Statement-l is true.
  • D
    Only Statement-ll is true.
Answer
Correct option: A.
Both the statements are true.
A
View full question & answer
MCQ 81 Mark
Which of the following statements is incorrect?
  • Investments in shares are excluded from cash equivalents unless they are in substantial cash equivalents.
  • B
    Short-term marketable securities which can be readily converted into cash are treated as cash equivalents
  • C
    In case of a financial enterprise, interest received and dividend received are classified as operating activities while dividend paid and interest paid are financing activities.
  • D
    Dividend tax, i.e., tax paid on dividend should be classified as financing activity along with dividend paid.
Answer
Correct option: A.
Investments in shares are excluded from cash equivalents unless they are in substantial cash equivalents.
A
View full question & answer
MCQ 91 Mark
While computing cash from operating activities, which of the following item(s) will be added to the net profit?
(i) Decrease in value of inventory
(j) Increase in share capital
(k) Increase in the value of trade receivables
(l) Increase in the amount of outstanding expenses
  • A
    Only (i)
  • B
    Only (i) and (ii)
  • C
    Only (i) and (iii)
  • Only (i) and (iv)
Answer
Correct option: D.
Only (i) and (iv)
D
View full question & answer
MCQ 101 Mark
As on 31.02.2024 the following information of Bartan Manfacturing Itd. is available.
Net profit ratio40%
Operating profit ratio50%
On 1st April 2024 it was came to notice that the accountant had omitted recording the interest received on investment of Rs. 2,00,000 for the financial year 2023-24. The required rectification was done. What will be the effect of the same on Net Profit and operating profit ratio?
  • A
    Net Profit ratio will increase and Operating Profit ratio will decrease
  • B
    Both Net Profit ratio and Operating Profit ratio will increase
  • Net Profit ratio will increase and Operating Profit ratio will have no change
  • D
    Net Profit ratio will remain same and Operating Profit ratio will increase
Answer
Correct option: C.
Net Profit ratio will increase and Operating Profit ratio will have no change
C
View full question & answer
MCQ 111 Mark
…………..will result in increase in Liquid Ratio without affecting the Current Ratio.
  • Sale of Stock at cost price
  • B
    Sale of stock at loss
  • C
    Sale of stock at profit
  • D
    Sale of investments at cost
Answer
Correct option: A.
Sale of Stock at cost price
A
View full question & answer
MCQ 121 Mark
When an analyst analysis the financial statements of an enterprise over a number of years, the analysis is called _________ analysis.
  • A
    Static
  • B
    External
  • Horizontal
  • D
    Vertical
Answer
Correct option: C.
Horizontal
C
View full question & answer
M.C.Q (1 Marks) - Accountancy STD 12 Commerce Questions - Vidyadip