MO-210 · Topic 1 · 20 Activities Mission Lab

1 · Observe

2 · Navigate

3 · Execute

4 · Verify

Office Canvas · Knowledge Simulation

1

X

Quarterly_Operations.xlsx · Excel

—□×

FileHomeInsertPage LayoutFormulasDataReviewView

Clipboard

Font

Alignment

Styles

D4

fx

=SUM(B4:C4)

A

B

C

D

E

F

G

1

Region

Q1

Q2

Total

Target

Variance

2

North

48,500

52,900

101,400

100,000

1,400

3

South

46,200

49,750

95,950

98,000

-2,050

4

West

55,300

57,100

112,400

110,000

2,400

5

ReadyAccessibility: Good to go▦ ▤　− ━━━●━━ ＋　100%

Best Path Response

Home → Cells → Insert → Insert Sheet

Navigation Path Challenge

Guided Simulation · Level 2

Select a tab.

Formula / Text Response

Multiple Path Response

View → Window → Freeze Panes → Freeze Top RowAlt, W, F, R

Workplace Decision

File → Info → Check for Issues → Inspect DocumentFile → Info → Protect Workbook → Mark as Final

Mission Simulation · Level 3

A

B

C

D

E

F

1

Employee

Hours

Rate

Gross

Tax

Net

Single Path Response

Page Break PreviewPage LayoutNormal

Open Simulation · Level 4

Single Path Response

Ctrl + NCtrl + OCtrl + S

Best Path Response

Excel Workbook (*.xlsx)CSV UTF-8 (*.csv)Text (*.txt)

Multiple Path Response

F5Ctrl + G

Knowledge Response

CtrlShiftAlt

Best Path Response

Home → Font ColorPage Layout → Themes

Navigation Path Challenge

Workplace Decision

Review → Protect Workbook → StructureReview → Protect SheetMark as Final

Single Path Response

Page Layout → Print Titles → Rows to repeat at topView → Freeze Top RowInsert → Header & Footer

Best Professional Decision

Width: 1 page · Height: AutomaticFit Sheet on One PageZoom 200%

Open Simulation · Level 4

Project 1 · Regional Operations05:00

0%

Microsoft Office Specialist Preparation Series

Certificate of Completion

This certifies that

has successfully completed

MO-210 · Topic 01

Manage Worksheets and Workbooks

Completed a practical Microsoft Excel workplace mission involving worksheet and workbook creation, navigation, organization, workbook settings, protection, collaboration readiness, and professional print preparation.

Skills Demonstrated

Create & Manage Worksheets/Workbooks · Navigate & Organize Worksheets · Configure Workbook Settings · Workbook Protection · Collaboration Readiness · Printing & Distribution

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

Juan CarballoMicrosoft Office Specialist Master Instructor