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$	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 6$	$\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$

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$