MO-210 · Topic 3 Manage Tables and Table Data

1 · Create

2 · Modify

3 · Style

4 · Analyze

Workplace Decision

Best Path Response

Ctrl + TInsert → Table

Dialog Simulation

Create Table

Where is the data for your table?

My table has headers

Visual Style Gallery

Dark 4

Dark 7

Medium 18

Medium 21

Navigation Path Challenge

Single Path Response

Formula Response

Range Response

$A$1:$J$40$A$2:$J$40$A$1:$H$25

Text Response

Guided Simulation

Total Row

Visual Style Gallery

Dark 4

Dark 7

Medium 18

Medium 21

Control State

Banded Rows

Control State

Banded Columns

Multiple Path Response

First ColumnLast ColumnHeader Row

Best Path Response

Table Design → Table Styles → ClearConvert to Range

Filter Menu Simulation

Custom Filter

Single Path Response

Filter by Color → Cell Color → YellowFilter by Color → Font Color → YellowText Filters → Contains Yellow

Professional Reasoning

Open Simulation · Level 4

Project 3 · Municipal Service Requests10:00

0%

Microsoft Office Specialist Preparation Series

Certificate of Completion

This certifies that

has successfully completed

MO-210 · Topic 03

Manage Tables and Table Data

Completed a practical Microsoft Excel workplace mission involving table creation, structural modification, table style options, value and color filtering, Total Row functions, and reliable table summaries.

Skills Demonstrated

Create & Format Tables · Modify Table Structure · Table Style Options · Sort & Filter Table Data · Total Row · SUBTOTAL-Based Summaries

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

Juan CarballoMicrosoft Office Specialist Master Instructor