From the given 'VLOOKUP' syntax find out the error and its reason using the worksheet. (i) = VLOOKUP (B5, C3: F10, 2, 0) (ii) = SQRT (VLOOKUP (B3,…

	A	B	C	D	E	F
$\displaystyle 1$	S. No	Subjects
$\displaystyle 2$		Name	Maths	English	Science	Total
$\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$	Margaret	$\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$

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$