From the given ‘VLOOKUP’ syntax, find out the error and its reason using the worksheet:
(i) = VLOOKUP(B5, C3:F10, 2, 0)
(ii) = SQRT(VLOOKUP(B3, B3:F10, 2, 0) - 100)
(iii) = VLOOKUP(B2, B3:F10, 5, 0)
(iv) = VLOOKUP(B3, B3:B10, 2, 0)
(v) = VLOOKUP(B6, B3:F10, 0, 0)
(vi) = VLOOKUP(B6, B3:F10, 2, 0)/0
(i) = VLOOKUP(B5, C3:F10, 2, 0)
(ii) = SQRT(VLOOKUP(B3, B3:F10, 2, 0) - 100)
(iii) = VLOOKUP(B2, B3:F10, 5, 0)
(iv) = VLOOKUP(B3, B3:B10, 2, 0)
(v) = VLOOKUP(B6, B3:F10, 0, 0)
(vi) = VLOOKUP(B6, B3:F10, 2, 0)/0
Show Hint
Ensure the lookup value is in the first column of the table array. Use a valid column index that corresponds to the structure of the table array. Avoid dividing by zero or referencing incorrect ranges in formulas.
Solution and Explanation
Top Questions on Cash Flow Statement
- The following information has been extracted from the books of Ram Lal Ltd.:
Comparative Financial Data as on 31st March, 2024 and 2023
Additional Information: Interim dividend paid during the year was \textrupee{ 1,20,000}.Particulars 31.03.2024 (₹) 31.03.2023 (₹) Surplus (P&L) 17,00,000 8,00,000 Patents -- 50,000 Sundry Debtors 5,80,000 4,20,000 Sundry Creditors 1,40,000 60,000 Cash and Cash Equivalents 2,00,000 90,000 - CBSE CLASS XII - 2025
- Accountancy
- Cash Flow Statement
\(\textit{Statement I:}\) In case of non-financial enterprises, payment of interest and dividends are classified as financing activities, whereas receipt of interest and dividends are classified as investing activities.
\(\textit{Statement II:}\) Investing and financing transactions that require the use of cash or cash equivalents, should be excluded from cash flow statement.
Choose the correct alternative from the following:- CBSE CLASS XII - 2025
- Accountancy
- Cash Flow Statement
- Which of the following transactions will not result in the inflow of cash ?
- CBSE CLASS XII - 2025
- Accountancy
- Cash Flow Statement
- Calculate 'Cash Flows from Investing Activities' from the given information:
Comparative Statement of Assets
Particulars 31.03.2024 (₹) 31.03.2023 (₹) 10% Long Term Investments 2,50,000 4,50,000 Plant and Machinery 8,00,000 6,00,000 Goodwill 1,40,000 1,00,000 Investment in shares of Pinnacle Ltd. 14,00,000 5,00,000 Patents - 1,50,000 - CBSE CLASS XII - 2025
- Accountancy
- Cash Flow Statement
- Statement I: Snow Ltd. made a net profit of ₹ 5,00,000 after taking into consideration interest on investment of ₹ 1,00,000. Operating profit before working capital changes would be ₹ 4,00,000.
Statement II: To calculate operating profit, before working capital changes, interest on investment is subtracted from net profit because it is a non-operating income.
Choose the correct option:- CBSE CLASS XII - 2025
- Accountancy
- Cash Flow Statement
Questions Asked in CBSE CLASS XII exam
Rupal, Shanu and Trisha were partners in a firm sharing profits and losses in the ratio of 4:3:1. Their Balance Sheet as at 31st March, 2024 was as follows:
(i) Trisha's share of profit was entirely taken by Shanu.
(ii) Fixed assets were found to be undervalued by Rs 2,40,000.
(iii) Stock was revalued at Rs 2,00,000.
(iv) Goodwill of the firm was valued at Rs 8,00,000 on Trisha's retirement.
(v) The total capital of the new firm was fixed at Rs 16,00,000 which was adjusted according to the new profit sharing ratio of the partners. For this necessary cash was paid off or brought in by the partners as the case may be.
Prepare Revaluation Account and Partners' Capital Accounts.- CBSE CLASS XII - 2025
- Partnership Accounts
- Explain giving three reasons why tropics show greatest levels of species diversity.
- CBSE CLASS XII - 2025
- Biodiversity
- The element of dilemma, between humanity and patriotism, elevates the character of Dr. Sadao in ‘The Enemy’. Support your answer with evidence from the text.
- CBSE CLASS XII - 2025
- Literature
- Find: \[ \frac{dy}{dx}, \quad \text{if} \quad y = x \tan x + \frac{\sqrt{x^2 + 1}}{2} \]
- CBSE CLASS XII - 2025
- Differentiation
- Solve for \( x \), \[ 2 \tan^{-1} x + \sin^{-1} \left( \frac{2x}{1 + x^2} \right) = 4\sqrt{3} \]
- CBSE CLASS XII - 2025
- Trigonometric Functions