How to classify and summarize with excel tables

The specific operation steps of classifying and summarizing with excel tables are as follows:

Take excel20 10 as an example:

1. First open the excel to be edited, and select the cells to be classified and summarized with the left mouse button.

2. Then click the "Sort and Filter" option in the "Data" menu to sort the data.

3. Then click the "Category Summary" option on this page.

4. Then click and select "Gender" in the box below the classification field on this page, click and select "Average Score" in the box below the summary method, click and check "Total Score" in the box below the selected summary item, and then click "OK" to complete the summary.