Explain various ‘Data tables’ used in Pivot Table.
Show Hint
Solution and Explanation
Data tables in Pivot Tables allow dynamic analysis of data by varying input values and observing their impact on outputs. The two main types of data tables are:
1. Single-variable data tables: - Used to evaluate how changes in a single input affect the outcome of a formula. - For example, testing the impact of varying interest rates on loan repayments while keeping other variables constant.
2. Two-variable data tables: - Analyze the combined effect of two different variables on a formula. - For instance, examining the impact of varying both interest rates and loan amounts on monthly installments.
Key Features of Data Tables: - Automatically update results when input values or the linked formula changes. - Provide a structured format to visualize multiple scenarios. - Simplify sensitivity analysis for decision-making processes.
Advantages of Data Tables: - Useful in "What-If" analysis to model different scenarios efficiently. - Help users make informed decisions by comparing outcomes under varying assumptions. - Time-saving for repetitive calculations, as they eliminate the need to create multiple individual formulas.
Top CBSE CLASS XII Accountancy Questions
From the following Balance Sheet of Hira Ltd. as at 31st March, 2023, prepare Comparative Balance Sheet:
- On 1st May, 2023, Amrit Ltd. issued 10,000, 10% debentures of ₹100 each at a premium of 10%, redeemable at a premium of 10%. Loss on issue of debentures will be:
- Gupta and Sharma are partners in a firm sharing profit in the ratio of 4:1. They admitted Preeti as a new partner for \( \frac{1}{4} \) share in the profits, which she acquired wholly from Gupta. The new profit sharing ratio of Gupta, Sharma, and Preeti will be:
- On the dissolution of a partnership firm, there were debtors of ₹34,000. Debtors of ₹1,000 became bad, and 60% was realized from the remaining debtors. Which account will be debited and by how much amount on the realization from debtors?
- If vendors are issued fully paid shares of ₹1,25,000 in purchase consideration of net assets of ₹1,50,000, the balance of ₹25,000 will be credited to:
Top CBSE CLASS XII Partnership Questions
Pooja and Kumari were partners in a firm sharing profits and losses in the ratio of 2 : 1. On 1st April, 2023, Noori was admitted for a new partner \( \frac{1}{4} \) share in the profits of the firm. Noori was guaranteed a minimum profit of 1,20,000. Any deficiency on this account was to be borne by Pooja and Kumari in their profit sharing ratio. During the year ended 31st March, 2024, the firm earned a net profit of 3,60,000. The amount of deficiency borne by Pooja will be:
- There are two statements Assertion (A) and Reason (R):
Assertion (A): Private assets of a partner can also be used for paying off the firm’s debts.
Reason (R): Liability of a partner for acts of the firm is limited.
Choose the correct alternative from the following: - Nandan and Abhinandan were partners in a firm. They admitted Govindan as a new partner for \( \frac{1}{3}^{\text{rd}} \) share in the profits. On Govindan’s admission, the Balance Sheet of the firm showed sundry debtors at 3,00,000 and a provision for bad debts at 24,000. It was decided to maintain the provision for bad debts at 10% of the debtors. Which of the following journal entries will show the correct accounting treatment for the above transactions?
Saloni and Mohini were partners in a firm sharing profits and losses in the ratio of 3 : 2. On 31st March, 2024, Saloni’s capital was 1,50,000. During the year, she withdrew 10,000 and introduced additional capital of 32,000. For the year ended 31st March, 2024, the firm earned a profit of 50,000. Saloni’s capital as on 1st April, 2023, was:
Hari, Chander, Prakash and Govind were partners in a firm sharing profits and losses in the ratio of 5 : 3 : 1 : 1. On 1st April, 2024, Hari retired and his share was acquired equally by Chander, Prakash and Govind. The new profit sharing ratio of Chander, Prakash and Govind will be:
Top CBSE CLASS XII Questions
- 2, b, c are in A.P. and the range of determinant $\begin{vmatrix}1&1&1\\ 2&b&c\\ 4&b^{2}&c^{2}\end{vmatrix}$ is [2, 16]. Then find range of c is
- A boy of mass 50 kg is standing at one end of a, boat of length 9 m and mass 400 kg. He runs to the other, end. The distance through which the centre of mass of the boat boy system moves is
- A capillary tube of radius r is dipped inside a large vessel of water. The mass of water raised above water level is M. If the radius of capillary is doubled, the mass of water inside capillary will be
- A circular disc is rotating about its own axis. An external opposing torque 0.02 Nm is applied on the disc by which it comes rest in 5 seconds. The initial angular momentum of disc is
- A circular disc is rotating about its own axis at uniform angular velocity \(\omega.\) The disc is subjected to uniform angular retardation by which its angular velocity is decreased to \(\frac {\omega}{2}\) during 120 rotations. The number of rotations further made by it before coming to rest is