The __________________ function looks up data, sorts it, then uses it to generate a list in a new location.

• A. Sort
• B. Lookup
• C. Filter
• D. Index

Answer: (A)

Sorting a dataset is about taking the relevant records, arranging them in a defined order, and then producing that ordered list wherever you need it. In this case, the function described does the initial data retrieval (looking up the data), applies an order to those records, and outputs the resulting list to a new location. That combination of selecting, ordering, and placing the results exactly matches what sorting does.

The other options don’t create a sorted list: a lookup fetches a single matching value, a filter narrows the data to a subset without guaranteeing any particular order, and an index retrieves a specific item from a collection rather than producing a whole ordered list.