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

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

Making Result Sheet.xlsx

Making Result Sheet.pdf

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.

Similar Readings

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.

Get FREE Advanced Excel Exercises with Solutions!

6 Comments

Robert Bakinam Mar 26, 2023 at 7:02 AM

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
Kay Jul 15, 2023 at 5:50 AM

Thanks this is very useful. Please how can i go about it, if i have a report/result form in another worksheet and i want a situation when i click on any of the students name, the marks and grades in the form changes to the student’s grade
- Reply
  Shamima Sultana Jul 16, 2023 at 11:21 AM
  
  Dear Kay,
  
  To get a customized templates you can contact with us through this Email: [email protected]
  
  Regards
  ExcelDemy
naziom Oct 8, 2023 at 1:54 PM

thank you very much .
- Reply
  Shamima Sultana Oct 9, 2023 at 8:57 AM
  
  Hello Naziom,
  
  You are most welcome.
  
  Regards
  ExcelDemy