Then use the format to adjust the decimal point.
three
Average score of boys =AVERAGEIF(C:C, "male", I:I)
Average score of female students =AVERAGEIF(C:C, "female", I:I)
Average score of boys in all subjects =AVERAGEIF(C:C, "male", J:j)
Average score of female students in all subjects =AVERAGEIF(C:C, "female", J:j)
The rest should be made by hand, and there is no watch.