Today, I will show you how to make a scorecard in Excel and use the IF Function to calculate the scores automatically. We have a list of students who have all completed our test. If the student has scored more than 80 points, we should fill the results column with “Pass”; if they score less…