The AdvancedSearch Dialog Box allows you to enter the text to search for, as well as, various options to control your search.
The "Options" selection allows you to set the type of search. "Look in" selections set where to search in Excel and "Scope" selection allows you to restrict a search to a worksheet, a workbook or all open workbooks.
