Home  >  Article  >  Topics  >  How to use the highest score function in excel table

How to use the highest score function in excel table

藏色散人
藏色散人Original
2020-03-29 09:24:2112243browse

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.

How to use the highest score function in excel table

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

How to use the highest score function in excel table

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

How to use the highest score function in excel table

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

How to use the highest score function in excel table

Then click on the fx function logo above.

How to use the highest score function in excel table

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

How to use the highest score function in excel table

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

How to use the highest score function in excel table

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

How to use the highest score function in excel table

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn