These problems are mostly beginner-friendly. You will need to know about the IF, SUM, SUMIF, MATCH, INDEX, MAX, and LARGE functions, as well as conditional formatting, data validation, and basic cell formatting to solve the problems. All the problems can be solved on Excel 2010 or newer.
Download the Practice Workbook
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. We will use those values to calculate the remaining five columns. 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. The reference values are given in the “Reference Tables” sheet in the Excel file.
- Exercise 01 – Filling the Dataset: The fast task requires to fill 4 columns by typing and 5 columns by using formulas.
- 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. We need a dropdown list for the date column. You will need to apply the Data Validation to do this.
- You will find the amount by multiplying the price by the unit sold.
-
- 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.
- Subtract the previous two values to get the net amount.
- The sales tax is 10% for all products.
- Add the sales tax with the net amount to calculate the total amount.
- 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. Combine it with the MATCH function to find the row number. Use the INDEX function to return the most popular item.
- 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.
Please how did you get the discount amount
Hello Taiwo,
All the solution are available in the Excel Practice file section.
We used this formula to get discount amount: =F5*IF(D5<1,0.03,0.05)
Regards
ExcelDemy
=F5*IF(D5<1;0,03;0,05)
send me some data entry work file for practice please sir .
i am new here I wanna work is a data entry specialist
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 .
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
Hi,
Could you please sent me more practice in excel format? i’m new here in this analysis. i wanna have practice before going to advance level.
Hello Arya,
Before going to advance level to develop your Excel skills you can explore the given links. Download the files from the articles to learn and practice the exercises.
Excel Data for Practice Free Download
Excel Practice Exercises PDF with Answers
Explore these categories you will find out more data entry practice here: Data Entry Practice Test & Quiz
Interview Questions with Excel Topics
MCQ Questions on MS Excel
To develop your skill from beginner to advanced level you can explore our Learn Excel page.
Regards
ExcelDemy
haii kakk salam kenall tolong kirimin aku file data entry untuk latihan trus kak kan ini aku masihh pemulaa bangettt tolong kasih tips juga ya kaka makasih buangetttt
Hello Fatmawati,
Nice to meet you. You can download the data entry practice file directly from the article here: Download the files from the articles to learn and practice the exercises.
Excel Data for Practice Free Download
Excel Practice Exercises PDF with Answers
Explore these categories you will find out more data entry practice here: Data Entry Practice Test & Quiz
Interview Questions with Excel Topics
MCQ Questions on MS Excel
To develop your skill from beginner to advanced level you can explore our Learn Excel page.
Regards
ExcelDemy
gone through all here and i want to say i find them helpful. please send me a data file for practice. thanks
Hi Paulinus Friday,
You are most welcome. Data Files are available in the Excel Practice file section.
Regards
ExcelDemy
Greetings I need help, I’m looking for file to practice data entry, thank you so much here is my email address:[email protected]
Hello Lerato,
Hope you are doing well. To practice data entry, you can download the files from the articles to learn and practice the exercises.
Excel Data for Practice Free Download
Excel Practice Exercises PDF with Answers
Explore these categories you will find out more data entry practice here: Data Entry Practice Test & Quiz
Interview Questions with Excel Topics
MCQ Questions on MS Excel
To develop your skill from beginner to advanced level you can explore our Learn Excel page.
Regards
ExcelDemy
Function to calculate the number of different individual items sold.
Hello Denny Hevalahu
Thanks for visiting our blog and sharing your questions.
To calculate the number of different individual items sold:
Hopefully, the formula will be helpful; good luck.
Regards
Lutfor Rahman Shimanto
ExcelDemy
Please send me some data entry files for practice. I want to practice before going to advance.
Hello Umang,
Here are some articles from where you can download dataset of different types to practice your skills.
Excel Sample Data (Free Download 13 Sample Datasets)
Excel Data for Analysis (Free Download 11 Suitable Datasets)
Excel Data for Practice Free Download
Regards
ExcelDemy
hello
can you send me another file data entry practice, please?
Hello Reza Fadlilah,
Here are some articles from where you can download dataset of different types to practice your skills.
Excel Sample Data (Free Download 13 Sample Datasets)
Excel Data for Analysis (Free Download 11 Suitable Datasets)
Excel Data for Practice Free Download
Regards
ExcelDemy
Sir mujhe kuch data chahiye excel me chadhane ke thaki mere prectice bhi ho jaye or experience bhi aajaye
Hello Manish,
To practice Excel, you can download free practice files from this article: Excel Data Entry Practice Exercises (PDF + Excel). These files will help you practice and improve your skills.
Excel Sample Data for Practice
Excel Data for Practice Free Download
Excel Practice Exercises PDF with Answers
Explore these categories you will find out more data entry practice here: Data Entry Practice Test & Quiz
Interview Questions with Excel Topics
MCQ Questions on MS Excel
Regards,
ExcelDemy
Thank you, sir, for this practice it was really helpful, please can I get more data entry practice file please
Hello Johnson Helen,
You are most welcome. We are glad to hear that it was really helpful to you. In our Practice Test & Quiz category you will find out more data entry practice here: Data Entry Practice Test & Quiz
Keep learning Excel with ExcelDemy.
Regards
ExcelDemy
Please send me some data entry files for practice. Thank you so much.
Hello Rechelyn Cañete,
You are most welcome. To develop your Excel skills you can explore the given links. Download the files from the articles to learn and practice the exercises.
Excel Data for Practice Free Download
Excel Practice Exercises PDF with Answers
Explore these categories you will find out more data entry practice here: Data Entry Practice Test & Quiz
Interview Questions with Excel Topics
MCQ Questions on MS Excel
To develop your skill from beginner to advanced level you can explore our Learn Excel page.
Regards
ExcelDemy
Hi, can you please send me another activity to develop my excel skills. Thank you so much.
Hello Johnrey Cambaya,
You are most welcome. To develop your Excel skills you can explore the given links. Download the files from the articles to learn and practice the exercises.
Excel Data for Practice Free Download
Excel Practice Exercises PDF with Answers
Explore these categories you will find out more data entry practice here: Data Entry Practice Test & Quiz
Interview Questions with Excel Topics
MCQ Questions on MS Excel
To develop your skill from beginner to advanced level you can explore our Learn Excel page.
Regards
ExcelDemy
Hai, bisakah Anda mengirimkan saya aktivitas lain untuk mengembangkan keterampilan Excel saya? Terima kasih banyak.
Hello Wulan Ramayani,
To develop you excel skill learn and practice the exercises given below.
Excel Data for Practice Free Download
Excel Practice Exercises PDF with Answers
Explore these categories you will find out more data entry practice here: Data Entry Practice Test & Quiz
Interview Questions with Excel Topics
MCQ Questions on MS Excel
To develop your skill from beginner to advanced level you can explore our Learn Excel page.
Regards
ExcelDemy
Please send me some data entry files for practice . I want to practice before going to advance .
Hello Yngwie,
Before proceeding to advance level to develop your Excel skills you can explore the given links. Download the files from the articles to learn and practice the exercises.
Excel Data for Practice Free Download
Excel Practice Exercises PDF with Answers
Explore these categories you will find out more data entry practice here: Data Entry Practice Test & Quiz
Interview Questions with Excel Topics
MCQ Questions on MS Excel
To develop your skill from beginner to advanced level you can explore our Learn Excel page.
Regards
ExcelDemy
How to calculate total sales and how to use sumif formula
Hello Aiza,
To calculate total sales, use the SUM function. For example, if your sales data is in cells B2 to B10, the formula is:
=SUM(B2:B10)
To sum values based on specific criteria, use SUMIF. For example, to sum sales over $100 in the same range, use:
=SUMIF(B2:B10, “>100”)
The SUMIF formula helps you total values only when they meet your chosen criteria. Let me know if you need more details!
Regards
ExcelDemy
hi sir/ma’am, i am yuli. can you please send me some data entry files for practice? I want to work as a data entry. I looking for a freelance job as data entry and need some data entry files to practice and to upload into my Portofolio.
Hello Yuli,
To practice data entry you can explore the following articles. Download the files from the articles to learn and practice the exercises.
Excel Sample Data for Practice
Excel Data for Practice Free Download
Excel Practice Exercises PDF with Answers
Explore these categories you will find out more data entry practice here: Data Entry Practice Test & Quiz
Interview Questions with Excel Topics
MCQ Questions on MS Excel
To develop your skill from beginner to advanced level you can explore our Learn Excel page.
Regards
ExcelDemy
Assalamu alaikum mam i want the same type of data for practice with solution sheet will u provide more
Hello Syed Mustfa,
Wa alaikum assalam! Thank you for your message.
You can find more practice data with solution sheets in the articles listed above. All of the article includes solution sheet. You will need to download it from articles.
Regards
ExcelDemy
Please send me some data entry files for practice. Thank you so much.
Hello Deliah,
You are most welcome. It’s our pleasure to help you with data entry files. To practice data entry you can explore the following articles. Download the files from the articles to learn and practice the exercises.
Excel Sample Data for Practice
Excel Data for Practice Free Download
Excel Practice Exercises PDF with Answers
Explore these categories you will find out more data entry practice here: Data Entry Practice Test & Quiz
Interview Questions with Excel Topics
MCQ Questions on MS Excel
To develop your skill from beginner to advanced level you can explore our Learn Excel page.
Regards
ExcelDemy
Hi ma’am sir the formula for getting the discount not working having problem on it
Hello Jennifer Enriquez,
Thanks for reaching out. The discount formula you’re using =F5*IF(D5<1,0.03,0.05) looks correct and should calculate a 3% discount if the price is less than 1, and a 5% discount otherwise.
If it’s not working as expected, please double-check that the cells you’re referencing contain numbers (not text or empty values).
Also, make sure there are no extra spaces in the price or amount cells.
If you’re still having trouble, could you share more details or a screenshot of the issue? I’d be happy to help further!
Regards
ExcelDemy
Still having trouble but i don’t know how to share screen shot
Hello Jennifer Enriquez,
Share your problem in ExcelDemy Forum. There you can upload images, Excel and etc.
Also brief your problem in detail.
Regards
ExcelDemy
Hello Jennifer Enriquez,
Share your problem in ExcelDemy Forum. There you can upload images, Excel and etc.
Also brief your problem in detail.
Regards
ExcelDemy
I have a question:
I created a worksheet, with many formulas that work.
How do I save these formulas? Now, If I delete the number in the cell, I also delete the formula. I don’t want this to happen. I want the formula to remain.
Hello Randy,
If deleting the number also removes your formula, it means you typed the number directly into the same cell where the formula is. Always keep formulas in one cell and input numbers in another.
Example with a function:
1. Enter numbers in A1 and B1.
2. In C1, enter the formula:
=SUM(A1,B1)
If you delete the numbers in A1 or B1, the formula in C1 stays intact. It will just recalculate and show 0 (or blank if you wrap it with IF).
This way, your formulas always remain, and only the inputs change.
Regards,
ExcelDemy
Hi
I’m new here and i’m working towards becoming a data entry operator. Please can you send me some files i could use to practice?
Hello Elizabeth,
You are most welcome. Since you’re working towards becoming a data entry operator, you can download free practice files from this article: Excel Data Entry Practice Exercises (PDF + Excel). These files will help you practice and improve your skills.
Excel Sample Data for Practice
Excel Data for Practice Free Download
Excel Practice Exercises PDF with Answers
Explore these categories you will find out more data entry practice here: Data Entry Practice Test & Quiz
Interview Questions with Excel Topics
MCQ Questions on MS Excel
Regards,
ExcelDemy