Spreadsheet: 827652d1682937691-1-formula-to-complete-four-different-tasks-0501help
Sheet: Sheet1

 |  |  |  | language | Mathematics | English | physics | Chemical | politics | history | biology | geography |  |  |  |  |  |  |  |  |  | The average score | highest score | Lowest score | Top ten average score
 |  |  |  | 87 | 81 | 80 | 70 | 67 | 78 | 51 | 0 | 0 |  |  |  |  |  |  |  |  | language
 |  |  |  | 84 | 46 | 89 | 61 | 36 | 87 | 49 | 0 | 0 |  |  |  |  |  |  |  |  | Mathematics
 |  |  |  | 84 | 40 | 84 | 52 | 57 | 73 | 45 | 324 | 324 |  |  |  |  |  |  |  |  | English
 |  |  |  | 82 | 47 | 74 | 50 | 23 | 78 | 40 | 260 | 260 |  |  |  |  |  |  |  |  | physics
 |  |  |  | 63 | 60 | 40 | 59 | 47 | 77 | 44 | 370 | 370 |  |  |  |  |  |  |  |  | Chemical
 |  |  |  | 75 | 21 | 56 | 45 | 41 | 75 | 30 | 421 | 421 |  |  |  |  |  |  |  |  | politics
 |  |  |  | 75 | 29 | 65 | 26 | 25 | 82 | 33 | 0 | 0 |  |  |  |  |  |  |  |  | history
 |  |  |  | 0 | 0 | 31 | 0 | 45 | 0 | 46 | 244 | 244 |  |  |  |  |  |  |  |  | biology
 |  |  |  | 90 | 69 | 81 | 77 | 54 | 75 | 41 | 4 | 4 |  |  |  |  |  |  |  |  | geography
 |  |  |  | 91 | 46 | 94 | 56 | 44 | 75 | 49 | 0 | 0
 |  |  |  | 75 | 73 | 55 | 56 | 60 | 78 | 35 | 20 | 20
 |  |  |  | 67 | 49 | 54 | 68 | 56 | 73 | 35 | 410 | 410
 |  |  |  | 64 | 66 | 64 | 54 | 40 | 68 | 29 | 228 | 228
 |  |  |  | 74 | 38 | 50 | 36 | 34 | 81 | 44 | 100 | 100 |  |  |  |  |  |  |  |  |  | 75.6086956521739 | 96 | 46 | 87.3
 |  |  |  | 73 | 34 | 26 | 45 | 35 | 71 | 40 | 0 | 0 |  |  |  |  |  |  |  |  | Mathematics | 49.45652173913044 | 81 | 15 | 71.9
 |  |  |  | 57 | 37 | 33 | 30 | 26 | 64 | 36 | 431 | 431 |  |  |  |  |  |  |  |  | English | 57.77659574468085 | 94 | 25.5 | 84
 |  |  |  | 81 | 78 | 80 | 72 | 42 | 81 | 45 | 0 | 0 |  |  |  |  |  |  |  |  | physics | 55 | 88 | 26 | 72.45454545454545
 |  |  |  | 92 | 60 | 70 | 64 | 50 | 72 | 53 | 0 | 0 |  |  |  |  |  |  |  |  | Chemical | 40.70212765957447 | 67 | 12 | 58.5
 |  |  |  | 79 | 40 | 60 | 57 | 55 | 75 | 59 | 340 | 340 |  |  |  |  |  |  |  |  | politics | 73.93478260869566 | 94 | 47 | 83.9
 |  |  |  | 76 | 53 | 38 | 70 | 58 | 65 | 55 | 0 | 0 |  |  |  |  |  |  |  |  | history | 41.91489361702128 | 60 | 23 | 54.45454545454545
 |  |  |  | 68 | 48 | 69 | 61 | 27 | 68 | 42 | 385 | 385 |  |  |  |  |  |  |  |  | biology | 232.7666666666667 | 431 | 4 | 386.3
 |  |  |  | 85 | 51 | 61 | 44 | 37 | 65 | 33 | 0 | 0 |  |  |  |  |  |  |  |  | geography | 232.7666666666667 | 431 | 4 | 386.3
 |  |  |  | 74 | 33 | 33 | 29 | 25 | 78 | 46 | 212 | 212
 |  |  |  | 48 | 28 | 31 | 51 | 31 | 72 | 28 | 116 | 116
 |  |  |  | 76 | 63 | 81 | 79 | 59 | 83 | 53 | 0 | 0
 |  |  |  | 81 | 70 | 57 | 56 | 31 | 68 | 30 | 68 | 68
 |  |  |  | 79 | 57 | 60 | 58 | 31 | 73 | 31 | 196 | 196
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 292 | 292
 |  |  |  | 79 | 72 | 84 | 52 | 44 | 94 | 60 | 0 | 0
 |  |  |  | 82 | 32 | 61 | 68 | 41 | 78 | 32 | 0 | 0
 |  |  |  | 71 | 36 | 42 | 57 | 51 | 80 | 47 | 84 | 84
 |  |  |  | 70 | 31 | 25.5 | 34 | 21 | 47 | 41 | 132 | 132
 |  |  |  | 96 | 61 | 66 | 63 | 52 | 84 | 56 | 0 | 0
 |  |  |  | 74 | 50 | 66 | 60 | 42 | 78 | 42 | 355 | 355
 |  |  |  | 80 | 40 | 33 | 68 | 39 | 78 | 42 | 0 | 0
 |  |  |  | 58 | 33 | 34 | 45 | 24 | 56 | 36 | 180 | 180
 |  |  |  | 78 | 52 | 88 | 55 | 59 | 87 | 41 | 308 | 308
 |  |  |  | 72 | 56 | 57 | 68 | 52 | 62 | 57 | 52 | 52
 |  |  |  | 81 | 59 | 30 | 49 | 27 | 78 | 36 | 148 | 148
 |  |  |  | 77 | 39 | 41 | 30 | 33 | 68 | 23 | 276 | 276
 |  |  |  | 80 | 68 | 74 | 69 | 60 | 72 | 30 | 0 | 0
 |  |  |  | 80 | 74 | 43 | 88 | 32 | 74 | 38 | 429 | 429
 |  |  |  | 73 | 48 | 53 | 46 | 12 | 80 | 42 | 398 | 398
 |  |  |  | 46 | 42 | 51 | 59 | 22 | 63 | 37 | 0 | 0
 |  |  |  | 79 | 63 | 79 | 52 | 43 | 78 | 57 | 0 | 0
 |  |  |  | 80 | 68 | 64 | 67 | 47 | 65 | 42 | 36 | 36
 |  |  |  | 72 | 19 | 39 | 31 | 49 | 77 | 48 | 164 | 164
 |  |  |  | 70 | 15 | 69 | 43 | 27 | 67 | 41 | 0 | 0