Question

ahmed needs to restock the student store at his school. he is going to the local warehouse store and wants to find out what items have come from there. the inventory is a spreadsheet. he has an alphabetical list of items from the school store in column a. in column b, he has the name of the store that the items were purchased from. which option would allow ahmed to sort the data in alphabetical order according to the name of the store from which the items were purchased?

a sort by: column c, z → a

b sort by: column b, z → a

c sort by: column b, a → z

d sort by: column a, a → z

Explanation:

To sort the data alphabetically by the store name (in Column B), we need to sort Column B. Alphabetical order from A to Z is the standard ascending alphabetical sort. Option A is about Column C (irrelevant), Option B is descending (Z to A, not alphabetical order as typically meant), Option D is about Column A (item names, not store names). So Option C (Sort by: Column B, A → Z) is correct.

Answer:

C. Sort by: Column B, A → Z