Practice

Excel practice exercises

573 Excel exercises from your first formula to PivotTables, Power Query and DAX. Open any task in a live spreadsheet, solve it in your browser and get an instant check. No sign-up needed.

Excel Fundamentals

Beginner 23 exercises

Sample tasks

In A4, add the city "Phoenix".
Copy the quantity 2 from C2 into every row C3:C6.
Format the headers A1:H1: bold font and a gray fill.

All 23 exercises →

Formatting and Presentation

Beginner 32 exercises

Sample tasks

Format the prices in B2:B6 as currency ($).
Highlight sales over $100,000 in B2:B9.
In F2:F4, calculate each region's sales with SUBTOTAL and function number 9 (South is…

All 32 exercises →

Formula Basics

Beginner 46 exercises

Sample tasks

In D2, calculate the total for bread: price × quantity.
In C2:C6, convert the prices to euros: price in $ × the rate in F1. Write the formula in…
On the "Quarter" sheet, in B2:B5, add up the January, February and March sales.

All 46 exercises →

Excel Functions

Confident User 85 exercises

Sample tasks

In D7, calculate the total amount of the purchase.
In C2:C8, write "Pass" if the score is at least the passing score (F1), otherwise "Fail".
In E2:E4, count how many deals each manager has.

All 85 exercises →

Advanced Formulas

Confident User 69 exercises

Sample tasks

In F2:F4, look up the item name for each code in column E.
In D2, list the cities without duplicates, in alphabetical order, with a single formula.
In A2:A10, number the rows with the ROW function.

All 69 exercises →

Data Management and Cleaning

Confident User 38 exercises

Sample tasks

Sort the table A2:B9 by sales from largest to smallest. The rows must stay intact.
Name the model lists: "Laptops" is E2:E4, "Phones" is F2:F4, "Headphones" is G2:G3.
In F5, list all the deals (all 4 columns) from the region in F2 with an amount of at…

All 38 exercises →

Charts and Dashboards

Confident User 26 exercises

Sample tasks

Build a column chart of revenue by month (A1:B7).
Make a dropdown list of months in F1, using H2:H7 as the source, and pick "March".
Build a line chart of revenue and expenses together (A1:C7).

All 26 exercises →

PivotTables

Confident User 16 exercises

Sample tasks

Build a PivotTable: the sum of sales by rep, with the result in F1.
Build a PivotTable in F1 by category with a calculated field "Average price" = Revenue /…
Build a second PivotTable: the average deal amount by city, with the result in F8.

All 16 exercises →

Power Query

Analyst 21 exercises

Sample tasks

Create a query from the "Orders" table and remove the "Note" column.
Create a query from the file "march_sales.csv" and change the type of the "Amount"…
Keep only the paid orders (Status equals "Paid").

All 21 exercises →

Power Pivot and DAX

Analyst 28 exercises

Sample tasks

Add up the sales amounts. Name the measure "Revenue".
Calculate revenue as a running total from the start of the year. Name the measure "YTD…
The sum of the sales. Name the measure "Revenue".

All 28 exercises →

Finance and Business Analytics

Analyst 72 exercises

Sample tasks

In B5, calculate the monthly payment.
In B4:D4, calculate gross profit: revenue minus cost of goods sold.
In B8, show the name of the active scenario from B1:D1, using the number in G1.

All 72 exercises →

Statistics and Data Analysis

Analyst 57 exercises

Sample tasks

In C2:C9, enter each rep's rank by revenue.
In F2 and F3, find the first and third quartiles of delivery time.
In I2:I5, calculate the seasonal index of each quarter: the average sales of the quarter…

All 57 exercises →

VBA and Macros

Expert 13 exercises

Sample tasks

In C2:C6, get what the macro writes with Int(m / 12): the full years of tenure.
In D2:D7, calculate the average order value (revenue / orders), and where the division…
In D2:D9, get what the first line of the loop writes: price x quantity.

All 13 exercises →

Office Scripts and Power Automate

Expert 6 exercises

Sample tasks

In D2:D7, get what the script writes to row[3]: price × quantity, with a 10% discount…
In F1, enter the value of the threshold parameter that the flow passes to the script.
In D8, enter the formula that the setFormula line puts there: the sum of D2:D7.

All 6 exercises →

Python in Excel and AI

Expert 17 exercises

Sample tasks

In D2:D9, clean up the city names: no extra spaces and a capital first letter (like…
In F2, calculate the correct average deal: Austin only.
In E2:E9, turn the text amounts into numbers (like pd.to_numeric). Leave empty ones empty.

All 17 exercises →

Professional Excel Engineering

Expert 24 exercises

Sample tasks

Name cell H1 "SalesTax" and cell H2 "Discount".
In D2:D9, replace TODAY() with a reference to the report date in H1.
Rewrite the cost of goods in E2:E7 so the share comes from J1 (and fix the row where a…

All 24 exercises →

Focused interactive exercises

Practice a specific skill in a live spreadsheet, then review worked answers and related lesson tasks.

Browse interactive Excel exercises