# How to Make Result Sheet in Excel (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

## 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. ### 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. ### 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. ### 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
• 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. ### 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. ### 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. ## 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.

## Related Articles #### Mashhura Jahan

Hey! Welcome to my profile. Currently, I am doing research on Microsoft Excel. I will be posting articles related to this here. My last educational degree was B.Sc in Industrial and Production Engineering from Bangladesh University of Engineering and Technology. I like to explore new things and find the best and most innovative solutions in every situation.

1. Reply This step by step is very helpful to me. Can I have a full copy in pdf file and more practical sessions.
Thanks

• Reply Shamima Sultana Mar 27, 2023 at 9:52 AM

Hi Robert Bakinam,

Here, you will get the full copy in pdf Marking Result Sheet.

Regards
Shamima Sultana
Project Manager | ExcelDemy Advanced Excel Exercises with Solutions PDF  