Excel cell formatting practice exercises
5 graded problems with realistic data, from medium to hard.
Not a function, direct styling. Bold, fill color, and number format change how a value reads, never what it is or what it calculates to. The 5 exercises below come from LearnExcel's practice library. Each one gives you a realistic table, a cell to fill, and a hint if you get stuck. Read them here, then solve them in the interactive grid, where your formula is checked the moment you press Enter.
New to the function? Read the Cell formatting guide first: syntax, a worked example and the mistakes people make.
In this set
- Bold the header row
- Fill the header row
- Format a column as Currency
- Format a column as Percent
- Bold and fill a header, together
The exercises
This expense summary needs a bold header row so it's obvious at a glance which row is labels, not data. Bold A1:B1.
| A | B | |
|---|---|---|
| 1 | Category | Amount |
| 2 | Rent | 1200 |
| 3 | Utilities | 340 |
| 4 | Supplies | 180 |
Apply the formatting.
Show a hint
Select A1:B1 (click A1, then drag to B1), then click the Bold button.
A bold header row is the simplest thing that makes a plain data dump read like a real table.
Give the header row a light gray fill so it reads as a header at a glance, even before anyone reads the words.
| A | B | |
|---|---|---|
| 1 | Team | Headcount |
| 2 | Sales | 12 |
| 3 | Support | 8 |
| 4 | Engineering | 21 |
Apply the formatting.
Show a hint
Select A1:B1, then click the gray fill swatch.
Fill color is the fastest visual separator between a header and the data underneath it. No bold or borders required.
Format the Amount Due column (B2:B4) as Currency so it reads like a real invoice, not raw numbers.
| A | B | |
|---|---|---|
| 1 | Client | Amount Due |
| 2 | Nova Retail | 1240 |
| 3 | Bright Path | 2100 |
| 4 | Delta Freight | 1750 |
Apply the formatting.
Show a hint
Select B2:B4, then choose Currency from the Number format dropdown.
Currency formatting doesn't change the underlying number. A SUM over this column still adds 1240, not "$1,240.00." It only changes how the value displays.
Format the Growth column (B2:B5) as Percent so a negative quarter reads as a dip, not just a small negative number.
| A | B | |
|---|---|---|
| 1 | Quarter | Growth |
| 2 | Q1 | 5 |
| 3 | Q2 | 8 |
| 4 | Q3 | -2 |
| 5 | Q4 | 12 |
Apply the formatting.
Show a hint
Select B2:B5, then choose Percent from the Number format dropdown.
A growth-rate table is unreadable as bare numbers. Percent formatting turns 5 into 5% at a glance.
Finish this table the way a real dashboard header looks: bold the header row AND give it a blue fill.
| A | B | C | |
|---|---|---|---|
| 1 | Region | Rep | Sales |
| 2 | West | Maya | 18400 |
| 3 | East | Owen | 15200 |
Apply the formatting.
Show a hint
Select A1:C1, click Bold, then click the blue fill swatch. Both properties apply to the same selection.
Real dashboards usually stack more than one formatting property on a header. Bold alone often isn't enough contrast, so bold plus a fill color is the standard combo.
Solve these in a real grid
Type your formula, get graded instantly. Your first 10 exercises are free, no signup.
Start the Cell formatting exercises →