CBSE 2024 · Region 4 · Set 1 · Q34

. . . . . . . $\displaystyle 31$, Cut Calibri Tb $\displaystyle 1$ v A' A' ®' ' §"'Wrap Text Paste Copy ' I c>- A' cl-nslll |-» ¢-n .nu q-» B U., v 1.ua-n-n rin au- Q- Merge $\displaystyle 81$ Center v $\displaystyle 1$ $\displaystyle 4$' Format Painter ..... Clipboard . . Font Ra Alignment # I "or »-uucp-... C11 , ~»/ f, E n i A B E F i H $\displaystyle 1$ S. No. Product Q2 Sales Total half yearly sales $\displaystyle 2$ $\displaystyle 1$ H $\displaystyle 15000$ $\displaystyle 30000$ $\displaystyle 45000$ $\displaystyle 3$ $\displaystyle 2$ I $\displaystyle 38000$ $\displaystyle 40000$ $\displaystyle 78000$ $\displaystyle 4$ $\displaystyle 3$ J $\displaystyle 23000$ $\displaystyle 28000$ $\displaystyle 51000$ $\displaystyle 5$ $\displaystyle 4$ K $\displaystyle 32000$ $\displaystyle 49000$ $\displaystyle 81000$ $\displaystyle 6$ $\displaystyle 5$ L $\displaystyle 26000$ $\displaystyle 36000$ $\displaystyle 62000$ $\displaystyle 7$ $\displaystyle 6$ M $\displaystyle 20000$ $\displaystyle 32000$ $\displaystyle 52000$ $\displaystyle 8$ $\displaystyle 7$ O $\displaystyle 24000$ $\displaystyle 40000$ $\displaystyle 64000$ Using the worksheet find out the error and its reason for the given 'VLOOKUP' syntax. (i) = VLOOKUP (B1, B2 : E8, $\displaystyle 2$, $\displaystyle 0$) (ii) = SQRT (VLOOKUP (B5, B8 : E8, $\displaystyle 2$, $\displaystyle 0$) - $\displaystyle 100000$) (iii) = VLOOKUP (A2, A2 : A8, $\displaystyle 2$, $\displaystyle 0$) (iv) = VLOOKUP (B2, B3, E4, $\displaystyle 5$, $\displaystyle 0$) (V) = VLOOKUP (B2, A2 : E8, $\displaystyle 0$, $\displaystyle 0$) (vi) = VLOOKUP (B2, B2, E8, $\displaystyle 2$, $\displaystyle 0$)/$\displaystyle 0$