In MS-Excel 365, which option allows you to sort data based on multiple columns simultaneously?

Correct option is C

The Custom Sort option in MS-Excel 365 allows you to sort data based on multiple columns simultaneously.
1. Navigate to the Data tab in the toolbar.
2. Click on Sort under the Sort & Filter group.
3. In the Sort dialog box, specify the columns, sort order (e.g., ascending/descending), and priority for sorting.
Important Key Points:
1. Custom Sort enables hierarchical sorting, where data is sorted by one column first, followed by other columns.
2. This feature is essential for managing complex datasets with multiple criteria.
3. Sort A to Z only works for single-column sorting, not for multiple columns.
Knowledge Booster:
· AutoFilter: Filters data based on specific criteria but does not sort.
· Quick Sort: Refers to an algorithm, not a feature in Excel.
· Sorting is a key feature for organizing and analyzing large datasets effectively in Excel.
· Shortcut: Use Alt + D + S to open the Sort dialog box.