Your homeroom teacher has found out you are a whiz at creating Spreadsheets and she has asked you to make one for her. She would like a Spreadsheet that automatically awards a Grade for each subject based on the examination result. She would also like it to work out each students' GPA (Grade Point Average).
In order to do this you need to create a layout similar to the one shown below. You must:
> Use the IF function to work out what each exam result is as a Grade. To do this you must award grades as follows
>80 = A, >60 = B, > 40 = C, >20 = D, <21 = E
> Use Cell Formatting to get the Subject Titles on an angle (see resources below).
> Calulate each students GPA using a Formula based on the number of subjects being studied.
> Have at least 4 subjects and 5 students to demonstrate that it works.
> Have a GUI (Graphic User Interface) that is as attractive as possible (use Formatting techniques).
> Test your Spreadsheet by changing the exam results. The Grades and GPA should change when the exam result changes!
Your Spreadsheet should be named surname_firstname_EXT_Grade Book
