Basic computer knowledge in excel format

TASK 2 Collect students information for "BBA 230". The information should have student names, marks obtained, attendance and percent paid. 1. Create a table from the information stated above using the 4 columns. 2. Cells with marks less than 50% should automatically turn red. 3. Cells with marks more than 80% should automatically turn green. 4. Create a graph showing the deferent grades obtained by the students. 5. Create a suitable pivot table showing payment percentages. 6. Make a summary of the information using any suitable excel means