Challenge 2: The Four Cell Content Types — Solution Walkthrough

1. Click cell A1, type Total, press Enter.
2. Click cell A2, type 250, press Enter.
3. Click cell A3, type today's date (e.g. 7/28/2026), press Enter.
4. Click cell A4, type =100+50, press Enter.

Expected result and explanation:

A1 ("Total") — recognized as TEXT, because Excel can't interpret it
as a number, date, or formula. Displays LEFT-aligned by default, and
appears exactly as typed with no calculation performed on it.

A2 (250) — recognized as a NUMBER. Displays RIGHT-aligned by default
— this right-alignment is Excel's own visual signal that a cell
holds something it considers numeric and can do arithmetic with.

A3 (today's date) — recognized as a DATE. Also displays right-
aligned, because underneath the readable date format, Excel actually
stores it as a plain serial number (a count of days since a fixed
starting point). This is exactly why dates behave numerically — they
can be added, subtracted, and sorted chronologically — while still
displaying in a human-readable format.

A4 (=100+50) — recognized as a FORMULA, because it starts with an
equals sign. The cell does NOT display "=100+50" — it displays the
calculated result, 150, right-aligned like any other number. The
formula text itself only becomes visible again by clicking the cell
and looking at the formula bar above the grid.

Notes:
- The right-alignment vs. left-alignment default is a genuinely
  useful at-a-glance signal once a worksheet has many columns of
  mixed content — numeric-looking columns should visually line up
  on the right if they're actually being treated as numbers.
- If A2 or A3 unexpectedly appear LEFT-aligned, that's a strong sign
  Excel interpreted the entry as text rather than a real number or
  date (often caused by an extra space or an unrecognized date
  format) — worth immediately investigating rather than ignoring.