Formulo
Formulo

Practice

  • Exercises0/121

Learn

  • Functions19

Your account

  • My account
  • Pricing
Start hereAdd up the month's expensesTema 1 · First formulas
Formulo
ExercisesFree exercisesAll functionsPricingCompare with other sitesWhat is FormuloContactMy accountCreate a free account

© 2026 Formulo. Excel is a trademark of Microsoft Corporation. This site is not affiliated with Microsoft or with any employer or organization that sets tests.

Legal noticePrivacyTermsCookies

Excel exercises

Pick a topic and practice at your pace. Without an account, your progress is saved in this browser.

Start

How it works

  1. 1

    Open an exercise

    Each one is an Excel sheet with real data and one yellow cell.

  2. 2

    Type the formula

    Start with = like in your Excel. Use commas between arguments.

  3. 3

    Press Check

    We check it straight away and tell you what's wrong and why.

Topics

    1. 1Add up the month's expensesStart
    2. 2Work out the sales tax on each product
    3. 3Work out each month's profit
    4. Multiply quantity by price, Locked
    5. Work out the average score, Locked
    6. Find the best sales day, Locked
    7. Find the cheapest supplier, Locked
    8. Count who has handed in the assignment, Locked
    9. Work out each store's share of the total, Locked
    10. Apply a discount to the whole list, Locked
    11. Review: how much does the price vary between stores, Locked
    12. Review: the average without the highest score, Locked
    1. Convert the prices to euros, Locked
    2. Add sales tax to each price, Locked
    3. Work out how much of the budget each expense takes, Locked
    4. Fill a whole table with one formula, Locked
    5. Work out prices under several discounts, Locked
    6. Work out commission plus a base salary, Locked
    7. Compare each store with the average, Locked
    8. Keep a running total, Locked
    9. Work out the cost of each trip, Locked
    10. Split a bonus according to sales, Locked
    11. Fix the formula: only the first row comes out right, Locked
    12. Review: discount and tax in the same formula, Locked
    13. Review: the percentage above or below average, Locked
    1. Mark who has passed, Locked
    2. Decide whether shipping is free, Locked
    3. Work out each rep's commission, Locked
    4. Flag what is still unfinished, Locked
    5. Check two conditions at once, Locked
    6. It is enough to meet one condition, Locked
    7. Choose between three results, Locked
    8. Count only what meets a condition, Locked
    9. Add up only one region's sales, Locked
    10. Fix the formula: the order of exactly $50, Locked
    11. Review: who sells above average, Locked
    12. Review: two limits in cells, Locked
    1. Look up a product's price, Locked
    2. Fill in the whole order, Locked
    3. Bring in the product name, Locked
    4. Work out the amount using the looked-up price, Locked
    5. Replace the #N/A with a message, Locked
    6. Look up in a table of brackets, Locked
    7. Look up with XLOOKUP, Locked
    8. Find which position a code is in, Locked
    9. Look to the left with INDEX and MATCH, Locked
    10. Apply the discount for the customer type, Locked
    11. Choose the VLOOKUP column with MATCH, Locked
    12. Fix the formula: VLOOKUP brings the wrong price, Locked
    13. Review: commission in dollars by bracket, Locked
    14. Review: the amount or a warning, Locked
    1. Count how many people have signed up, Locked
    2. Count the orders for one city, Locked
    3. Count the orders over a limit, Locked
    4. Count the orders for each city, Locked
    5. Add up what you have spent on food, Locked
    6. Summarize the expenses by category, Locked
    7. Add up only the big sales, Locked
    8. Count the unpaid invoices, Locked
    9. Work out the pass rate, Locked
    10. Work out the average spend on food, Locked
    11. Review: check whether a name is on the list, Locked
    12. Review: which regions hit the target, Locked
    1. Flag the weekend shifts, Locked
    2. Check whether a value is between two limits, Locked
    3. Work out shipping by bracket, Locked
    4. Avoid the divide-by-zero error, Locked
    5. Calculate only when there is data, Locked
    6. Combine AND with OR, Locked
    7. Apply the right withholding, Locked
    8. Show the stock status, Locked
    9. Compare this month with the last, Locked
    10. Work out a target-based bonus, Locked
    11. Review: the exam and the three assignments, Locked
    12. Review: free shipping by amount or by customer type, Locked
    1. Bring in the name with XLOOKUP, Locked
    2. Flag a code that does not exist, Locked
    3. Look to the left with XLOOKUP, Locked
    4. Look up in a horizontal table, Locked
    5. Cross a row with a column, Locked
    6. Find a runner's finishing place, Locked
    7. Look up the commission bracket, Locked
    8. Work out the amount using the catalog price, Locked
    9. Bring in the last price paid, Locked
    10. Check whether there is stock for an order, Locked
    11. Review: the name of the top seller, Locked
    12. Review: compare an offer with your catalog, Locked
    1. Join first name and surname, Locked
    2. Turn the codes into capitals, Locked
    3. Pull out the prefix of each reference, Locked
    4. Show only the last digits, Locked
    5. Pull the year out of the case number, Locked
    6. Remove the extra spaces, Locked
    7. Count the characters in each message, Locked
    8. Build a reference from three parts, Locked
    9. Pull out the initials, Locked
    10. Check the length of the IDs, Locked
    11. Review: join and clean names from a form, Locked
    12. Review: count the references that start the same, Locked
    1. Count the days between two dates, Locked
    2. Use DAYS to count days, Locked
    3. Work out the due date, Locked
    4. Pull the year out of a date, Locked
    5. Pull the month out of a date, Locked
    6. Build a date from its parts, Locked
    7. Work out the last day of the month, Locked
    8. Flag the late deliveries, Locked
    9. Work out the years at the company, Locked
    10. Count the orders since a date, Locked
    11. Review: how many days late is each delivery, Locked
    12. Review: which invoices are overdue, Locked
    1. Round the price with tax to the cent, Locked
    2. Round the average score to one decimal, Locked
    3. Work out how many boxes you need, Locked
    4. Work out the inventory gap, Locked
    5. Flag the big gaps, Locked
    6. Work out an invoice total, Locked
    7. Apply the tax rate for each type of product, Locked
    8. Work out each category's share, Locked
    9. Work out the weighted final grade, Locked
    10. Give each target a traffic light, Locked

Your next exercise

Topic 1Add up the month's expenses

Your progress

0/121

0 of 121 exercises · 0 topics finished

Tip

If a formula fails, read the message: it says which cell and why. You don't need to start over.