Administration and Executive AssistantTier 012 minbeginner

Alignment and Wrap Text

Line up a text-stored asset tag with the real numbers beside it, and make a long header fully readable.

What you will learn

• Apply horizontal alignment so a text value lines up visually with numeric values beside it
• Apply wrap text and vertical alignment so a long header is fully readable, not truncated
• Explain why a value stored as text left-aligns by default even when it looks numeric

Excel skills

Horizontal Alignment, Wrap Text · Cell Formatting

The task

This asset list has a tag number stored as text next to a numeric quantity, and a header too long for its column. Right-align the first tag (A2) so it lines up with the numbers beside it, and wrap and vertically centre the header (B1) so it is fully readable.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free