How to use the highest score function in excel table

How to use the highest score function in excel? Use the functions in the excel table to find the highest score of students

First open the excel table on the computer, as shown in the figure.

After opening, find the score form that requires the highest score and open it, as shown in the picture.

After opening it, we saw the total score in the score table. Now we need to use a function to find its highest score.

We select the cell below the total score, as shown in the figure.

Then click on the fx function logo above.

Select MAX in the pop-up window and click OK, as shown in the figure.

Then confirm the first and last cells that need to be summed, as shown in the figure. Click OK.

#Finally we see that the highest score has been automatically filled in the cell we selected before.

The above is the detailed content of How to use the highest score function in excel table. For more information, please follow other related articles on the PHP Chinese website!