CBSE 2024 · Region 3 · Set 2 · Q34

xi E <>~ C" = 34. HOME INSERT PAGE LAYOUT FORMUIAS DATA REVIEW "EW X Tell me what yo " Q QQ cm Ciiii U $\displaystyle 11$ v K A' EE lvf- §WflPT¢¢ l Ea Copy ' Paste | $\displaystyle 1$ u-IE~ ¢..A. §§==IE§ Emegeacenmu v $\displaystyle 1$\ Format Painter Clipboard E Font E Alignment G B11 v I I X J fol A I A B C D E F S. No. Consumables Price in FY Price in FY $\displaystyle 1$ $\displaystyle 21$ $\displaystyle 22$ $\displaystyle 23$ $\displaystyle 24$ $\displaystyle 2$ $\displaystyle 1$ Pineapple $\displaystyle 40$ $\displaystyle 55$ $\displaystyle 3$ $\displaystyle 2$ Kiwi $\displaystyle 34$ $\displaystyle 45$ $\displaystyle 4$ $\displaystyle 3$ Jackfruit $\displaystyle 50$ $\displaystyle 62$ $\displaystyle 5$ $\displaystyle 4$ Blueberry $\displaystyle 35$ $\displaystyle 54$ $\displaystyle 6$ $\displaystyle 5$ Butter $\displaystyle 50$ $\displaystyle 56$ $\displaystyle 7$ $\displaystyle 6$ Buns $\displaystyle 48$ $\displaystyle 45$ $\displaystyle 8$ $\displaystyle 7$ Meat $\displaystyle 36$ $\displaystyle 48$ $\displaystyle 9$ Using the worksheet, find out the error and its reason for the given 'VLOOKUP' syntax. (i) = VLOOKUP (B1, B4 : D6, $\displaystyle 2$, $\displaystyle 0$) (ii) = SQRT (VLOOKUP (C2, C2 : D8, $\displaystyle 2$, $\displaystyle 0$) $\displaystyle 100$) (iii) = VLOOKUP (B5, B6 : D8, $\displaystyle 1$, $\displaystyle 0$) (iv) = VLOOKUP (B3, B2 : D8, $\displaystyle 5$, $\displaystyle 0$) (v) = VLOOKUP (B5, B3 : D8, $\displaystyle 0$, $\displaystyle 0$) (vi) = VLOOKUP (B2, B2 : D7, $\displaystyle 2$, $\displaystyle 0$) / $\displaystyle 0$