Excel Interview Question: Adding Pass/Fail to Student Results

In this video, we will be writing a function that takes in a student table as input and adds a 'Pass' or 'Fail' to the results column based on the student's marks and attendance.

The criteria for passing is a student must have marks greater than 65 and attendance greater than 71%.

The function will loop through each student's record and update the results column accordingly.
Tune in to learn how to implement this logic in Excel !