Excel Data Entry Practice Exercises PDF

In this article, you will solve four practice Excel exercises in data entry, which will be provided in PDF format. 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 IF, SUM, SUMIF, MATCH, INDEX, MAX, and LARGE functions, conditional formatting, data validation and basic cell formatting to solve the problems. If you have Excel 2010 or later, you can solve these problems without any compatibility issues.


Download Practice Workbook

You can download the Excel file from the following link.

Additionally, you can download the PDF file from this link.


Problem Overview

Our dataset has two main parts. In the first part, we will input the data in the first four columns. Secondly, we will use those values to calculate the remaining five columns. After that, we will calculate three more things from the following table. The problem statements are provided in the “Problem” sheet, and the solution to the problem is in the “Solution” sheet. Additionally, the reference values are given in the “Reference Tables” sheet in the Excel file.

Problem Overview of Excel Data Entry Practice Exercises PDF

Let us now walk you through all of the problems.

  • Exercise 01 Filling the Dataset: The fast task requires to fill 4 columns by typing and 5 columns by using formulas.
    • Firstly, you will need to type these values in the first 4 columns. The formatting (alignment, font size, font color, background color, etc.) helps with the visualization. Moreover, there should be a dropdown list for the date column. You will need to apply the Data Validation to do this.
    • Secondly, you will find the amount by multiplying the price by the unit sold.

    • Thirdly, find the discount amount. Less than $1 is a 3% discount and for more than 1, it is 5%. You can use the IF function to do so.
    • Fourthly, subtract the previous two values to get the net amount.
    • Then, the sales tax is 10% for all products.
    • After that, add the sales tax with the net amount to calculate the total amount.
    • Finally, add conditional formatting to the top 3 revenue.
  • Exercise 02 Finding Total Sales: Your task is to find the day wise sales and total sales amount.
    • You can use the SUMIF function to get the first value and the SUM function for the second value.
  • Exercise 03 Most Popular Item (By Quantity): In this exercise, you will need to find the highest product name and the amount of it.
    • You can use the MAX function to find the maximum value. Then, combine it with the MATCH function to find the row number. Finally, use the INDEX function to return the most popular item.
    • Additionally, using the MAX function, you can find the quantity value.
  • Exercise 04 Top 3 Items (By Revenue): Your task is to find the top 3 items from the total column.
    • You will need to combine the LARGE, MATCH, and INDEX functions to return the desired output.

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


Conclusion

Thank you for reading this article about the Excel data entry practice exercises PDF. 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!

Get FREE Advanced Excel Exercises with Solutions!

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

10 Comments
  1. Please how did you get the discount amount

  2. send me some data entry work file for practice please sir .
    i am new here I wanna work is a data entry specialist

    • Reply Lutfor Rahman Shimanto
      Lutfor Rahman Shimanto Feb 22, 2024 at 5:11 PM

      Hi Zafar Iqbal,

      In response to your request for some data entry work files, we have sent a PDF file for you to practice. Kindly check your email. You can also download the practice file provided with the article. Stay connected with ExcelDemy.

      Regards
      Rafiul Hasan
      ExcelDemy

      • Please send me some data entry files for practice . I want to practice before going to advance .

        • Lutfor Rahman Shimanto
          Lutfor Rahman Shimanto Mar 10, 2024 at 11:34 AM

          Hi Gunjan,

          Thank you for contacting us. We’ve also emailed you a practice data entry file. Feel free to download it and start practising.

          Best regards,
          ExcelDemy Team

  3. gone through all here and i want to say i find them helpful. please send me a data file for practice. thanks

  4. Function to calculate the number of different individual items sold.

    • Reply Lutfor Rahman Shimanto
      Lutfor Rahman Shimanto Apr 8, 2024 at 3:20 PM

      Hello Denny Hevalahu

      Thanks for visiting our blog and sharing your questions.

      To calculate the number of different individual items sold:

      1. Select an empty cell.
      2. Insert the following formula: =SUM(1/COUNTIF(C3:C22, C3:C22))
      3. Hit Enter to see an output like the following.

      Hopefully, the formula will be helpful; good luck.

      Regards
      Lutfor Rahman Shimanto
      ExcelDemy

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo