More formulae and functions - Exercises

Task 4: Statistical IFs. Open the . Ifs and or not.xls. workbook. On the . Statistical. worksheet, name the range E2:E18 “ Total ”. In cell . F2, use the MAX function within an IF statement to find the prize winner (the student with the highest total score). Indicate this by placing the word . Prize. in the relevant cell. ................
................