ExamFinch.com My Study

Study guide

Number Formats, Format Painter, Format Cells Dialog

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

Number Formats, Format Painter, Format Cells Dialog

Key Takeaways Explain This Topic AI

Format Painter copies formatting only (not values); single-click paints once, double-click locks painter until you press Esc

Apply common number formats from Home > Number (Accounting, Percent, Comma, Increase/Decrease Decimal) or the Number Format gallery

Format Cells (Ctrl+1) exposes the full Number tab categories: Number, Currency, Accounting, Date, Time, Percentage, Fraction, Scientific, Text, Special, and Custom

Accounting lines up currency symbols and decimals; Currency places the symbol next to the value — MO-210 prompts often specify which one

in a cell usually means the column is too narrow for the formatted number — widen or AutoFit the column rather than deleting the value

Last updated: August 2026

Number Formats, Format Painter, Format Cells Dialog

Quick Answer: MO-210 expects you to copy formatting with Format Painter , apply number formats from the Home ribbon, and use the Format Cells dialog (Ctrl+1) when a task needs a specific category, decimal places, date pattern, or custom code.

These skills sit under Format cells and ranges beside merge and styles. Number formats change how values display ; they do not permanently alter the underlying stored number unless you convert to text or paste values. Knowing that distinction prevents "fixing" a problem by retyping data.

Format Painter

Format Painter (Home > Clipboard) copies formatting from a source cell or range and applies it elsewhere.

  • Action Behavior
  • Select source → click Format Painter → click or drag destination Paints once , then turns off

Select source → double-click Format Painter → paint multiple ranges Stays on until you click Format Painter again or press Esc

  • What is copied Font, fill, borders, alignment, number formats, and similar cell formatting
  • What is not copied Cell values, formulas, or comments/notes content
  • Exam tips for Format Painter

If the prompt says "apply the same formatting as cell A1 to B2:B20," Format Painter is usually faster than redoing each setting.

Painter does not replace Paste Special > Formats , which is another valid path after Copy. Either approach is acceptable when the outcome matches.

Double-click when you must format several noncontiguous areas (title, totals row, and a side panel) without reselecting the source each time.

After painting, confirm number formats transferred — a currency source should leave currency destinations, not just bold/fill.

Apply Number Formats from the Ribbon

On Home > Number , the most common Associate controls are:

Control Typical result

Number Format dropdown General, Number, Currency, Accounting, Short/Long Date, Time, Percentage, Fraction, Scientific, Text, and More Number Formats…

  • Accounting Number Format ($) Accounting style with currency symbol and aligned decimals
  • Percent Style (%) Multiplies the displayed value by 100 and adds % (0.15 → 15%)
  • Comma Style Thousand separators with two decimal places (similar to Accounting without a currency symbol)
  • Increase Decimal / Decrease Decimal Adds or removes decimal places on the current format
  • Percentage caution

If a cell already shows 15 and you click Percent Style, Excel treats 15 as 1500%. Enter 0.15 (or 15%) before or after applying the format carefully. Tasks that say "format as a percentage" usually assume the underlying values are already fractional (0.15) or already entered with % .

Dates and times

Dates are serial numbers formatted to look like dates. Applying Short Date or Long Date from the gallery (or Date category in Format Cells) changes display. If a "date" is left-aligned text, number formats will not convert it until you enter a real date value.

Format Cells Dialog Box

Open Format Cells with Ctrl+1 , right-click > Format Cells, or Home > Number dialog launcher / More Number Formats…

Tabs you will use on MO-210:

  • Tab Purpose
  • Number Category, decimal places, symbol, sample preview
  • Alignment Horizontal/vertical, wrap, shrink, indent, orientation, merge
  • Font Typeface, size, color, underline, effects
  • Border Line style and presets
  • Fill Background color/pattern
  • Protection Locked/Hidden (relevant when sheet protection is on)
  • Number tab categories to know
  • Category Use when the prompt asks for
  • General Default; Excel decides based on entry
  • Number Decimals, thousand separator, negative number styles
  • Currency Symbol immediately beside the value; choose symbol and decimals
  • Accounting Currency symbol at the cell edge, decimals aligned in the column
  • Date / Time Specific display patterns (for example, 14-Mar-2026)
  • Percentage Percent display with set decimal places
  • Fraction Display as fractions
  • Scientific Scientific notation
  • Text Treat cell contents as text (handy for leading zeros such as ZIP codes when Special is not used)
  • Special Zip Code, Phone Number, Social Security Number (locale-dependent)
  • Custom Type a format code when built-in categories are not enough
  • Currency vs Accounting (frequent trap)

Both show money, but layout differs:

Currency: $1,234.50 with the dollar sign adjacent to the digits.

Accounting: $ aligned left in the cell and 1,234.50 aligned so decimals line up down the column; zeros may display as a dash depending on settings.

If the prompt says Accounting format, use Accounting Number Format or Format Cells > Accounting — not the Currency category. Graders compare the applied format, not approximate appearance.

Custom formats (awareness level)

Associate tasks may open Custom for a simple code (for example, showing a trailing unit or a specific date pattern). You do not need advanced custom-format mastery, but you should know Custom lives on the Number tab and that the Sample box previews the active cell.

When You See

A cell filled with #### usually means the column is too narrow to display the formatted number or date — not that the value was deleted. Fix it by:

  • Double-clicking the column's right boundary ( AutoFit Column Width ), or
  • Dragging the column wider, or

Home > Format > Column Width / AutoFit Column Width.

Do not clear the cell. Applying a shorter format (fewer decimals) can also help, but AutoFit is the first response on most exam tasks.

Combining Format Painter with Number Formats

Efficient project workflow:

Format one model cell completely in Format Cells (Accounting, 2 decimals, bold, border).

Use Format Painter (or Paste Special > Formats) to spread that look to the rest of the money column.

Use Increase/Decrease Decimal only if a subset needs a different precision.

This beats manually opening Format Cells on every range and reduces missed settings under time pressure.

Exam Scenario Walkthrough

Prompt: Format D2:D50 as Accounting with the $ symbol and two decimal places. Format E2:E50 as a percentage with one decimal place. Copy the formatting from A1 to A2:A10 with Format Painter. Open Format Cells and apply the Special Zip Code format to column H. AutoFit any column that shows ####.

Select D2:D50 → Home > Accounting Number Format (confirm two decimals; adjust with Increase/Decrease Decimal if needed).

Select E2:E50 → ensure values are fractional → Percent Style → Decrease/Increase Decimal to one place.

Select A1 → Format Painter → drag A2:A10.

Select column H → Ctrl+1 → Number > Special > Zip Code → OK.

AutoFit any #### columns.

That sequence demonstrates Format Painter, ribbon number formats, and Format Cells dialog formatting — the second cluster of Domain 2 cell-formatting objectives.