Here are some apps that I use:
1) QuickOffice Pro - to manage, view, edit and create word, excel, power point and PDF documents.
2) Browser Offline viewing - you can save news articles from the mobile browser to view offline.
3) PowerAMP Pro - listening to MP3 music.
4) Amazon Kindle and Aldiko - read books/magazines.
5) Bible - various translations to read when offline.
6) Games - UNO, Spades, solitaire, Air Hockey Speed, Pinball HD for Tegra and word search. (Most games can be played offline.)
If you save movies to and SD card, you can view those offline too.