Excel Data Entry Practice Exercises PDF

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.