CBSE 2024 · Region 5 · Set 3 · Q34

@- $\displaystyle 5$ .11-... Calibri 'g $\displaystyle 11$ v A` A' v it' Wrap Text . .. . . .. . . " %€0py v Paste I U v v v A v E Merge $\displaystyle 8$£ Center v v Format Painter Clipboard Font Alignment ,joe H21 v \-°-v"-v "X W/ A $\displaystyle 8$ C D E F -n $\displaystyle 1$ Subjects S. No $\displaystyle 2$ Name Maths English Science Tata I $\displaystyle 3$ $\displaystyle 1$ Tarandeep $\displaystyle 99$ $\displaystyle 52$ $\displaystyle 66$ $\displaystyle 217$ $\displaystyle 4$ $\displaystyle 2$ William $\displaystyle 33$ $\displaystyle 87$ $\displaystyle 65$ $\displaystyle 185$ $\displaystyle 5$ $\displaystyle 3$ Ma rga ret $\displaystyle 37$ $\displaystyle 62$ $\displaystyle 88$ $\displaystyle 187$ $\displaystyle 6$ $\displaystyle 4$ Ram $\displaystyle 89$ $\displaystyle 46$ $\displaystyle 56$ $\displaystyle 191$ $\displaystyle 7$ $\displaystyle 5$ Lewis $\displaystyle 67$ $\displaystyle 53$ $\displaystyle 65$ $\displaystyle 185$ $\displaystyle 8$ $\displaystyle 6$ Afreen $\displaystyle 88$ $\displaystyle 49$ $\displaystyle 49$ $\displaystyle 186$ $\displaystyle 9$ $\displaystyle 7$ Mehrunisha $\displaystyle 66$ $\displaystyle 77$ $\displaystyle 59$ $\displaystyle 202$ $\displaystyle 10$ $\displaystyle 8$ Abid $\displaystyle 100$ $\displaystyle 51$ $\displaystyle 79$ $\displaystyle 230$ .TJ . From the given 'VLOOKUP' syntax find out the error and its reason using the worksheet. (i) = VLOOKUP (B5, C3 : F10, $\displaystyle 2$, $\displaystyle 0$) (ii) SQRT (VLOOKUP (B3, B3 : F10, $\displaystyle 2$, $\displaystyle 0$) $\displaystyle 100$) (iii) VLOOKUP (B2, B3 : F10, $\displaystyle 5$, $\displaystyle 0$) (iv) VLOOKUP (B3, B3 : B10, $\displaystyle 2$, $\displaystyle 0$) (V) VLOOKUP (B6, B3 : F10, $\displaystyle 0$, $\displaystyle 0$) (Vi) VLOOKUP (B6, B3 : F10, $\displaystyle 2$, $\displaystyle 0$)/$\displaystyle 0$