Question

which button in the sort & filter gallery of the data tab would sort the text into alphabetical order?
sort smallest to largest
sort a to z
sort first to last
sort newest to oldest

Explanation:

To determine the correct button for alphabetical sorting, we analyze each option:

• "Sort Smallest to Largest" is for numerical data (e.g., numbers, dates as numbers).
• "Sort A to Z" is specifically designed to sort text (like words, names) in alphabetical order (ascending alphabetical order).
• "Sort First to Last" is not a standard sorting option for alphabetical order in Excel's Sort & Filter gallery.
• "Sort Newest to Oldest" is for sorting by date (e.g., newest dates first, like for files or timestamps).

Since the goal is to sort text alphabetically, "Sort A to Z" is the correct option.

Answer:

B. Sort A to Z