Question:
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
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.
Updated On: Feb 5, 2025
Hide Solution
Verified By Collegedunia
Solution and Explanation
Was this answer helpful?
0
0
Top Questions on Cash Flow Statement
- From the following Balance Sheet of Bose Ltd. as at 31st March, 2024, calculate ‘Cash Flows from Operating Activities’.
- CBSE CLASS XII - 2025
- Accountancy
- Cash Flow Statement
- From the following information, calculate Cash Flows from Financing Activities :
Additional Information :Particulars 31-03-2024 (₹) 31-03-2023 (₹) Equity Share Capital 12,00,000 8,00,000 11% Debentures 3,00,000 4,00,000 Securities Premium 1,40,000 1,00,000
Interest paid on debentures amounted to ₹ 40,000.- CBSE CLASS XII - 2025
- Accountancy
- Cash Flow Statement
- From the following details, calculate Cash Flow from Investing Activities: - Purchase of Machinery Rs 1,50,000
- Sale of Land Rs 80,000
- Purchase of Investments Rs 50,000
- Interest received Rs 8,000
- CBSE CLASS XII - 2025
- CBSE Compartment XII - 2025
- Accountancy
- Cash Flow Statement
- Statement– I : Investing activities are the acquisition and disposal of long-term assets and other investments not included in cash equivalents.
Statement– II : Cash payments to acquire fixed assets including intangibles and capitalised research and development results in cash outflow from investing activities.
Choose the correct option from the following :- CBSE CLASS XII - 2025
- Accountancy
- Cash Flow Statement
- What is Cash Flow Statement? Describe its uses.
- Bihar Board XII - 2025
- Accountancy
- Cash Flow Statement
View More Questions
Questions Asked in CBSE CLASS XII exam
- If \[ f(x) = \begin{cases} \frac{\log(1 + ax) + \log(1 - bx)}{x}, & \text{for } x \neq 0 \\ k, & \text{for } x = 0 \end{cases} \] is continuous at $x = 0$, then the value of $k$ is:
- CBSE CLASS XII - 2025
- Continuity and differentiability
- Verify that lines given by \( \vec{r} = (1 - \lambda) \hat{i + (\lambda - 2) \hat{j} + (3 - 2\lambda) \hat{k} \) and \( \vec{r} = (\mu + 1) \hat{i} + (2\mu - 1) \hat{j} - (2\mu + 1) \hat{k} \) are skew lines. Hence, find shortest distance between the lines.}
- Calculate the value of the current passing through the battery in the given circuit diagram.
- CBSE CLASS XII - 2025
- Current electricity
- Sara and Tara were partners in a firm. Their capitals as on 1st April, 2023 were ₹ 6,00,000 and ₹ 4,00,000 respectively. On 1st October, 2023, Tara withdrew ₹ 1,00,000 for personal use. According to the partnership deed, interest on capital was allowed @ 8% p.a.
The amount of interest allowed on Tara’s capital for the year ended 31st March, 2024 was :- CBSE CLASS XII - 2025
- Partnership Accounts
- Assertion (A): If $| \mathbf{a} \times \mathbf{b} |^2 + | \mathbf{a} \cdot \mathbf{b} |^2 = 256$ and $| \mathbf{b} | = 8$, then $| \mathbf{a} | = 2$.
Reason (R): $\sin^2 \theta + \cos^2 \theta = 1$ and $| \mathbf{a} \times \mathbf{b} | = | \mathbf{a} | | \mathbf{b} | \sin \theta$ and $ \mathbf{a} \cdot \mathbf{b} = | \mathbf{a} | | \mathbf{b} | \cos \theta$.- CBSE CLASS XII - 2025
- Vector Algebra
View More Questions