Sheets offers functions for sorting and filtering data that are typically only found in the menu options of other spreadsheet programs, or not found at all in the case of SORTN. On the desktop version of Sheets, the SORT and FILTER functions are available through the menus as shown in the pictures below, while the tablet version has 'Create a filter' option in the more (three circles in a vertical line) menu on the right hand side of the screen.
The UNIQUE function, which does not exist as a function in Excel either, removes duplicate rows of data in a spreadsheet. Another Sheets-only function, SORTN, return n number of items from a range of data.
All filter functions
The ability to use these as functions is what sets Sheets apart from the competition.