Question

If a data analyst wants to list the cities in this spreadsheet alphabetically, instead of numerically, what feature can they use in column B? Randomize range Name range Organize range Sort range

Answer 1

To list cities alphabetically in a spreadsheet, a data analyst should use the Sort range feature.

Step-by-step explanation:

If a data analyst wants to list the cities alphabetically in a spreadsheet, they can use the Sort range feature in column B. This feature allows the user to order the data based on the selected column's values. In Microsoft Excel, for example, selecting column B with the city names and then choosing the sort option will rearrange the cities into alphabetical order.