If you want to make a result sheet, Excel can be really helpful. The main objective of this article is to explain how to make result sheet in Excel.
Download Practice Workbook
6 Easy Steps to Make Result Sheet in Excel
Here, I have taken the following dataset. It contains the Student ID and Name. I will make result sheet in Excel for these students with 6 easy steps.
Step-01: Entering Data
In this first step, I will show you how you can enter data for your result sheet.
- Firstly, make columns for the subjects you have. Here, I made columns for English, Math, Physics, History, and Art.
- Secondly, insert the obtained marks for these subjects. Here, I have inserted mine.
Read More: How to Make Automatic Marksheet in Excel (with Easy Steps)
Step-02: Using MAX and MIN Functions
In this step, I will use the MAX function and the MIN function to find the Highest and Lowest obtained marks for each student.
- Firstly, select the cell where you want the Highest marks. Here, I selected cell I5.
- Secondly, in cell I5 write the following formula.
=MAX(D5:H5)
Here, the MAX function will return the Highest found marks in cell range D5:H5.
- Thirdly, press ENTER to get the result.
- After that, drag the Fill Handle to copy the formula.
Now, you can see that I have copied the formula to all the cells and got the Highest number for each student.
Here, I will find the Lowest number for each student.
- Firstly, select the cell where you want the Lowest number. Here, I selected cell J5.
- Secondly, in cell J5 write the following formula.
=MIN(D5:H5)
Now, the MIN function will return the Lowest found number in the range D5:H5.
- Thirdly, press ENTER to get the result.
- After that, drag the Fill Handle to copy the formula.
Here, you can see that I have copied the formula to all the cells and got the Lowest number for every student.
Read More: How to Calculate Percentage of Marks in Excel (5 Simple Ways)
Step-03: Use of SUM Function to Get Total Obtained Marks
In this step, I will calculate the Total marks for each student in the result sheet in Excel. I will use the SUM function for this calculation.
- Firstly, select the cell where you want to calculate the Total marks. Here, I selected cell K5.
- Secondly, in cell K5 write the following formula.
=SUM(D5:H5)
Here, the SUM function will return the summation of the values in the cell range D5:H5.
- Thirdly, press ENTER to get the Total marks.
- After that, drag the Fill Handle to copy the formula. To the other cells.
Now, you can see that I have copied the formula to all the other cells and got Total marks for every student.
Read More: How to Apply Percentage Formula in Excel for Marksheet (7 Applications)
Similar Readings
- How to Calculate Letter Grades in Excel (6 Simple Ways)
- Calculate Average Percentage Increase for Marks in Excel Formula
- How to Calculate Grade Percentage in Excel (3 Easy Ways)
Step-04: Employing AVERAGE and ROUND Functions in Result Sheet
The 4th step to making a result sheet in Excel is to calculate the Average marks for each student. Here, I will use the AVERAGE function and the ROUND function for this step.
- Firstly, select the cell where you want your Average marks.
- Secondly, write the following formula in the selected cell.
=ROUND(AVERAGE(D5:H5),0)
Formula Breakdown
- AVERAGE(D5:H5) —-> Here, the AVERAGE function will return the average of the cell range D5:H5.
- Output: 72.6
- ROUND(AVERAGE(D5:H5),0) —-> turns into
- ROUND(72.6,0) —-> Here, the ROUND function will return the rounded number to the given num_digits which is 0 in this case.
- Output: 73
- ROUND(72.6,0) —-> Here, the ROUND function will return the rounded number to the given num_digits which is 0 in this case.
- Thirdly, press ENTER to get the Average marks.
- After that, drag the Fill Handle to copy the formula.
Now, you can see that I have copied the formula to all the cells and got the Average number for every student in my result sheet in Excel.
Read More: How to Calculate Average Percentage of Marks in Excel (Top 4 Methods)
Step-05: Using Nested IF Function to Show Grades
Here, I will explain the 5th step of how to make result sheet in Excel. In this step, I will use the Nested IF function to show the Grades. For this step, I won’t need numbers in individual subjects. For this reason, I have hidden those columns. So, you will be able to get a better view.
- Firstly, select the cell where you want to show your Grades. Here, I selected cell M5.
- Secondly, in cell M5 write the following formula.
=IF(J5<60,"F",IF(L5>=90,"A",IF(L5>=80,"B",IF(L5>=70,"C",IF(L5>=60,"D","F")))))
Formula Breakdown
- Here, in the IF function, I selected J5<60 as logical_test, “F” as value_if_true, and another IF function as value_if_false.
- Then, in the second IF function, I selected L5>=90 as logical_lest, “A” as value_if_true, and a third IF function as value_if_false.
- Next, in the third IF function, I selected L5>=80 as logical_lest, “B” as value_if_true, and another IF function as value_if_false.
- After that, in the fourth IF function, I selected L5>=70 as logical_lest, “C” as value_if_true, and another IF function as value_if_false.
- Finally, in the last IF function, I selected L5>=60 as logical_lest, “D” as value_if_true, and “F” as value_if_false.
- Thirdly, press ENTER.
- After that, drag the Fill Handle to copy the formula.
Now, you can see that I have copied the formula to the other cells and the Grades are showing.
Read More: How to Compute Grades in Excel (3 Suitable Ways)
Step-06: Applying RANK.EQ Function in Result Sheet
In this step, I will show the ranks in the result sheet in Excel. I will use the RANK.EQ function to show the ranks.
- Firstly, select the cell where you want the Rank. Here, I selected cell N5.
- Secondly, in cell N5 write the following formula.
=RANK.EQ(K5,$K$5:$K$14,0)
Here, in the RANK.EQ function I selected K5 as number, range K5:K14 as ref, and 0 as order which is the descending order.
- Thirdly, press ENTER.
- After that, drag the Fill Handle to copy the formula.
Finally, you can see I have copied the formula to all the cells and thus ranked the students.
Now, I will unhide the hidden columns so that you can see my final result sheet in Excel in the following image.
Read More: How to Make a Grade Calculator in Excel (2 Suitable Ways)
Practice Section
Here, I have provided a practice sheet for you to practice how to make result sheet in Excel.
Conclusion
In this article, I tried to explain how to make result sheet in Excel with 6 easy steps. I hope this article was helpful for you. Lastly, if you have any questions let me know in the comment section below.