Microsoft Excel 
ITTraining@sgul.ac.uk Page 31 St. George’s Information Services 
PRACTICE EXERCISE 
Formulas And Functions 
Tasks: Completed: 
 Before starting this exercise you MUST have completed all of the topics in 
the chapter Formulas And Functions… 
 
 
Open the workbook called PE_Formulas And Functions.xlsx (it can be 
found in the same folder as the student files)  
 
Create a formula that calculates the gross pay for each employee, then use 
a function to calculate the total of the gross pay 
The total for Gross Pay should appear in E14... 
 
 
Create a formula that calculates the tax as being 20% of the gross pay for 
each employee, then create a total for the tax  
 
Create a formula to calculate the net pay for each employee and then a 
total of the net pay  
 
Create a formula that calculates the superannuation as being 8% of the 
gross pay for each employee, then create a total for superannuation  
 
Use functions to determine the average, maximum and minimum values for 
each column, setting the number of decimal places to 2 
Your worksheet should appear as shown on the following page... 
 
 
Use the Save As command to save the workbook as PE_Formulas And 
Functions (Completed).xlsx  