What is the SORT and SORTBY function difference in Excel 365?

Question

Microsoft Excel — Hard

What is the SORT and SORTBY function difference in Excel 365?

Accepted Answer

The SORT function sorts a range based on its own columns, whereas SORTBY enables sorting by external arrays. This distinction allows SORTBY to sort by columns not included in the output. The correct answer highlights this key difference. Incorrect options misrepresent the functions' capabilities.