Excel Exercises to Practice

Practity 20 April, 2025 459 0

SaveSavedRemoved 1

Excel Exercises for Practice

Excel exercises are a great way to enhance your skills and become proficient in using the most commonly used tools and functions of the spreadsheet. Practice allows you to become more proficient in using Excel, enabling you to accomplish tasks more efficiently and accurately. It is the best way to gain experience and become comfortable with various features of Excel.

One of the main reasons why it is necessary to solve excel problems is that it helps in learning Excel and its formulas effectively. Reading about the different tools and functions is not enough to truly understand how they work. Using these tools and functions in practical scenarios is how you can gain a deeper understanding of their functionalities and learn how to apply them in different situations.

Excel practice questions also help in building problem-solving skills. As you solve different problems using Excel, you develop critical thinking abilities and learn how to approach complex tasks. Excel often requires logical thinking and problem-solving skills to manipulate data effectively.

Exercise 1: Formatting

The following Excel dataset contains the stats of two matches of the NBA and the Euro league. The table breaks down the players of each team along with their points, rebounds and assists during the matches. Click here for the Euro league data and here for the NBA results.

Before start working with data, clean it:

Move the table to row 1.
Set the header font to Calibri, size 12.
Center the text of all cells.
Add border lines to the header.

Expected Output

Exercise 2

It is a long table, more than 40 rows. Make the header always visible when scrollinng down to the bottom of the table.

Expected output:

Exercise 3

Keep cleaning the values of the table:

Select the entire table with the keyboard and set the font size to 11. Remove the Bold letters of the “TEAM” column.
In column “PLAYER”, many players appear with a link inserted to the player website. Remove the link, just leave the name as text.
Widen the “TEAM” column so you can see the name of the teams.

Expected output:

Exercise 4

The table includes the stats of two matches: PORTLAND TRAIL vs PHOENIX SUNS (NBA) and BARCELONA vs ZALGIRIS KAUNAS (Euro League). The “Points” column shows how many points scored each player during the match.

What team won the matches? Create a summary table with the scores of the four teams.

Exercise 5

Find out the top 5 players and the team they belong to.

Exercise 6

Sort the table by “TEAM” and score. Show all players of each team in ascending order.

Exercise 7

In the following tables, you have data of a cars importer. You can see the cars they have just bought, the time when they will arrive and the manufacturer.
On table 2 (in another work sheet) you have the pre-tax price the company has paid for each vehicle.

TABLE 1

TABLE 2

Data

Copy the values and paste them in your spreadsheet to solve the next Excel problems:

License plate:

CCFR11440
CCY322637
CCY440889
CCY646770
CCY770206
CCY005698
BBG236891

Delivery Date

22/02/2024

02/03/2024
10/01/2023
2023-12-14
2023-11-25
Thursday, 30
November 2023
Wednesday,
10 January 2024

Add a new column (named “Pre-tax”) in table 1 with the cost of the cars available in table 2. Keep the same formatting:

Expected Output:

Exercise 8

There are different tax rates depending on the origin of the car. Calculate the VAT the dealer must apply to each car based on the following rates:

If the origin is the European Union: 20%
If the origin is the US: 18%
If the origin is not the US or the EU: 24%

Exercise 9

Add a new column and calculate the final price (name it “Price”): “Pre-tax” + VAT amount.

Exercise 10

Change the date format of column “Delivery Date”. Set all rows with the format of the last two rows.

Expected output:

Exercise 11

What is the average final price of the cars received in 2023?

Exercise 12

Below you have a sample of a human resources table about the employees and managers of a company.

Create a summary table to show:
– The number of years the longest serving employee has spent in the company.
– The total Bonus paid by the company. The Bonus is a percentage of the annual salary.

The summary table should update automatically when other employees are added to the source data table.

Exercise 13

How many people work in each business unit?

Exercise 14

Add a new column to the summary table to inform the number of jobs based in the US. Name it “US”.

Exercise 15

You have to share you work in the spreadsheet with many other collegues so you need to protect the formulas and prevent that someone changes something.

Lock all cells from editing and set your birthday as password.

For more practice, visit Practity’s real excel exercises for all levels.