Shulou(Shulou.com)06/01 Report--

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)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.