Settings of the formula in Excel

Based on the table (download from the database - answers of students of different classes to questions of the test) the method of the formula was obtained a resulting document with the fields: FIO student, class, school, general score.