Exam 77-420 Microsoft Excel 2013 2. Create Cells and Ranges 2.1 Insert Data in Cells and Ranges: Filter Named Ranges (The Name Manager)

Formulas ->Defined Names->Name Manager->Filter Name Manager Options This process added another Defined Name to the Name Manager. A good, working spreadsheet may have dozens of Named Ranges. One of the best tools is the Filter. The Filter lets you choose which Defined Names you would like to see. You can limit the list of Names to the Names in just one worksheet, or view all of the Names in the workbook.   Try It: Filter the Names The Name Manager is still open. Click on Filter.   What Do You See? The options are: Clear Filter Names Scoped to a Worksheet Names Scoped to a Workbook Name with Errors Names without Errors Defined Names Table Names   Please close the Name Manager and Save your work.