The following is an extract from a spreadsheet program used to determine the mean and remark of scores obtained in CAT1 and CAT2 tests. Use it to answer the question that follows
A remark of “pass” is assigned to a student who obtains an average of 17 and above and “fail” if otherwise. State the formulae that would be used to determine;
a)The mean for Ann;
b)Remark for Ann.