Be able to format numerical values to display currency symbols
Topic: 16 Graphs and charts
Objective: Be able to format numerical values to display currency symbols
💰 Why format currency? Think of a graph as a storybook. The numbers are the characters, but if they’re plain and unadorned, the story feels bland. Adding a currency symbol ($, £, €) is like giving each character a costume – it tells the reader instantly that the numbers represent money, making the story clearer and more engaging.
How to format numbers as currency in a spreadsheet
- Enter your raw numbers in a column (e.g., 1234.5).
- Select the cells you want to format.
- Right‑click and choose Format cells (or use the toolbar).
- Pick Currency or Accounting from the list.
- Choose the currency symbol ($, £, €) and the number of decimal places.
- Click OK and watch the numbers transform!
🔍 Tip: In Excel you can also use the TEXT function to create custom formats: =TEXT(A2,"$#,##0.00"). This is handy when you need to combine currency formatting with other text.
Example: Raw data vs. Formatted currency
| Item | Cost (raw) | Cost (currency) |
|---|---|---|
| Laptop | 1299.99 | $1,299.99 |
| Headphones | 199.5 | $199.50 |
| Software | 49.99 | $49.99 |
📚 Exam Tip Box
When you see a question asking you to “display the values as currency”:
- Check the required currency symbol (often $ unless otherwise specified).
- Make sure you keep two decimal places – even if the number ends in .00.
- Remember that the formatting does not change the underlying value, only its appearance.
- Practice by formatting a small dataset before the exam – this will save time during the test.
Analogy: Currency as a “label” on a gift box
Imagine you’re giving a gift. The box is plain white, but you add a shiny ribbon and a price tag that says $25.00. The ribbon (currency symbol) instantly tells the receiver the value of the gift. Similarly, in graphs and charts, the currency symbol tells the viewer that the numbers represent money, making the data easier to interpret.
Revision
Log in to practice.