Search and Navigate to Named Cells, Ranges, Elements

Navigation as a scored skill

Domain 1 asks you to search for data within a workbook and navigate to named cells, ranges, or workbook elements. On a timed performance exam, hunting cell-by-cell wastes minutes. Graders care that you land on the correct cell, replace the correct instances, or select the named range the task cites—often as setup for a later formula or chart step.

Find and Replace (Ctrl+F / Ctrl+H)

Press Ctrl+F (Mac: Control+F or Command+F depending on Excel settings) to open Find. Press Ctrl+H for Replace.

Key controls in the Find dialog:

Performance tips for Find

• If Find says no matches, widen scope to Workbook, clear Match entire cell contents, and confirm you are looking in Values when the formula bar shows a formula but the cell displays a result.
• Find All is faster than clicking Find Next repeatedly when you must count occurrences or jump to the third match.
• Replace All is powerful—and dangerous. If the task says replace only on the current sheet, set Within: Sheet before Replace All.

Example descriptor: "Replace all instances of Q1 with Quarter 1 on the Summary sheet only." → Go to Summary → Ctrl+H → Within Sheet → Replace All.

Go To and Go To Special

Ctrl+G or F5 opens Go To. Type a reference such as D40 or Orders!A1 and press Enter to jump immediately.

Click Special… to open Go To Special, which selects cells by type instead of by address:

• Blanks — select empty cells in a range (often before filling or deleting)
• Constants / Formulas — audit mixed regions
• Current region / Current array — expand selection
• Visible cells only — important after filters when copying
• Conditional formats, Data validation, Objects — jump to formatted or object-bearing cells

Example descriptor: "Select all blank cells in the used range of columns A:C and fill them with 0." → Select A:C used range → Ctrl+G → Special → Blanks → type 0 → Ctrl+Enter.

You do not need every Special option memorized, but Blanks, Formulas, Constants, and Visible cells appear often in MOS-style work.

Name Box navigation

The Name Box sits to the left of the formula bar. It normally shows the active cell address (B2). It also:

1. Accepts a typed address or range (G15, A1:D10, Sheet3!C5)—press Enter to select it.
2. Lists defined names in its drop-down arrow.
3. Displays the name when the selection exactly matches a named range.

Navigating to named cells and ranges

If the workbook already defines names such as TaxRate, SalesHeader, or EmployeeList:

1. Click the Name Box drop-down.
2. Choose the name the task mentions.
3. Excel selects the range, switching sheets if needed.

Alternatively, open Go To (Ctrl+G)—defined names appear in the Go To list as well.

Associate note: Defining new names is primarily a Domain 2 skill (Define and reference named ranges). For this section, focus on using existing names to navigate. If a task says "go to the range named Commission," do not recreate the name—select it.

Workbook elements: sheets, tables, charts

"Workbook elements" means more than cells:

• Sheets — Click sheet tabs, or use Ctrl+Page Up / Ctrl+Page Down to move between worksheets. Right-click the tab scroll arrows for a list of sheets in large workbooks.
• Tables — Click any cell in a table; use the Name Box if the table has a name, or select from Go To.
• Charts and objects — Click the chart, or use Go To Special → Objects, or select the chart name from the Selection Pane (Home → Find & Select → Selection Pane) when objects stack.

Example descriptor: "Activate the chart titled Regional Sales and move it to its own chart sheet" — first navigate to / select that chart element, then complete the chart move. Selection is the navigation half of the task.

Putting the tools together

Exam traps

• Searching only the active sheet when the value lives elsewhere.
• Using Find for a displayed value while Look in is set to Formulas (or the reverse).
• Typing a name into Find instead of using the Name Box—Find looks for cell contents, not defined names (unless the name text also appears as a label).
• Creating duplicate names because you did not notice the range already exists in the Name Box list.
• Forgetting Match entire cell contents when short codes appear inside longer strings.

Practice until Ctrl+F, Ctrl+H, Ctrl+G, and the Name Box feel automatic. On MO-210, navigation is rarely the whole project—it is the gateway that lets you finish the scored edits on time.