Current location - Training Enrollment Network - Mathematics courses - Operation of excel table
Operation of excel table
1. Set each field name in the table to 20-point bold and center it in the cell.

2. Find the total score of each student and calculate the AVERAGE score of each student with the function average (). The numerical format of the result is numerical, and 1 decimal place is reserved.

3. Add a new record after recording "Zhao Li". The name field value is "Summary", the class field value is blank, and the field values of Chinese, Mathematics, Foreign Language and Total Score are the sum of all students' Chinese, Mathematics, Foreign Language and Total Score respectively.

4. Use foreign language scores to create a three-dimensional pie chart embedded in G 1:K8 area. The icon is titled "Fraction Proportion", and the students' names are placed on the left.

5. In Sheet 1, select the column data of "average grade" and draw a three-dimensional clustering column chart of each student's average grade. The name is horizontal (classification) axis label (c), and the legend is not displayed. The title of the chart is "Average Score Chart", which is embedded in areas A 18 to F27.

6. Copy the name and average score to the beginning of columns A and B of Sheet2.

7. Insert a row before the first row, and enter the "Student Basic Information Table" in the first cell, and center it between the columns in cells A 1 to E 1.

8. Screen out students whose Chinese and math scores are above 85 in Sheet 1.

9. According to the category field classification statistics, statistical name field.

Pay attention to the key display in the lower right corner of the animation.