What you will build
Complete “Create custom number formats” using the visible Item, Amount, Rate sample so each action and the final state can be checked against the source data.
Learning objectives
Open the practice workbook
Practice in your own copy
Make your own Google Sheets copy with the same data, formulas, formatting, filter and frozen header. The original remains unchanged.
Sign in to Google. If the original is not publicly shared, download the full workbook and import it into Google Sheets, or paste the example data into your own sheet.
Hands-on practice
Step 1: Confirm A1:C4 contains Item, Amount, Rate with Pen | 15 | 0.15, Notebook | 40 | 0.2, and Folder | 12 | 0.1. Select C2:C4 only.
Step 2: Choose Format > Number > Custom number format.
Step 3: In Custom number formats, enter 0.0% and click Apply.
Step 4: Verify C2:C4 now display 15.0%, 20.0%, and 10.0%.
Step 5: Change C2 from 0.15 to 0.125 and verify the displayed value becomes 12.5%. Restore C2 to 0.15 and confirm it displays 15.0% again.
Checkpoint
| Item | Amount | Rate |
|---|---|---|
| Pen | 15 | 0.15 |
| Notebook | 40 | 0.2 |
| Folder | 12 | 0.1 |
Checkpoint for “Create custom number formats”: the Item, Amount, Rate columns and sample records must still match this table after the lesson action.
Common mistakes and fixes
Correction: return to the exact range and command named in the steps, then compare the live sheet with the Item, Amount, Rate source fields.
Independent practice
Add one row with the same schema, repeat the action, verify the new row behaves correctly, then remove it to restore the sample.
Key takeaways
- ✓Select only the cells that need the display format.
- ✓Use the visible path Format > Number > Custom number format.
- ✓Enter 0.0% and click Apply.
- ✓Verify 0.15, 0.2, and 0.1 display as 15.0%, 20.0%, and 10.0%.
- ✓Test 0.125 → 12.5%, then restore C2 to 0.15.
Check your understanding
Answer four questions about the practice sheet.
Next lesson
Continue in recommended learning order with Enter dates and times correctly.