1. Using An If statement in excel, show results if students has distinction (score>80%), pass (score>65%), below average(score>50%), fail (score> 20%) and no score or anything below 20%. The test total score is 50. E.g Hias scored 43 out of 50. Note: this requires use of an embedded if statement within your function If statement. The results of the students are here below. Student Score Percentile % Grade Hias Wiktor 43 Slim Keikanne 49 Keakantse 36 Seleka Seiso 31

Maitseo Botho 23