Question

Laura has a list of the SAT scores of over a thousand students. She needs to write to the top 10 students but exclude students that come from specific schools. How can she quickly get this list together?

A.)Laura can add two levels to Sort by, first sorting by score and then sorting by school.

B.Laura can use the Find function to find all the students who attended each school and their score.

C.Laura can Sort the scores, cut and paste it into a new sheet and then use the Sort function again to organize them by school.

D.)Laura can apply a Filter for the top 10 students and a Filter for which schools to exclude from the results.

Answer 1

Answer:

HOPE IT HELPS YOU DEAR PLEASE PLEASE MARK IT BRAINLIEST AND FOLLOW ME DEAR PLEASE

Answer 2

Answer:

D)

Explanation:

Advance Filter Option in Excel helps you to get the desired answer.

Even SORT can help but it will be a time consuming activity

First filter out your top 10 students then add another filter and include the school name you want