Excel practice · Dashboarding

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

  1. Bold the header row
  2. Fill the header row
  3. Format a column as Currency
  4. Format a column as Percent
  5. Bold and fill a header, together

The exercises

1. Bold the header row Medium

This expense summary needs a bold header row so it's obvious at a glance which row is labels, not data. Bold A1:B1.

AB
1CategoryAmount
2Rent1200
3Utilities340
4Supplies180

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.

2. Fill the header row Medium

Give the header row a light gray fill so it reads as a header at a glance, even before anyone reads the words.

AB
1TeamHeadcount
2Sales12
3Support8
4Engineering21

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.

3. Format a column as Currency Medium

Format the Amount Due column (B2:B4) as Currency so it reads like a real invoice, not raw numbers.

AB
1ClientAmount Due
2Nova Retail1240
3Bright Path2100
4Delta Freight1750

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.

4. Format a column as Percent Medium

Format the Growth column (B2:B5) as Percent so a negative quarter reads as a dip, not just a small negative number.

AB
1QuarterGrowth
2Q15
3Q28
4Q3-2
5Q412

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.

5. Bold and fill a header, together Hard

Finish this table the way a real dashboard header looks: bold the header row AND give it a blue fill.

ABC
1RegionRepSales
2WestMaya18400
3EastOwen15200

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 →

More dashboarding practice

All Excel practice exercises · Excel test prep