CBSE 2024 · Region 3 · Set 3 · Q34

xi E *> <-> = 34. HOME INSERT PAGE LAVOUT FORMUIAS DATA REVIEW VIEW X Tell me what yo M QQ cm Calibii $\displaystyle 11$ A A' - ; l I V/' §WrapTat Ela Copy ' Paste o B I Q ' I $\displaystyle 0$' A' I i-.§= EMerge8LCenter ' v \ Format Painter Clipboard Font re Alignment G. -- B11 I J'><' v ft | A A II 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$ Muskmelon $\displaystyle 45$ $\displaystyle 122$ $\displaystyle 3$ $\displaystyle 2$ Watermelon $\displaystyle 9$ $\displaystyle 21$ $\displaystyle 4$ $\displaystyle 3$ Squash $\displaystyle 22$ $\displaystyle 35$ $\displaystyle 5$ $\displaystyle 4$ Gourd $\displaystyle 47$ $\displaystyle 88$ $\displaystyle 6$ $\displaystyle 5$ Curd $\displaystyle 49$ $\displaystyle 66$ $\displaystyle 7$ $\displaystyle 6$ Brisket $\displaystyle 33$ $\displaystyle 43$ $\displaystyle 8$ $\displaystyle 7$ Poultry $\displaystyle 88$ $\displaystyle 96$ $\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$