MO-210 · Topic 2 Data Cells and Ranges Mission Lab

1 · Observe

2 · Build

3 · Execute

4 · Verify

Formatting · Office Canvas

1

X

Regional_Service_Performance.xlsx · Excel

—□×

FileHomeDataFormulas

Font

Number

Alignment

G2:G8

fx

Estimated Cost selected

Formatting · Best Path

Home → Clipboard → Format PainterCtrl+C → Ctrl+V

Formatting · Navigation Path

Formatting · Single Path

Home → Editing → Clear → Clear FormatsClear AllDelete Cells

Formatting · Mission Simulation

Wrap Text

Named Ranges · Text Response

Named Ranges · Multiple Path

Formulas → Defined Names → Name ManagerCtrl + F3Status Bar → Name Manager

Named Ranges · Best Decision

WorkbookCurrent worksheetActive cell only

Named Ranges · Navigation Path

Named Ranges · Mission Simulation

Sort & Filter · Office Canvas

Sort & Filter

Outline

Sort & Filter · Best Path

Status filter → Clear Select All → select Open

Sort & Filter · Guided Simulation

Sort

Sort & Filter · Multiple Response

Clear FilterReapplyDelete filtered-out rowsCustom Filter

Sort & Filter · Mission Simulation

Conditional Formatting · Navigation Path

Conditional Formatting · Visual Response

▉ Data Bars

Data Bars

Greater Than

Highlight Cells

🟢 🟡 🔴

Icon Sets

Duplicates

Duplicate Values

Conditional Formatting · Best Decision

Conditional Formatting → Manage RulesFormat PainterName Manager

Conditional Formatting · Formula Response

Conditional Formatting · Open Simulation

Project 2 · Service Operations05:00

0%

Microsoft Office Specialist Preparation Series

Certificate of Completion

This certifies that

has successfully completed

MO-210 · Topic 02

Manage Data Cells and Ranges

Completed a practical Microsoft Excel workplace mission involving professional cell and range formatting, defined names, multi-level sorting, filtering, and conditional formatting for exception review.

Skills Demonstrated

Cell and Range Formatting · Named Ranges · Multi-Level Sorting · Data Filtering · Conditional Formatting · Data Integrity Review

Mission Score: —Checkpoint Score: —Practice Activities: —Estimated Learning Time: 30 minutesCompletion Date:

Juan CarballoMicrosoft Office Specialist Master Instructor