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.