If you sort one column of data in a table without sorting all of the columns, what happens?

Select answer from the options below

Only the column you sorted will sort, which will mean rows of information are now out of alignment.

You will receive a prompt from Microsoft Excel asking whether you meant to sort only one column and not all columns.

The columns in the worksheet will sort automatically, and you can press Undo to unsort the other columns if you choose.

The columns immediately before and after the column you sorted will sort with the column you selected, but others in the worksheet will be out of alignment.