A B C D E F G H I J K L M

$1$ SALES

$2$ SN NAME FEB MARCH PN NAME TOWN

$31245$ RUTH $360024001257$ NAOMI NYERI

$41250$ TOM $430015001258$ JUDE KITUI

$51259$ JUDE $250023001242$ MARY NAKURU

$61252$ LIZ $520043001248$ JOHN KISUMU

$71255$ SUSAN $650060001255$ SUSAN VOI

$81242$ MARY $540034001248$ ESTHER KITALE

$91256$ MARK $440041001241$ JOB WOTE

$101257$ NAOMI $800055001251$ ANN EMBU

$111240$ MAGDA $560033001255$ PETER KILIFI

$121258$ ESTHER $720042001256$ MARK EMBU

$13$

Above are entries in an excel worksheet. Numbers in the first column $(123...)$ are row numbers and the labels on top $($A B C $...)$ are column labels of the worksheet.

$($a$)$ Give VLOOKUP functions to be entered in cells F$3,$ G$3$ and H$3$ to give SN$,$ NAME and TOWN. The functions will be copied to the entire range for all the individuals. We can also use this for checking the accuracy of our records. As you see there are some errors in the above case. What are they?

$($b$)$ Give the functions to be entered in E$3$ for determining means sales for FEB and MARCH for sales in cells C$3$ and D$3.$

$($c$)$ Give the function to be entered in E$13$ for determining means sales for FEB.

$($d$)$ Give the functions to be entered in A$13$ for determining minimum sales for the months of FEB and MARCH considered together.

$($e$)$ Give the function to be entered in J$3$ for determining sales performance for RUTH. Performance is based on mean sales $($where EXCELLENT $>10000$; GOOD $7000-10000$; AVERAGE $<7000$ but $>=5000$; POOR$<5000).$