Question

you created a spreadsheet with a list of the students in your class and contact information for them. for which task should you use the filter function to display the desired result? a you want to display a list of the students who live in a particular city. b you want to display the list of students in your class. c you want to reorder the list of students by date of birth in descending order. d you want to reorder the list of students by last name in ascending order.

Explanation:

The Filter function is used to show only rows that meet specific criteria (e.g., students in a particular city). Options B is the original full list, while C and D involve reordering, which uses the Sort function, not Filter. Thus, A is the correct task for Filter.

Answer:

A. You want to display a list of the students who live in a particular city.