Practice by topic / Excel / Text Functions
Imported data is messy: extra spaces, inconsistent capitals, codes glued together. Text functions clean and reshape it without retyping anything. These 10 exercises build up step by step, starting with format a decimal as a percentage, format a large number with thousands separators, format a price with two decimals.
3 of 10 free · no sign-up needed · graded on the formula you write
A1 holds a decimal value. Write a formula in A2 that formats it as a percentage with 1 decimal place using TEXT.
| A | |
|---|---|
| 1 | 0.256 |
| 2 | ? |
Use =TEXT(A1,"0.0%")
Right — TEXT("0.0%") converts the decimal to a percentage string with one decimal place.
Expected result in A2: 25.6%
A1 holds a large number. Write a formula in A2 that formats it with comma thousands separators using TEXT.
| A | |
|---|---|
| 1 | 1234567 |
| 2 | ? |
Use =TEXT(A1,"#,##0")
Good — TEXT("#,##0") inserts commas at the thousands, without any decimal places.
Expected result in A2: 1,234,567
A1 holds a price. Write a formula in A2 that formats it with exactly 2 decimal places using TEXT.
| A | |
|---|---|
| 1 | 9.5 |
| 2 | ? |
Use =TEXT(A1,"0.00")
Right — TEXT("0.00") forces exactly two decimal places, even if the value has fewer.
Expected result in A2: 9.50
A1 holds a decimal representing a whole-number percentage. Write a formula in A2 that formats it as a percentage with no decimals using TEXT.
| A | |
|---|---|
| 1 | 0.5 |
| 2 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1 holds a budget amount. Write a formula in A2 that formats it with thousands separators and 2 decimals using TEXT.
| A | |
|---|---|
| 1 | 48213.5 |
| 2 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1 holds a growth rate as a decimal. Write a formula in A2 that formats it as a percentage with 2 decimal places using TEXT.
| A | |
|---|---|
| 1 | 0.0847 |
| 2 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1 holds a population count. Write a formula in A2 that formats it with thousands separators using TEXT.
| A | |
|---|---|
| 1 | 892340 |
| 2 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1 holds a tax rate as a decimal. Write a formula in A2 that formats it as a percentage with 1 decimal using TEXT.
| A | |
|---|---|
| 1 | 0.0825 |
| 2 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1 holds a revenue figure. Write a formula in A2 that formats it with thousands separators and 2 decimals using TEXT.
| A | |
|---|---|
| 1 | 1500000.75 |
| 2 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1 holds a conversion rate as a decimal. Write a formula in A2 that formats it as a percentage with 1 decimal place using TEXT.
| A | |
|---|---|
| 1 | 0.034 |
| 2 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →