Study guide

Search and Navigate to Named Cells, Ranges, Elements

Microsoft Excel Microsoft 365 Apps

Track your progress as you read

Finished sections get a check mark.

1 Introduction & Exam Overview

About the MO-210 Exam Performance-Based Exam Strategy

2 Import Data & Navigate Workbooks

Import Data from Text Files Import Data from Online Sources Search and Navigate to Named Cells, Ranges, Elements Insert and Remove Hyperlinks

3 Format Worksheets, Views & Collaboration

Page Setup, Headers, Footers, Row Height & Column Width Quick Access Toolbar, Views, Freeze Panes, Properties, Display Formulas Print Area, Export Formats, Print Settings, Inspect, Comments & Notes

4 Manipulate Data in Worksheets

Paste Special and Auto Fill Insert and Delete Rows, Columns, and Cells Generate Numeric Data with RANDBETWEEN and SEQUENCE

5 Format Cells and Ranges

Merge, Alignment, Orientation, Indentation, Wrap Text Number Formats, Format Painter, Format Cells Dialog Cell Styles, Clear Formatting, Group Worksheets

6 Named Ranges & Visual Summaries

Define and Reference Named Ranges Insert and Manage Sparklines Apply and Remove Conditional Formatting

7 Create and Format Tables

Create Excel Tables from Cell Ranges Apply Table Styles and Convert Tables to Ranges Add or Remove Table Rows and Columns

8 Table Options, Filter & Sort

Configure Table Style Options Insert and Configure Total Rows Filter Table Records Sort Data by Multiple Columns

9 Formula References

Relative, Absolute, and Mixed References Structured References in Tables

10 Calculate and Transform Data

SUM, AVERAGE, MIN, and MAX COUNT, COUNTA, and COUNTBLANK Conditional Operations with IF SORT and UNIQUE Functions

11 Format and Modify Text

LEFT, RIGHT, and MID UPPER, LOWER, LEN, CONCAT, and TEXTJOIN

12 Create Charts

Create Charts from Data Create Chart Sheets

13 Modify and Format Charts

Add Data Series and Switch Rows/Columns Add and Modify Chart Elements Chart Layouts, Styles, and Alternative Text

Search and Navigate to Named Cells, Ranges, Elements

Key Takeaways Explain This Topic AI

Ctrl+F opens Find; use Find All, Within Sheet/Workbook, and options like Match case to locate values quickly

Ctrl+G or F5 opens Go To; Go To Special jumps to blanks, constants, formulas, visible cells, and other element types

The Name Box left of the formula bar selects named ranges and accepts typed addresses like Sheet2!B12

Defined names appear in the Name Box drop-down; choosing a name selects that range even on another sheet

Workbook element navigation includes jumping to sheets, tables, and chart objects named or listed in Go To / selection panes

Last updated: August 2026

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:

  • Control Use on the exam
  • Find what Exact text, number, or partial string to locate
  • Within Sheet vs Workbook—use Workbook when the value might be on another sheet
  • Search By rows or by columns
  • Look in Formulas, Values, or Notes/Comments depending on what you must match
  • Match case When the task specifies capitalization
  • Match entire cell contents When you must find NY but not NYC
  • Find All Lists every hit; click a row in the list to jump there
  • Replace / Replace All Change spellings, codes, or labels in bulk when instructed
  • 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:

Accepts a typed address or range ( G15 , A1:D10 , Sheet3!C5 )—press Enter to select it.

Lists defined names in its drop-down arrow.

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 :

Click the Name Box drop-down.

Choose the name the task mentions.

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

  • Goal Fastest tool
  • Jump to cell M100 Name Box or Ctrl+G
  • Jump to named range KPI_Target Name Box drop-down or Go To
  • Find every "Pending" label Ctrl+F → Find All (Workbook if needed)
  • Select blank order dates Go To Special → Blanks
  • Move to next worksheet Ctrl+Page Down or sheet tab
  • Select a floating button/shape Selection Pane or Go To Special → Objects
  • 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.