CBSE 2024 · Region 5 · Set 1 · Q34

iCalibfi $\displaystyle 11$ 'A A' I ® ' Wrap Text % Copy v Paste I Ll v _; E Merge 8z Center v 'X Format Painter Clipboard Font B19 v 1v a»r'-r--<» A B C D E F $\displaystyle 1$ Subjects s. No $\displaystyle 2$ Name Maths English Science Tata I $\displaystyle 3$ $\displaystyle 1$ Vipul $\displaystyle 38$ $\displaystyle 58$ $\displaystyle 66$ $\displaystyle 162$ $\displaystyle 4$ $\displaystyle 2$ Ram $\displaystyle 88$ $\displaystyle 92$ $\displaystyle 74$ $\displaystyle 254$ $\displaystyle 5$ -. $\displaystyle 3$ Kiara $\displaystyle 57$ $\displaystyle 77$ $\displaystyle 91$ $\displaystyle 225$ $\displaystyle 5$ $\displaystyle 4$ Kian $\displaystyle 82$ $\displaystyle 56$ $\displaystyle 45$ $\displaystyle 183$ $\displaystyle 7$ $\displaystyle 5$ Kabir $\displaystyle 55$ $\displaystyle 55$ $\displaystyle 65$ $\displaystyle 175$ $\displaystyle 8$ $\displaystyle 6$ Yuvaan $\displaystyle 75$ $\displaystyle 51$ $\displaystyle 57$ $\displaystyle 183$ $\displaystyle 9$ $\displaystyle 7$ Vishnu $\displaystyle 89$ $\displaystyle 78$ $\displaystyle 66$ $\displaystyle 233$ $\displaystyle 10$ $\displaystyle 8$ Neha $\displaystyle 70$ $\displaystyle 58$ $\displaystyle 84$ $\displaystyle 212$ . $\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$