Google Sheets

You can use the File menu and Download As command to save a Google Sheet in another format, including PDF. 

Yes there is - it can be accessed via the Data menu. 

In a shared sheet, if one user filters a list, everyone will see the filtered list. You can create multiple filter views in a sheet, giving each a name that can be selected to view that set of data at any time. Filter views show only for the users that has selected the view - all other users viewing the document will see the data it as it was. 

You can click on the Tools menu and choose Notification Rules to be notified when changes have been made to the sheet. 

Yes, you can set any collaborator on the document as the new owner via the Share screen. 

Yes, but only if you are the owner of the sheet. 

Yes, people you choose to share the document with can be given permission to edit or view the document, or to be able to add comments. Click on the Share button to change all sharing settings. 

Yes, as long as your administrator has enabled this setting, you can share a sheeet with anyone, regardless of whether they have a Gmail account or not.

In the Shared with me folder, right-click over the shared file and choose Add to My Drive. 

If you delete a sheet from your Drive that was shared with you, the sheet won’t be deleted but will simply be removed from your Drive view. You can restore the sheet by finding it in the Shared with me folder and adding it to your My Drive again. 

Features to note:

• Some conditional formatting e.g. colour scales and icon sets

• Rotated text will be converted to standard text (i.e. horizontal) 

• Table formatting & background images

• Linked text will be converted, but links are removed

• Text boxes will be converted to embedded drawings

• Sparklines will be converted to sparkline functions

• Sheet and workbook protection 

• Sheet headers and footers, SmartArt diagrams 

• Subtotals will be converted to subtotal functions and outlining 

• PivotTable slicers and timelines will not be converted

• Macros will not be converted

Yes, you can view a list at: https://support.google.com/docs/table/25273?hl=en 

Sheets can contain up to 5 million cells. You can add up to 40,000 new rows at a time, and a sheet can contain a maximum of 18,278 columns. A workbook can contain a maximum of 200 sheets and the maximum string length is 50,000 characters.