a. Round the Midterm and Final scores to the nearest whole number for each student. b. Round the Midterm and Final scores to 1 decimal place for each student. IF Function: I a. Determine if a student passed the year (assuming a passing grade is an average of 80% and above). The output should be "Passed" or "Failed". b. Determine if a student is eligible for a bonus (A student is eligible if they have more than 90% attendance and their average score is above 85%).AND Function (to be used in combination with IF): a. For each student, determine if they've both scored above 80% in Midterm and Final exams. If they have, the output should be "Above 80% in Both", else "Not Above 80% in Both". VLOOKUP Function: a. For the given Student ID "1004", find the corresponding name. b. For the given name "William", find the corresponding Midterm Score.

Dataset: Student Records Student ID 1001 1002 1003 1004 1005 1006 

Name John Emily Michael Sarah William Olivia Midterm Score 67.65 89.45 72.34 84.52 79.87 91.22 

Final Score 85.32 91.85 78.65 87.54 81.56 88.44 

Attendance (%) 89 92 85 96 80 90