1. First, open a class report card. Then, select the cell. Then, select the Formula tab. After that, click "Insert Function". Then, write the required functions in the description. After typing, click Go to insert the required function.

2. You can choose to use the SUMIF function and enter = sumif (B 1: B 100, female, c1:c100)/countif (b1:b1). SUMIF function is commonly used in Excel. Use the SUMIF function to sum the values in the report range that meet the specified conditions.

3. Double-click to open the Excel spreadsheet. After opening, enter the student's grades, as shown in the figure. After entering student grades, click to select the cell where you want to store grades and values, then click Start, and then click Sum.

4.Sum ∑ Ah, put Chinese, math and English in different columns by name, and then in the last column, total score, total score =sum (Chinese: English), or total score = Chinese+math+English, drag down and add up everyone's scores in the class.

5. Enter the number of requirements and in the table. Press "ctrl+A" key on the keyboard. When pressed, all the numbers in the table will be selected. Then press the "alt+=" key on the keyboard. Finally, sum the figures in the table successfully.