Concept:Sorting in MS Excel requires selecting the data range and using the Sort function available in the Data menu to set the desired order.
Explanation:Step 1: Select the entire data range that needs to be sorted, including column headers if required.
Step 2: Go to the Data menu on the Excel ribbon.
Step 3: Click the Sort button to open the Sort dialog box.
Step 4: Choose the column by which the data should be sorted.
Step 5: Select the sorting order: A to Z or Smallest to Largest for ascending order, and Z to A or Largest to Smallest for descending order.
Step 6: Click OK to apply the sort.
This method allows sorting by multiple levels and gives full control over the sorting criteria and order.
Option A is incorrect because the Format menu does not contain the Sort command.
Option C is possible but limited to quick single-column sorting without advanced customisation.
Option D is incomplete because clicking the Sort button alone does not allow specifying the sorting criteria and order.
Answer:The correct option is B: By selecting the data range, then choosing 'Sort' from the Data menu and specifying the sorting criteria and order.