How to get a summary in excel form

How to get the overall rating in Excel form

If the formula for calculating the overall rating is: Overall rating = usual grade × 30% Midterm grade × 30% Final grade × 40%

The following is an example of how to calculate the overall rating.

1. Open the Excel spreadsheet software.

#2. Set the table structure as shown in the figure.

Recommended learning: excel basic tutorial

3. After entering the scores of each column, In the general evaluation column, enter according to the requirements of the overall evaluation formula, and then press Enter.

4. For multiple people to calculate at the same time, directly enter the usual grades, midterm grades, and final grades, and then place the mouse in the total grade column. In the lower right corner of the "·" position, click " " and pull down at the same time.

5. The final completion is as follows, the yellow part is the overall score:

For more related tutorials, please pay attention to PHP Chinese website!

The above is the detailed content of How to get a summary in excel form. For more information, please follow other related articles on the PHP Chinese website!