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.
This step by step is very helpful to me. Can I have a full copy in pdf file and more practical sessions.
Thanks
Hi Robert Bakinam,
Here, you will get the full copy in pdf Marking Result Sheet.
Regards
Shamima Sultana
Project Manager | ExcelDemy