Which action is typically used to apply sorting to data?

• A. Right-click the column and select 'Delete'
• B. Pressing the delete key
• C. Selecting the relevant cells and using the Sort range or Sort sheet options
• D. Changing the font color of headers

Answer: (C)

Sorting reorders rows based on the values in a chosen column. To apply it, you select the data range you want to sort and then use the sort function, choosing either Sort range (to sort only the selected data) or Sort sheet (to sort the entire sheet). You can pick ascending or descending order and indicate whether there’s a header row so headers aren’t mixed with data. This directly changes the order of records to reflect the chosen criterion, which is why it’s the right approach. Delleting content or changing font color, by contrast, modify or remove data or formatting rather than reorder rows.