kirieldecisions
contestada

PLEASE HELP!
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.

Respuesta :

rarrininger
The Filter function will allow her to quickly find this data. It is not impossible using the Sort function, but it will take much longer and involve a lot of manual cutting, pasting or deleting of unnecessary data.


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

The correct answer is option D. For Laura to quickly get this list together, she should apply a filter for the students and also use a filter to know the schools that she should exclude.

In a datasheet or worksheet, filters are very important and very helpful for narrowing down information.

Filters can help Laura to decrease the data she has on her worksheet. This way, only the data she needs is what she would see.

Here is a related question on filters https://brainly.com/question/14376643?referrer=searchResults