Head teacher, please take it! A wave of Excel skills essential to performance statistics
Excel is not only a necessary office software for business white-collar workers, but also an indispensable achievement statistics tool for teachers and students in the school. Today, I have prepared a few Excel skills that are indispensable to performance statistics, and take it as soon as you need it.
Fractional segment population statistics
The method of quickly counting the number of people in each segment according to different score segments.
Method: select the cell-enter = FREQUENCY (B2:B6, {60th, 70th, 80th 90})-press [Ctrl+Shift+Enter]
Grade judgment
Sometimes grades don't just use numbers, but simply use grades.
Formula: = IF (B2)
