1. If function is used to judge the grade of average score (the grade of average score greater than or equal to 60 points is qualified, the grade of average score greater than or equal to 70 points is medium, the grade of average score greater than or equal to 80 points is excellent, and the grade of average score less than 60 points is unqualified);

1. If function is used to judge the grade of average score (the grade of average score greater than or equal to 60 points is qualified, the grade of average score greater than or equal to 70 points is medium, the grade of average score greater than or equal to 80 points is excellent, and the grade of average score less than 60 points is unqualified);

1. Input "name" in A1, input scores of each subject in B1, C1, D1, E1, F1 and G1, and input "average grade" in H1
Then, starting from the second line, fill in the data of "name" and scores of each subject
Enter the following formula in H2 and fill it down:
=If (A2 = & quot;, & quot; & quot;, if (average (B2: D2) & gt; = 80, & quot; excellent & quot;, if (average (B2: D2) & gt; = 70, & quot; medium & quot;, if (average (B2: D2) & gt; = 60, & quot; qualified & quot;, & quot; unqualified & quot;)))
 
2. The steps of setting conditional format are as follows
First define the data area of column a (excluding "name")
Select conditional format from format in the menu bar to enter a dialog box
Select formula from the drop-down list of condition 1, and then enter "= h2 = excellent" in the formula edit box on the right. Click the format button to open the cell Format dialog box, and select "color" as red in the font page
After confirming the color selection, return to the "conditional format" dialog box and click "OK"