10 Practice Exercises for Excel Beginners (With Data)
· 8 min read
The best Excel practice exercises use one small, realistic table and ask business questions about it, with a number you can check your answer against. Below are ten of them, in order of difficulty, on a table you can type in two minutes. Each one has a hint and a check value. Try it first, then look at the check. The first one starts with a simple formula like this:
=F2*G2The practice table
It is one month of orders for a business that sells office, kitchen and cleaning supplies. You can type your answers straight into the sheet below (exercises 1 to 8 fit in it), or copy the data into your own spreadsheet, starting in cell A1.
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order | Date | Region | Category | Status | Units | Unit price | Revenue | Flag | Answers |
| 2 | 5001 | 2025-03-03 | North | Office | completed | 20 | 4.50 | 90.00 | ||
| 3 | 5002 | 2025-03-04 | West | Kitchen | completed | 6 | 12.00 | |||
| 4 | 5003 | 2025-03-07 | East | Cleaning | refunded | 10 | 7.25 | |||
| 5 | 5004 | 2025-03-10 | West | Office | completed | 15 | 4.50 | |||
| 6 | 5005 | 2025-03-12 | South | Kitchen | cancelled | 8 | 12.00 | |||
| 7 | 5006 | 2025-03-18 | West | Cleaning | completed | 12 | 7.25 | |||
| 8 | 5007 | 2025-03-21 | North | Kitchen | completed | 5 | 12.00 | |||
| 9 | 5008 | 2025-03-27 | East | Office | completed | 30 | 4.50 | |||
| 10 |
The heading "Revenue" is already in H1 (in your own spreadsheet, type it there). You will fill that column in the first exercise.
Beginner excel formula practice
1. Revenue for each order
In H2, multiply units by unit price. Then copy the formula down to H9.
Hint: start with =, click F2, type *, click G2. To copy down, drag the small square at the bottom-right of the cell, or double-click it.
Check: H4 is 72.50 and H9 is 135.00.
2. Total revenue
In H10, add up the whole Revenue column.
Hint: SUM with a range from the first data row to the last.
Check: 680.00.
3. Average units and the biggest order
In J2, the average units per order. In J3, the largest revenue on a single order.
Hint: AVERAGE on column F, MAX on column H.
Check: 13.25 units and 135.00.
4. How many orders were completed?
In J4, count the rows whose status is "completed".
Hint: COUNTIF takes a range and a condition. Text conditions go in quotes.
Check: 6.
Intermediate: conditions and totals
5. Units sold in the Office category
In J5, add up units only where the category is Office.
Hint: SUMIF. Watch the argument order: the range you test comes first, the range you add comes last.
Check: 65 units.
6. Completed revenue for North
In J6, add up revenue where the region is North and the status is completed.
Hint: SUMIFS, with the sum range first and then two "range, condition" pairs. Our SUMIFS guide has the full syntax.
Check: 150.00.
7. Flag the big orders
In I2, show "Big" when the order's revenue is 80 or more, otherwise leave it empty. Copy it down to I9. Then count the "Big" rows.
Hint: IF with a comparison, a text result in quotes, and "" for empty.
Check: 4 big orders (5001, 5005, 5006 and 5008).
8. West's share of completed revenue
In J8, divide West's completed revenue by total completed revenue. Format it as a percentage.
Hint: two SUMIFS, one divided by the other. The denominator needs only the status condition.
Check: 44.3%. If you got 33.3%, you divided by all revenue, including the refunded and cancelled orders. That is a real difference in a report.
VLOOKUP practice exercises
9. Who manages each category?
Type this small table in L1:M4:
| L: Category | M: Manager | |
|---|---|---|
| 2 | Office | Dana |
| 3 | Kitchen | Luis |
| 4 | Cleaning | Priya |
In K2, look up the manager for the order's category, then copy down to K9.
Hint: VLOOKUP (or XLOOKUP if you have Excel 2021, Microsoft 365 or Excel for the web). Use exact match, and lock the lookup table with $ signs so it does not slide down when you copy.
Check: K4 (order 5003) is Priya, K8 (order 5007) is Luis. If row 9 or later shows #N/A, your table reference moved. For the differences between the lookup functions, see VLOOKUP vs XLOOKUP vs INDEX MATCH.
Extra VLOOKUP practice: add an order in row 10 with the category "Stationery" and copy the lookup down to it. What does your lookup return? (It should be #N/A, because there is no Stationery manager. A lookup that returns a name here is doing an approximate match.)
Advanced: find the AI's mistake
10. Check the assistant's total
You asked an AI assistant for total revenue and it wrote this in H12:
=SUM(H2:H8)Is it right? If not, what is wrong and what is the correct value?
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Date | Region | Category | Status | Units | Unit price | Revenue |
| 2 | 5001 | 2025-03-03 | North | Office | completed | 20 | 4.50 | 90.00 |
| 3 | 5002 | 2025-03-04 | West | Kitchen | completed | 6 | 12.00 | 72.00 |
| 4 | 5003 | 2025-03-07 | East | Cleaning | refunded | 10 | 7.25 | 72.50 |
| 5 | 5004 | 2025-03-10 | West | Office | completed | 15 | 4.50 | 67.50 |
| 6 | 5005 | 2025-03-12 | South | Kitchen | cancelled | 8 | 12.00 | 96.00 |
| 7 | 5006 | 2025-03-18 | West | Cleaning | completed | 12 | 7.25 | 87.00 |
| 8 | 5007 | 2025-03-21 | North | Kitchen | completed | 5 | 12.00 | 60.00 |
| 9 | 5008 | 2025-03-27 | East | Office | completed | 30 | 4.50 | 135.00 |
| 10 | ||||||||
| 11 | ||||||||
| 12 | AI's formula | 545.00 | ||||||
| 13 | Your fix |
Hint: compare its result with your answer to exercise 2, then read the range.
Check: the AI's formula returns 545.00. The range stops one row early and misses order 5008. The correct total is 680.00.
This is the kind of mistake that matters most in real work. The formula has no error, the number looks reasonable, and nobody notices unless they check. Get into the habit of clicking an AI's formula and reading every range: does it start on the first data row and end on the last?
Turn it into an Excel practice test
Once the ten exercises feel easy, make yourself a short excel practice test:
- Clear columns H to K.
- Set a 15-minute timer.
- Redo exercises 1, 2, 5, 6, 8 and 9 without looking at the hints.
- Check every answer against the check values above.
Then change the questions. Ask "kitchen revenue in the West", "how many orders were over 50 units", "what share of units came from cleaning". The same table supports dozens of questions, which is how real analyst work feels: one dataset, many business questions.
To test a formula of your own on a table like this one, use the free Excel formula checker.
For more structured practice, Practisheet gives you drills like these on a whole year of one company's data, plus audit exercises where an AI has made a mistake you need to find and fix. Start on the practice page.
Common mistakes
Typing numbers instead of cell references. =20*4.5 gives the right answer once, but it does not update and cannot be copied down. Always point at cells.
Ranges that stop early or start late. Exercise 10 is the classic version. It also happens when you add rows below a range that a formula already uses. Excel tables (Ctrl+T) grow automatically and avoid this.
Forgetting $ when copying. Lookup tables and total cells need to be locked. Our percentage of total guide explains absolute references.
Leaving out a condition. "Revenue" in most businesses means completed orders only. An AI assistant asked for "North revenue" will often add every North row. Read the question again and check every condition is in the formula.
Checking only that there is no error. A formula without #VALUE! or #N/A is not automatically correct. Check one row by hand, and check totals against a second method.
FAQ
Where can I practice Excel for free?
You can use the table and exercises on this page in any spreadsheet app, including Excel for the web and Google Sheets. Practisheet's first exercises are also free to try.
What Excel formulas should a beginner practise first?
SUM, AVERAGE, MIN and MAX, then COUNTIF and SUMIF, then IF, then SUMIFS and COUNTIFS, then a lookup (VLOOKUP or XLOOKUP). That order is roughly how these exercises are arranged.
How do I practise for an Excel test for a job?
Use a timed set of tasks on one realistic dataset, check every answer, and practise reading formulas someone else wrote. Our list of Excel interview questions for data analysts covers what usually comes up.
Are there VLOOKUP practice exercises with answers?
Exercise 9 above is one, with check values. To practise more, add a second lookup table (say, region to regional manager) and look up both columns.
Practise this on a realistic dataset
Solve it yourself on one company's data, with instant feedback that points at what's wrong without giving away the answer.
Try “Add two months” →