CBSE 2024 · Region 4 · Set 3 · Q34

Home Calibri 'e Wrap Text $\displaystyle 425$ Copy Paste I u~ . Y v Merge $\displaystyle 81$ Center v v $\displaystyle 4$ liormat Painter Clipboard Vi Font Alignment $\displaystyle 5$; $\displaystyle 813$ $\displaystyle 0$ /'x ¢ fx . , z. . ..... w . . .... C o E F J ~» . G . H :Igor w X-.. $\displaystyle 1$ S. No Product Q1 sales Q2 Sales Total half yearly sales $\displaystyle 2$ $\displaystyle 1$ A $\displaystyle 10000$ $\displaystyle 15000$ $\displaystyle 25000$ $\displaystyle 3$ $\displaystyle 2$ B $\displaystyle 40000$ $\displaystyle 35000$ $\displaystyle 75000$ $\displaystyle 4$ $\displaystyle 3$ C $\displaystyle 25000$ $\displaystyle 40000$ $\displaystyle 65000$ $\displaystyle 5$ $\displaystyle 4$ D $\displaystyle 30000$ $\displaystyle 50000$ $\displaystyle 80000$ $\displaystyle 6$ $\displaystyle 5$ E $\displaystyle 34000$ $\displaystyle 45000$ $\displaystyle 79000$ $\displaystyle 7$ $\displaystyle 6$ F $\displaystyle 12000$ $\displaystyle 30000$ $\displaystyle 42000$ $\displaystyle 8$ $\displaystyle 7$ G $\displaystyle 38000$ $\displaystyle 56000$ $\displaystyle 94000$ Using the worksheet find out the error and its reason for the given 'VLOOKUP' syntax. (i) = VLOOKUP (B1, B2 : E8, $\displaystyle 2$, $\displaystyle 0$) (ii) = SQRT (VLOOKUP (B5, B8 : E8, $\displaystyle 2$, $\displaystyle 0$) - $\displaystyle 100000$) (iii) = VLOOKUP (A2, A2 : A8, $\displaystyle 2$, $\displaystyle 0$) (iv) = VLOOKUP (B2, B3, E4, $\displaystyle 5$, $\displaystyle 0$) (V) = VLOOKUP (B2, A2 : E8, $\displaystyle 0$, $\displaystyle 0$) (vi) = VLOOKUP (B2, B2, E8, $\displaystyle 2$, $\displaystyle 0$)/$\displaystyle 0$