Excel Practice Exercises PDF with Answers

Get FREE Advanced Excel Exercises with Solutions!

In this article, we will provide you with 11 Excel practice exercises in PDF format with answers. Additionally, you will get an Excel file where you can try to solve these problems yourself. These problems are mostly beginner friendly. However, a little bit of intermediate knowledge is required to solve a few problems. You will need to know about the SUM, AVERAGE, IF, VLOOKUP, INDEX, MATCH, ROUNDUP, UNIQUE, COUNTIF, LEFT, SEARCH, MID, RIGHT, LEN, FIND, SUBSTITUTE, AND, and SUMIF functions and the Data Bars feature of Excel. If you have Excel 2010 or later, you can solve these problems, except for the UNIQUE function, which is only available in Excel 2021.


Download Practice Files

You can download the PDF and Excel files by filling out this form:


Problem Overview

There are eleven problems in this PDF file, and the solutions to those problems are given after each problem. Here is a snapshot of the first two problems. The solutions to all problems are given in a separate sheet of Excel file.

Now, the eleven exercise problems are as follows:

  • Exercise 01. Class Performance Evaluation. You will find these values –
    • The total number for each student,
    • Their average on those subjects,
    • Based on the average score, you will return a GPA. For GPA calculation, less than 60 is B and higher is A.
  • Exercise 02: Lookup Values (Left to Right).
    • You need to find the employee salary in the lookup table on the right side.

  • Exercise 03: Lookup Values (Any Direction).
    • Here your task is the same as the second task. However, this time the lookup range is on the right side. Therefore, you cannot use the VLOOKUP function here.
  • Exercise 04: Rounding Values.
    • You will need to round the sales generated values in this exercise.
  • Exercise 05: Joining Two Strings.
    • You will need to add the first name and last name.
  • Exercise 06: Conditional Formatting.
    • Your task is to create a Data Bar for the salary values and hide the salary values.
  • Exercise 07: Counting Unique Values.
    • Firstly, you need to find the unique values in a list of names.
    • Then, you will find how many times that value occurred in that lis
  • Exercise 08: Extract First, Middle, and Last Name.
    • You need to separate the three parts of a name from a given list.
  • Exercise 09: Conditional Summation.
    • You will need to find the total sales for a particular country.
  • Exercise 10: Data Validation.
    • Your objective is to ensure that users cannot type less than 0 in a column.
  • Exercise 11: Check If a Date Is Between Two Dates.
    • Your target is to determine whether a date is between two dates or not.

Here is a screenshot of the solutions to the first two problems. The solutions to these problems are provided in the PDF and Excel files.

Excel Practice Exercises PDF with Answers


Download Practice Files

You can download the PDF and Excel files by filling out this form:


Conclusion

Thank you for reading this article. We hope that with these practice exercises in PDF format with answers, you can test your Excel skills. You can find more articles similar to this on the ExcelDemy website. If you have any questions or suggestions, feel free to comment below. However, remember that our website implements comment moderation. Therefore, your comment may not be instantly visible. So, have a little bit of patience, and we will solve your query as soon as possible. Keep excelling!

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.

Rafiul Haq
Rafiul Haq

Rafiul Haq worked as an Excel and VBA Content Developer in Exceldemy for over two years and published almost 200 articles for the website. He is passionate about exploring new aspects of Excel and VBA. He received his Bachelor of Science in Mechanical and Production Engineering (MPE) from the Islamic University of Technology. Rafiul furthered his education by obtaining an MBA in Finance from the Institute of Business Administration (IBA) at the University of Dhaka. Apart from creating... Read Full Bio

8 Comments
  1. You really help me alot thanks

  2. Thanks a lot

  3. Thank you

  4. This is very helpful. You are God send

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo