ExamFinch.com My Study

Study guide

Merge, Alignment, Orientation, Indentation, Wrap Text

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

Merge, Alignment, Orientation, Indentation, Wrap Text

Key Takeaways Explain This Topic AI

Home > Merge & Center offers Merge & Center, Merge Across, Merge Cells, and Unmerge Cells — pick the option that matches the prompt wording

Horizontal and vertical alignment live in the Home > Alignment group and on the Alignment tab of Format Cells (Ctrl+1)

Orientation rotates or stacks text (degrees or vertical); Increase/Decrease Indent offsets content from the cell edge

Wrap Text displays long labels on multiple lines inside a cell; pair it with taller row height or AutoFit Row Height when text is clipped

MO-210 tasks describe outcomes (center a title across columns, wrap product names) — verify the final look, not only that you clicked a button

Last updated: August 2026

Merge, Alignment, Orientation, Indentation, Wrap Text

Quick Answer: On MO-210, formatting cells for readability means merging or unmerging ranges, setting horizontal/vertical alignment , applying orientation and indentation , and turning on Wrap Text so long labels show fully without widening every column.

Certiport's MO-210 Objective Domain lists these under Format cells and ranges . Performance tasks give short instructions such as "Merge and center the title across A1:F1" or "Wrap the text in column B and center it vertically." Ribbon paths on the Home tab's Alignment group are usually enough; use Format Cells (Ctrl+1) when you need precise orientation degrees or several alignment settings at once.

Why Alignment Skills Matter on the Exam

Associate-level workbooks are judged on presentation as well as formulas. A sales title that sits in A1 while columns B–F look empty fails a "merge and center the title" task even if the data below is perfect. Practice reading every adjective in the prompt: merge and center , merge across , wrap , indent twice , and rotate 90 degrees are different commands.

Merge and Unmerge Cells

Select the cells to combine, then open Home > Merge & Center (split button). The gallery contains four related actions:

Command What it does Typical MO-210 wording

Merge & Center Merges the selection into one cell and centers the content horizontally "Merge and center the title across A1:G1"

Merge Across Merges cells row by row within the selection (each row becomes its own merged block) "Merge across the selected rows" / multi-row banners

Merge Cells Merges into one cell without forcing center alignment "Merge the cells" when centering is not requested

  • Unmerge Cells Splits a merged area back into individual cells "Unmerge the title cell"
  • Merge behavior traps

Only the upper-left cell's value is kept when you merge a range that already has data in multiple cells. Other values are discarded (Excel may warn you). If a task says values were lost, you selected the wrong range or merged too early.

Merge Across is not the same as Merge & Center on a multi-row block. If you select A1:F3 and choose Merge & Center, you get one large cell. Merge Across gives three merged rows (A1:F1, A2:F2, A3:F3).

Merged cells can interfere with sorting, filtering, and some paste operations. On the exam, merge when asked; do not "improve" a sheet by merging headers the prompt never mentioned.

To unmerge, select any cell inside the merged area (or the whole area) and choose Unmerge Cells . After unmerging, only the upper-left cell retains the text; re-enter or copy content if the task expects labels in every former cell.

Horizontal and Vertical Alignment

Alignment controls where content sits inside the cell boundaries.

Horizontal (Home > Alignment icons, or Format Cells > Alignment):

  • Option Effect
  • Align Left Content flush to the left (default for text)
  • Center Centers horizontally in the cell or merged area
  • Align Right Content flush to the right (common for numbers you leave as General)
  • General Excel's default: text left, numbers/dates right
  • Center Across Selection Visually centers across selected cells without merging (Format Cells)

Vertical options matter when row height is taller than one line of text:

  • Option Effect
  • Top Align Content at the top of the cell
  • Middle Align Centers vertically
  • Bottom Align Content at the bottom (Excel's default for many cells)

On MO-210, "center the heading" usually means horizontal Center (often with Merge & Center). "Center vertically" or "middle-align" points to Middle Align — especially after you increase row height or wrap text.

Center Across Selection vs Merge & Center

Center Across Selection (Format Cells > Alignment > Horizontal) centers a label across highlighted cells but leaves each cell separate for sorting and selection. Merge & Center physically combines cells. If the prompt says merge , use merge. If it says center across without merge language, prefer Center Across Selection.

Orientation (Rotate Text)

Orientation angles or stacks text so narrow columns can still show long headers.

Ways to set it:

Home > Orientation gallery — Angle Counterclockwise, Angle Clockwise, Vertical Text, Rotate Text Up/Down, and Format Cell Alignment.

Format Cells > Alignment — drag the orientation dial or type a precise degree (for example, 45 or 90).

  • Setting Common use
  • 45° / Angle Counterclockwise Diagonal column headers over a wide table
  • 90° / Rotate Text Up Tall, narrow header columns
  • Vertical Text Stacks letters vertically in the cell

After rotating, you may need to AutoFit row height or widen columns so the full header is visible. Orientation does not replace Wrap Text; use wrap for multi-word paragraph-style labels inside a normal horizontal cell.

Indentation

Increase Indent and Decrease Indent on the Home > Alignment group offset content from the left edge (or from the right when right-aligned in some layouts). Each click adds one indent level.

Exam patterns:

Indent subcategory labels under a category heading in a outline-style list.

Indent twice when the prompt says "indent the selected cells two levels."

Do not use extra spaces typed in the cell to fake indentation — graders and later formulas expect the Indent format setting.

You can also set indent on Format Cells > Alignment > Indent spinner for an exact level in one step.

Wrap Text

Home > Wrap Text (toggle) lets long content break onto multiple lines inside the same cell instead of spilling over or getting cut off.

Workflow that matches typical tasks:

Select the cell or column.

Turn Wrap Text on.

If only the first line shows, AutoFit Row Height (double-click the bottom border of the row number, or Home > Format > AutoFit Row Height) or set a taller Row Height manually.

Optionally set vertical alignment to Top or Middle so wrapped blocks look intentional.

Wrap Text vs Shrink to Fit vs Merge

  • Feature Keeps one cell? Best when
  • Wrap Text Yes Multi-line labels, comments, product names
  • Shrink to Fit (Format Cells) Yes Force content to stay on one line by reducing font size
  • Merge & Center No (combines cells) Titles spanning several columns

Do not enable Shrink to Fit when the prompt asks to wrap. Do not merge a whole data column just to show long text — wrap the column instead.

Exam Scenario Walkthrough

Prompt: On the Report sheet, merge and center A1:F1 for the title. In A3:A10, wrap the text and middle-align vertically. Indent B4:B10 one level. Rotate the headers in C2:F2 to 45 degrees. Unmerge any merged cells in row 12.

Suggested path:

Select A1:F1 → Home > Merge & Center.

Select A3:A10 → Wrap Text → Middle Align; AutoFit row heights if needed.

Select B4:B10 → Increase Indent once.

Select C2:F2 → Home > Orientation > Format Cell Alignment (or Format Cells) → set 45°; adjust row height so headers are fully visible.

Select the merged area in row 12 → Merge & Center > Unmerge Cells.

Completing this cluster covers merge/unmerge, alignment, orientation, indentation, and wrap text — the first half of Certiport's Format cells and ranges skill set.