Using WPS to calculate average points quickly

The school held a speech contest, a number of judges to the contestants, calculate average time to remove two top points and two minimum points, how to solve this problem? Open the wps form and practice it!

First, input the score of the contestants.

Second, calculate each contestant's two highest points and two minimum points

1. In J2, enter: "=large (b2:i2,1)", which represents the value of the largest (parameter "1") in the B2:i2 grid.

2. Enter in K2: "=large (b2:i2,2)", which indicates the value of the second largest (parameter "2") in the B2:i2 lattice.

3. In L2 input: "=small (b2:i2,1)", which indicates the value of the minimum (parameter "1") in the B2:i2 grid.

4. Enter in M2: "=small (b2:i2,2)", which indicates the value of the second small (parameter "2") in the B2:i2 lattice.

5. Enter in N2: "= (SUM (B2:i2,)-sum (J2:M2))/4", which means that the player scores and subtracts two highest points, two minimum points, and then divides by 4 to obtain a relatively reasonable average score.

6, automatic filling.

7, the highest and lowest points can also be used max, Min function to ask.

In the same way, the average score of a student's examination can also be removed from some of the lowest points.

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join