Download Practice Workbook
Download the Excel file.
Problem Overview
There are ten problems and two sheets in the Excel file. The first sheet contains the exercises and the second sheet the solution. The following image shows the first two problems.
- Exercise 1 – Calculate Sum and Average – Find the sum and average of two numbers using basic arithmetic formulas.
- Exercise 2 – Use the Fill Handle – Use the Fill Handle to AutoFill the formulas.
Observe the GIF.
- Exercise 3 – Using an Absolute Cell Reference – Seven items and their prices and quantity sold are provided. The amount is the price multiplied by the unit sold. Use an absolute cell reference to apply a discount of 10% to the price. Subtract discounted values to get the net amount.
- Exercise 4 – Calculate Max, Min, St. dev, and Var, using Functions – Test scores from three subjects are given for six students. Find the maximum, minimum, standard deviation, and variance values from the marks.
- Exercise 5 – Create a Truth Table – Three values are provided for three statements. The result will only be true if two of the statements are true.
- Exercise 6 – Lookup Values Using the VLOOKUP Function- Use the same dataset from exercise 4. Return the score of a specific student and subject using the VLOOKUP function.
- Exercise 7 – Lookup Values Using The INDEX and the MATCH Function- The problem is similar to the previous one, but here you will need to combine the INDEX and the MATCH functions.
- Exercise 8 – Lookup Values creating a Dropdown List – Create a dropdown list in the subject and student fields.
- Use the data validation feature.
- Exercise 9 – Create a Pie Chart – Create a pie chart from the expenses of a trip.
- Exercise 10 – Print an Excel File – Print the Excel sheet.
- Use the settings to stop Excel from cutting columns.
The image below shows the solved sheet:
