CBSE 2024 · Region 3 · Set 1 · Q34

xi E $\displaystyle 5$' <->~ = 34. HOME INSERT PAGE LAVOUT FORMUIAS DATA REVIEW VIEW X Tell me what yo "E $\displaystyle 3$£,cur Calibri Y $\displaystyle 11$ A A' E E l I W ' Wrap Tat EQCOPY ' Paste $\displaystyle 8$ I _ u v | , & ' A' g g E | $\displaystyle 4$; EI E Merge & Center ' \' Format Painter Clipboard Font re Alignment G. -- B11 A 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$ Apple $\displaystyle 50$ $\displaystyle 60$ $\displaystyle 3$ $\displaystyle 2$ Orange $\displaystyle 20$ $\displaystyle 40$ $\displaystyle 4$ $\displaystyle 3$ Banana $\displaystyle 60$ $\displaystyle 80$ $\displaystyle 5$ $\displaystyle 4$ Lemon $\displaystyle 40$ $\displaystyle 80$ $\displaystyle 6$ $\displaystyle 5$ Milk $\displaystyle 53$ $\displaystyle 60$ $\displaystyle 7$ $\displaystyle 6$ Bread $\displaystyle 40$ $\displaystyle 45$ $\displaystyle 8$ $\displaystyle 7$ Egg $\displaystyle 58$ $\displaystyle 60$ $\displaystyle 9$ Using the worksheet, find out the error and its reason for the given 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$