Practice by topic / Excel / Fundamentals
Every Excel formula is built from the same basics: cell references, operators and the order Excel calculates them in. Get these right and the rest of Excel stops feeling like guesswork. These 10 exercises build up step by step, starting with combine a label with a value, build a full name, add a unit label to a number.
3 of 10 free · no sign-up needed · graded on the formula you write
A1 holds a product name, B1 holds its price. Write a formula in C1 that joins them into one string like "Widget: 9.99" using &.
| A | B | C | |
|---|---|---|---|
| 1 | Widget | 9.99 | ? |
Use & to join the cells: =A1&": "&B1
Right — & concatenates the text and number together into one readable string.
Expected result in C1: Widget: 9.99
A1 holds a first name, B1 holds a last name. Write a formula in C1 that joins them with a space between using &.
| A | B | C | |
|---|---|---|---|
| 1 | Maria | Chen | ? |
Join with a space: =A1&" "&B1
Good — & is the simplest way to combine text values with a literal space between them.
Expected result in C1: Maria Chen
A1 holds a numeric weight. Write a formula in B1 that appends " kg" to it using &.
| A | B | |
|---|---|---|
| 1 | 42 | ? |
Append the unit: =A1&" kg"
Right — & automatically converts the number to text before joining it with the label.
Expected result in B1: 42 kg
A1 holds a count, B1 holds an item name. Write a formula in C1 that builds "You have N item" style text using &.
| A | B | C | |
|---|---|---|---|
| 1 | 5 | apples | ? |
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 numeric order ID. Write a formula in B1 that prepends "ORD-" to it using &.
| A | B | |
|---|---|---|
| 1 | 1042 | ? |
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 and B1 hold two numbers that should display together as one text string like "3-4" using &.
| A | B | C | |
|---|---|---|---|
| 1 | 3 | 4 | ? |
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 base name, B1 holds a version number. Write a formula in C1 that builds a filename like "report_v2" using &.
| A | B | C | |
|---|---|---|---|
| 1 | report | 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 city, B1 holds a state abbreviation. Write a formula in C1 that joins them like "Austin, TX" using &.
| A | B | C | |
|---|---|---|---|
| 1 | Austin | TX | ? |
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 plain number representing a percentage. Write a formula in B1 that appends a % sign to it as text using &.
| A | B | |
|---|---|---|
| 1 | 42 | ? |
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 task name, B1 holds a status word. Write a formula in C1 that builds a message like "Task: done" using &.
| A | B | C | |
|---|---|---|---|
| 1 | Deploy | done | ? |
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 →