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.

**Table of Contents**hide

## 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.

- We have used arithmetic formulas, however, you can apply the
**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.

- To calculate the maximum value, you can either use the
**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.

- You need to combine the
**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.

- You will need to use the
**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**.

- You can tweak the settings to

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!