CBSE 2024 · Region 5 · Set 2 · Q34

.a. H; m Calibri mr 'H v A` A' I * §» Wrap Text . .. . . .. . . P " ~~ %€0py ' aste I U v v E Merge $\displaystyle 8$£ Center v v ~§ Format Painter Clipboard Font Alignment ,( nz i .r $\displaystyle 2$ "I .t -ahahIna $\displaystyle 819$ v-°-v" . 'J ` \ -nn- A $\displaystyle 8$ C D E F $\displaystyle 1$ Subjects S. No $\displaystyle 2$ Name Maths English Science Tata I $\displaystyle 3$ $\displaystyle 1$ Ramandeep $\displaystyle 57$ $\displaystyle 50$ $\displaystyle 66$ $\displaystyle 173$ $\displaystyle 4$ $\displaystyle 2$ Sahil $\displaystyle 88$ $\displaystyle 85$ $\displaystyle 65$ $\displaystyle 238$ $\displaystyle 5$ $\displaystyle 3$ Tarannum $\displaystyle 38$ $\displaystyle 64$ $\displaystyle 88$ $\displaystyle 190$ $\displaystyle 6$ $\displaystyle 4$ Josheph $\displaystyle 55$ $\displaystyle 48$ $\displaystyle 56$ $\displaystyle 159$ $\displaystyle 7$ $\displaystyle 5$ Joanna $\displaystyle 82$ $\displaystyle 55$ $\displaystyle 65$ $\displaystyle 202$ $\displaystyle 8$ $\displaystyle 6$ Vikram $\displaystyle 75$ $\displaystyle 51$ $\displaystyle 49$ $\displaystyle 175$ $\displaystyle 9$ $\displaystyle 7$ Iqbal $\displaystyle 60$ $\displaystyle 75$ $\displaystyle 59$ $\displaystyle 194$ $\displaystyle 10$ $\displaystyle 8$ Heena $\displaystyle 70$ $\displaystyle 45$ $\displaystyle 79$ $\displaystyle 194$ . $\displaystyle 1.1$ 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$