About this exercise
A 52-row dataset on one sheet, 2 answer cells, about 4 minutes. Graded in your browser: the value and the formula behind it, with feedback that names the fix.
How to solve it
Merge & Center joins the selected cells into a single cell that spans A to F and centers its content, so the title sits over the whole table instead of spilling out of A1. Wrap Text tells Excel to break a cell's text onto additional lines inside the cell and increase the row height, so long captions stay readable in narrow columns. Neither command changes the data: the title still lives in A1 and the captions still live in row 3.
Pitfall 1: merged cells break sorting, filtering, Ctrl+Shift+arrow selection and formulas that reference the range — merge titles, never cells inside a data table. For a table-wide title that stays sortable, use Center Across Selection (Format Cells → Alignment → Horizontal) which looks identical without merging. Pitfall 2: Merge & Center keeps only the upper-left value; if B1:F1 held data it would be deleted (Excel warns). Pitfall 3: Wrap Text does not grow a row whose height was set manually — double-click the row boundary to autofit, or Home → Format → AutoFit Row Height. Alternatives: Alt+Enter (Mac: ⌃⌥Return) inserts a manual line break at the exact point you want; Shrink to Fit scales the font down instead of wrapping. Screen readers and exports (CSV, Power Query) treat merged cells badly; keep merges to print-oriented title rows.
Other ways that work
- Format Cells → Alignment → Horizontal: Center Across Selection on A1:F1 — same look, no merge, keeps the table sortable
- Alt+Enter (⌃⌥Return on Mac) inside a caption — manual line breaks at the exact point, automatically turns Wrap Text on for that cell
- Home → Format → AutoFit Row Height after wrapping — if the row did not grow by itself
Common mistakes
Widening columns until the captions fit. It works for one screen but ruins the layout for printing and makes the table scroll sideways; Wrap Text keeps the columns narrow and the labels complete.
How we grade
Any formula that produces the right result is accepted, unless the task names a function: then another function earns half credit. We compare values with a small tolerance and ignore case and spaces in text. A correct number typed by hand instead of a formula earns half credit. Multi-cell tasks earn full credit at 100% of cells, half credit from 50%. Where it matters, we also change an input cell on a copy of your sheet and check that your formula follows.
Answers computed with Excel 365 rules and checked in our grading engine on November 15, 2026. Author: GridBelt team.