2. Enter the students' grades. A set of data is simulated here. 1 * * Yes 1 1 person:
3, input conditions, mathematics is greater than 90, English is greater than 90, pay attention to the staggered columns represent two different conditions, greater than the symbol using English input method:
4, click on the data in the toolbar above:
5, click on the filter fat senior:
6. Select the data just entered in the list area:
7. Conditional area selection The conditional area you just entered is greater than 90:
8. As a result of advanced screening, 8 people scored above 90 in math or English.