Question

If we have 2 columns and try sorting one of them, Excel asks us if we want to expand the selection. What would be the result of saying yes or no?

a) Yes - The entire selection is sorted based on the chosen column.
b) No - Only the chosen column is sorted, leaving the other column unchanged.

Answer 1

Choosing 'yes' to expand the selection in Excel means the entire selection is sorted based on the chosen column, keeping row integrity. Saying 'no' will only sort the selected column, potentially causing data misalignment.

Step-by-step explanation:

If you are sorting columns in Excel and you opt to say yes to expand the selection, then the result will be that the entire selection is sorted based on the chosen column. This means that Excel will sort the column you've selected and will also rearrange the adjacent columns so that the rows maintain their integrity, keeping related data together across the rows.

If you choose no when asked to expand the selection, then only the chosen column will be sorted, and the other column will remain unchanged. This can disrupt the relationship between data in the rows, which could potentially lead to data becoming mismatched or out of context.