Skip to content
GridBelt
  • Excel Test
  • Practice
  • Programs
  • Pricing
Sign in
Start the free test
  • Excel Test
  • Practice
  • Programs
  • Pricing
Sign inCreate account
Start the free test
GridBelt

Practice Excel in your browser.

Excel Test

  • Level 1: Beginner
  • Level 2: Intermediate
  • Level 3: Expert
  • Excel test in 7 days
  • Leaderboard
  • Excel test for interview
  • Indeed Excel assessment

Practice

  • All exercises
  • Programs
  • For beginners

Guides

  • Excel formulas
  • Excel shortcuts

Company

  • About
  • Pricing
  • How we grade

© GridBelt. All rights reserved.

  • Privacy Policy
  • Terms of Use
  • Refund Policy

Excel is a trademark of Microsoft Corporation. Indeed, TestGorilla, SHL and other marks are the property of their owners. GridBelt is an independent practice site and is not affiliated with, endorsed by or sponsored by Microsoft, TestGorilla, SHL or Indeed.

  1. Practice
  2. /
  3. Merge and wrap

Number formats practice: currency and dates on a transaction export

  • Beginner
  • ~4 min
  • Merge and wrap

An accounting system exported 100 transactions, but the file lost its formatting: the Date column shows serial numbers such as 46024 instead of dates, and amounts such as 1007.54 have no currency sign or thousands separator. The values are correct — only their display is wrong. Format B2:B101 as dates (yyyy-mm-dd) and E2:E101 as currency with two decimals so the statement can be reviewed.

What you need to do

  1. 1Select B2:B101 (click B2, then Ctrl+Shift+↓ / ⌘+Shift+↓).
  2. 2Open Format Cells (Ctrl+1 on Windows, ⌘1 on Mac), pick Date, and choose the yyyy-mm-dd pattern (under Custom if your locale does not list it). The serial numbers turn into 2026 dates.
  3. 3Select E2:E101 and apply Currency with 2 decimal places and the $ symbol — Format Cells → Currency, or Ctrl+Shift+$ (Windows) or Control+Shift+$ (Mac).
  4. 4Check: B2 now reads 2026-01-02 and the amounts show a $ sign, thousands separators and exactly two decimals.

Answer cells

Feedback

Type your formula in the grid, press Enter, then Check. We grade the value in each answer cell and the formula behind it.

Tasks

  1. Not checkedFormat the Date column B2:B101 as dates using the yyyy-mm-dd pattern.
  2. Not checkedFormat the Amount column E2:E101 as currency with two decimals and a thousands separator ($#,##0.00).

Desktop recommended for spreadsheet tasks. The sheet scrolls inside this box.

StartInsertFormulasDataView
A1fxPreparing your workbook…
A
B
C
D
E
F
G
H
I
J
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Sheet1

Enter your formula in the sheet, then check.

About this exercise

A 100-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

    Excel stores every date as a plain number — the count of days since 30 December 1899 — so 46024 and 2026-01-02 are the same value shown two ways. A number format only changes the display: applying a date format makes the serial readable, and the currency format adds the $ sign, the thousands separator and a fixed two decimals without rounding the stored amount. Because nothing was retyped, every total or lookup built on these cells keeps working.

    Pitfall 1: typing the dates in by hand or pasting them as text would turn them into strings — SUM, sorting and date arithmetic break; formats preserve the numeric values. Pitfall 2: Currency versus Accounting — Accounting aligns the $ signs on the left and shows zeros as dashes; both are "currency" to a reader, but a test that asks for the Currency format means the $ next to the number. Pitfall 3: a format with 2 decimals does not round the value; =E2*1 still carries 1234.567. Use ROUND when cents must be exact in totals. Regional settings: m/d/yyyy in the US is d/m/yyyy in the UK and most of Europe; yyyy-mm-dd (ISO 8601) is unambiguous and sorts correctly as text, which is why data teams prefer it. Shortcuts: Ctrl+Shift+# applies the default date format, Ctrl+Shift+$ the currency format, Ctrl+Shift+! the thousands format; Format Painter copies a format from one range to another.

    Other ways that work

    • Home → Number group → drop-down → Short Date / Currency — the one-click presets (then adjust decimals with the Increase/Decrease Decimal buttons)
    • Ctrl+Shift+# for dates and Ctrl+Shift+$ for currency (Windows and Mac) — keyboard-only
    • Format Cells → Custom with codes like dd-mmm-yyyy or $#,##0.00;[Red]-$#,##0.00 — when the preset is not exactly what the report needs

    Common mistakes

    Retyping the serial numbers as text dates ("2026-03-14"). Text dates look right but will not sort chronologically, cannot be subtracted and are ignored by date functions. Change the format instead.

    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.

    In these programs

    • Excel test in 7 days, Level 1 planDay 5
    • Excel test in 7 days, Level 3 planDay 2
    • Excel for Data AnalystsDay 1

    Related exercises

    • Merge and center the title; wrap header textBeginner, ~4 min
    • Share of total per region, formatted as %Beginner, ~5 min
    • Year-over-year % changeBeginner, ~4 min
    • Freeze the header row of a long exportBeginner, ~3 min

    Function reference

    Official documentation

    Next exercise

    Sort by Region, then Sales descending