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
b) No

Answer 1

If we say 'yes', Excel will extend the sorting to include the adjacent column, if it has data. If we say 'no', Excel will only sort the selected column, leaving the adjacent column untouched.

Step-by-step explanation:

If we have 2 columns in Excel and try sorting one of them, Excel asks us if we want to expand the selection. If we say yes, Excel will extend the sorting to include the adjacent column, if it has data. This can be useful if we have related information in both columns that need to stay connected after sorting. On the other hand, if we say no, Excel will only sort the selected column, leaving the adjacent column untouched.