Correct option is D
The correct sequence for sorting a range of cells in ascending order in MS Excel 365 is:
In the ‘Sort’ dialog box, select the ‘Ascending’ option in the ‘Order’ section.
Here's how you do it:
- Select the range of cells: Click and drag your mouse over the cells you want to sort.
- Open the Sort dialog box:
- Method 1: On the "Data" tab, in the "Sort & Filter" group, click "Sort."
- Method 2: Right-click within the selected range and choose "Sort" from the context menu.
- Choose "Ascending": In the "Sort" dialog box, under "Order," select "Ascending."
- Click "OK": Excel will sort the selected range of cells in ascending order based on the selected column.
This method allows you to access the full sorting options, including:
- Sorting by multiple columns: You can specify additional sort criteria for subsequent columns.
- Sorting options: Choose between ascending and descending order.
- Header row options: Indicate whether your data has a header row.
By using the "Sort" dialog box, you have more control over the sorting process and can easily customize it to fit your specific needs.