Q. 5054536. Rani, Sandhya and Kangana are partners sharing profits in the ratio of 4:3:2 Rani retires. Sandhya and Kangana decided to share profits in future in the ratio of 5:3. Gaining ratio of Sandhya and Kangana will be
(A) 11:21
(B) 21:11
(C) 31:12
(D) 23:13
Answer: (B) 21:11
Explanation: Old Ratio = 4:3:2 (Sandhya = 3/9, Kangana = 2/9). New Ratio = 5:3 (Sandhya = 5/8, Kangana = 3/8).
Gain = New Share – Old Share.
Sandhya’s Gain = 5/8 – 3/9 = (45 – 24)/72 = 21/72.
Kangana’s Gain = 3/8 – 2/9 = (27 – 16)/72 = 11/72.
The gaining ratio is 21:11.
Q. 5054537. What are the internal controls designed to do?
(A) Only ensure accurate accounting records
(B) Safeguard assets and optimize use of resource
(C) Only safeguard assets
(D) Only achieve maximum revenue
Answer: (B) Safeguard assets and optimize use of resource
Explanation: Internal controls are comprehensive mechanisms and procedures implemented by an organization to safeguard its assets, ensure the integrity of its financial data, and optimize the efficient use of its operational resources.
Q. 5054538. How many blank worksheets are shown when a new workbook is created.
(A) Four
(B) Three
(C) Two
(D) One
Answer: (B) Three
Explanation: By default in older standard versions of MS Excel (such as Excel 2007 and 2010), a newly created workbook opens with three blank worksheets (Sheet1, Sheet2, and Sheet3).
Q. 5054539. Which of the following arguments in a financial function represents the total number of payments
(A) FV
(B) PV
(C) NPer
(D) Rate
Answer: (C) NPer
Explanation: In Excel financial functions, “NPer” stands for the Number of Periods, which represents the total number of payment periods in an annuity or loan.
Q. 5054540. The term ‘field’ as applied to database table means.
(A) Name of the table
(B) Horizontal row of the table
(C) Size of the table
(D) Vertical column of the table
Answer: (D) Vertical column of the table
Explanation: In database management systems, a table is made up of rows and columns. A “record” corresponds to a horizontal row, while a “field” corresponds to a vertical column holding a specific category of data.