text: **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 
   Create a formula that calculates the gross pay for each employee, then use 
  
  found in the same folder as the student files) 
  
  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 
   Create a formula to calculate the net pay for each employee and then a 
   Create a formula that calculates the superannuation as being 8% of the 
   Use functions to determine the average, maximum and minimum values for 
  
  *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***