Excel Exercises for Students with Answers

In this article, you will get ten Excel exercises for students with answers. All of the problems are beginner friendly. In order to solve the problems, you will need to know about the MAX, MIN, SUM, AND, OR, NOT, AVERAGE, INDEX, MATCH, VLOOKUP, SMALL, LARGE, STDEV, and VAR functions. Additionally, you should know about the Fill Handle, absolute cell reference, data validation, creating a pie chart, and printing an Excel sheet. From the Excel 2010 version, all features and functions are available. So, make sure you are using at least Excel 2010 to solve the problems.

Download Practice Workbook

You can download the Excel file from the following link.

Problem Overview

There are ten problems and two sheets in the Excel file. The first sheet contains the exercises and the second sheet has the solution to those problems. The following image shows the first two problems. Additionally, we have made comments in the file to make the problems more clear to you.

• Exercise 01: Calculate Sum and Average – Your task is to find the sum and average of two numbers using basic arithmetic formulas.
  • We have used arithmetic formulas, however, you can apply the SUM and AVERAGE functions to get the output.
• Exercise 02: Use of Fill Handle – There are seven pairs of numbers, you will find the same values as in the first example. However, this time you will need to use the Fill Handle to AutoFill the formulas.

The animated image shows how to utilize the fill handle.

• Exercise 03: Application of Absolute Cell Reference – In this problem, seven items and their prices and quantity sold are provided. The amount is the price multiplied by the unit sold. You will need to use the absolute cell reference to apply a discount of 10% on the item price. Then, you can subtract discounted values to get the net amount.
• Exercise 04: Calculate Max, Min, St. dev, and Var Using Functions – Test scores from three subjects are given for six students. Your task is to find the maximum, minimum, standard deviation, and variance values from the marks.
  • To calculate the maximum value, you can either use the MAX or LARGE function. Similarly, for minimum value, the MIN or SMALL function can be used. Our data is considered as sample data. So, you need to use the STDEV.S and VAR.S functions to return accurate values. In earlier versions, you could use the STDEV and VAR functions to do so.
• Exercise 05: Create a Truth Table – Three values are provided for three statements. The result will be true if only two of the statements are true.
  • You need to combine the OR, AND, NOT functions to create the required formula.
• Exercise 06: Lookup Values Using VLOOKUP – The same dataset from the exercise 04 is used here. You need to return the score for a specific student and subject using the VLOOKUP function.
• Exercise 07: Lookup Values Using INDEX MATCH – The problem is similar to the previous, however, this time you will need to combine the INDEX MATCH functions to do so.
• Exercise 08: Lookup Values Implementing Dropdown List – In addition to the previous problem, you will need to make the subject and student field as dropdown list.
  • You will need to use the Data Validation feature.
• Exercise 09: Create a Pie Chart – You will create a Pie Chart from the expenses from a trip.
• Exercise 10: Print Excel File – The Print feature of Excel can be daunting for beginners. The final task is to print this Excel file.
  • You can tweak the settings to stop Excel from cutting off columns.

Finally, this image shows the solved sheet from the Excel file.

Conclusion

Thank you for reading this article. We hope you have learned about Excel by solving these exercises for students with answers. 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!