I just did a test and found that Google Docs and Spreadsheets searches not just the title and tags of your doc or spreadsheet, but within the content as well.

That's pretty powerful, considering Windows search doesn't do the same.