CBSE 2024 · Region 4 · Set 2 · Q34

_ QQ Cut .11 v Wrap Text iCaliba'i I . Copy v Paste I u~ v -v A * Merge $\displaystyle 81$ Center v v $\displaystyle 1$) format Painter E Clipboard re Font I Alignment re DO v v x =~;:5. $\displaystyle 1$ r \ aigip . e a C D . G $\displaystyle 1$ _ S. No Product Q1 sales Q2 Sales half vearl / sales $\displaystyle 2$ .. $\displaystyle 1$ N $\displaystyle 21000$ $\displaystyle 30000$ $\displaystyle 51000$ $\displaystyle 3$ . $\displaystyle 2$ P $\displaystyle 31000$ $\displaystyle 40000$ $\displaystyle 71000$ $\displaystyle 4$ $\displaystyle 3$ Q $\displaystyle 4500$ $\displaystyle 28000$ $\displaystyle 32500$ $\displaystyle 5$ $\displaystyle 4$ R $\displaystyle 6700$ $\displaystyle 49000$ $\displaystyle 55700$ $\displaystyle 6$ $\displaystyle 5$ S $\displaystyle 55600$ $\displaystyle 36000$ $\displaystyle 91600$ $\displaystyle 7$ $\displaystyle 6$ T $\displaystyle 32000$ $\displaystyle 32000$ $\displaystyle 64000$ $\displaystyle 8$ $\displaystyle 7$ U $\displaystyle 11000$ $\displaystyle 40000$ $\displaystyle 51000$ 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$