ExamFinch.com My Study

Study guide

Cell Styles, Clear Formatting, Group Worksheets

Practice this exam

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

Cell Styles, Clear Formatting, Group Worksheets

Key Takeaways Explain This Topic AI

Home > Cell Styles applies built-in style sets (Normal, Heading, Title, Good/Bad/Neutral, Input/Output, Currency, Percent, and themed styles) in one click

Clear Formats removes formatting but keeps values and formulas; Clear Contents removes values/formulas but keeps formatting; Clear All removes both

Group worksheets by Ctrl-clicking or Shift-clicking sheet tabs so formatting (and many edits) apply to every sheet in the group

Always ungroup sheets when finished — a [Group] indicator on the title bar means changes still hit every grouped sheet

MO-210 may combine styles, clear, and grouping in one project: style a header, clear bad formatting, then format identical ranges across grouped monthly sheets

Last updated: August 2026

Cell Styles, Clear Formatting, Group Worksheets

Quick Answer: Finish MO-210 cell formatting by applying Cell Styles for consistent looks, using Clear commands to remove the right kind of content or formatting, and grouping worksheets so identical formatting applies across multiple sheets — then ungroup so later edits stay local.

These three skills complete Certiport's Format cells and ranges objective. They are presentation and workbook-structure skills: styles standardize appearance, Clear fixes mistakes without wrecking data (or vice versa), and grouping multiplies your work across January–December sheets in one action.

Apply Cell Styles

Open Home > Styles > Cell Styles (gallery). Built-in styles package font, fill, border, and number-format settings under a named look.

Common style groups you will see in Microsoft 365 Excel:

  • Group Examples Typical use
  • Good, Bad, and Neutral Good, Bad, Neutral Status highlighting without building conditional formatting rules

Data and Model Input, Output, Calculation, Check Cell, Warning Text Distinguish editable inputs from formula outputs

  • Titles and Headings Title, Heading 1–4 Sheet titles and section headers
  • Themed Cell Styles 20%/40%/60% Accent fills Color-coordinated report blocks matching the workbook theme
  • Number Currency, Currency [0], Percent, Comma Quick consistent number looks
  • How to apply and modify styles

Select the target cell or range.

Home > Cell Styles → click the style name.

To change what a style means, right-click a style > Modify… (updates cells already using that style if you change the style definition carefully).

New Cell Style… creates a custom style from the active cell's formatting — useful in real work; Associate prompts more often use built-in names.

Styles vs Format Painter vs manual formatting

  • Tool Best when
  • Cell Styles Prompt names a style or you need a consistent named look across many areas
  • Format Painter Copy an existing cell's look to another range quickly
  • Format Cells / ribbon Prompt specifies exact font size, border, or number category without naming a style

If the task says "apply the Heading 1 cell style to A1," use the Cell Styles gallery — do not approximate with bold + larger font alone unless no style is mentioned and the visual outcome is clearly equivalent (named styles are safer when specified).

Applying Normal returns cells toward the default workbook style, which can undo ad-hoc formatting in one step when you need a clean slate short of Clear Formats.

Clear Cell Formatting (and Related Clear Commands)

On Home > Editing > Clear (eraser icon), know the differences:

  • Command Removes Keeps
  • Clear All Everything in the cells: values/formulas, formatting, comments/notes, hyperlinks Empty cells

Clear Formats Formatting only (font, fill, borders, number formats, alignment, styles) Values, formulas, comments

  • Clear Contents Values and formulas Formatting, comments
  • Clear Comments and Notes Annotations only Values and formats

Clear Hyperlinks Hyperlinks (options to keep/remove display text depending on build) Underlying values as appropriate

MO-210 reading precision

"Clear formatting from the range" → Clear Formats .

"Clear the cell contents" → Clear Contents (or Delete/Backspace on the selection).

"Clear all" / remove everything from the cells → Clear All .

Choosing Clear All when the prompt only wanted formats wiped will delete data and fail the task. Choosing Clear Contents when you meant to remove a loud red fill leaves the bad fill in place.

Keyboard awareness: Delete clears contents of selected cells (like Clear Contents for values/formulas) but does not strip formatting. That is why a "cleared" cell can still show Accounting format when you type the next number.

Format Multiple Worksheets by Grouping

Grouping lets one formatting action apply to the same cell addresses on every sheet in the group.

How to group

  • Goal Method
  • Group adjacent sheets Click first tab, Shift+click last tab
  • Group nonadjacent sheets Click first tab, Ctrl+click each additional tab
  • Group all sheets Right-click a tab > Select All Sheets

Ungroup Right-click a grouped tab > Ungroup Sheets , or click any sheet tab outside the group (behavior can ungroup the set)

While grouped, the Excel title bar typically shows [Group] after the workbook name. Treat that indicator as a warning light.

What grouping is good for on the exam

Apply the same bold header , column widths , number formats , or cell styles to Jan, Feb, and Mar sheets in one step.

Enter the same label in A1 on all grouped sheets.

Set the same print-oriented formatting across identically structured monthly reports.

Grouping risks (avoid these)

Typing in A1 while sheets are grouped writes to A1 on every grouped sheet — disastrous if only one sheet should change.

Deleting a row or clearing a range while grouped deletes/clears it on all grouped sheets.

Forgetting to ungroup before the next task is a classic MOS mistake: later "fixes" actually corrupt other sheets.

Practical exam sequence

Confirm all target sheets share the same layout (same columns and header rows).

Group the sheets.

Select the range (for example, A1:F1) and apply Cell Styles, number formats, or alignment.

Ungroup immediately .

Spot-check one non-active sheet to verify the format landed, then return to the sheet named in the next prompt.

Grouping does not permanently link sheets; it is a temporary editing mode. After ungrouping, sheets remain independently editable with the formatting you applied while grouped.

Combining Styles, Clear, and Grouping

Real project files often need cleanup before polish:

Clear Formats on a messy import range that has random fonts.

Apply Heading 1 / Title styles to headers.

Apply Currency or Comma styles (or Accounting number format) to amount columns.

Group Q1 sheets and apply the same header style to A1:G1 on all three; ungroup.

That workflow matches how managers expect consistent workbooks and how MO-210 projects layer multiple Domain 2 skills in one file.

Exam Scenario Walkthrough

Prompt: Clear formatting from B2:B30 but keep the values. Apply the Heading 2 cell style to A1 on Sheet1. Group Sheet1, Sheet2, and Sheet3, apply Accounting format to D2:D20 on the group, then ungroup. Verify Sheet2 shows Accounting in D2:D20 and that Sheet4 was not changed.

Select B2:B30 → Home > Clear > Clear Formats.

Select A1 → Home > Cell Styles > Heading 2.

Ctrl-click (or Shift-click if adjacent) Sheet1–Sheet3 tabs until [Group] appears.

Select D2:D20 → Accounting Number Format.

Right-click a grouped tab > Ungroup Sheets (or click Sheet4 to leave the group, then confirm Sheet1–3 are ungrouped).

Check Sheet2 D2:D20 for Accounting; confirm Sheet4 unchanged.

Mastering styles, Clear Formats versus Clear Contents/All, and safe grouping/ungrouping completes the Format cells and ranges Domain 2 skill area for MO-210.