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

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$