Activity 2, Module 2 - Formulas and Functions

Activity 2, Module 2 (30 minutes)

Formulas and Functions

Instructions

Download the dataset “Activity_Module2_Worksheet.xlxs.”  Complete the activity by following the instructions below. 

1. Open the file “Activity_Module2_Worksheet.xlxs.” 
2. Create a formula that calculates the gross pay for each employee, then use a built-in function to calculate the total gross pay. The gross pay total should appear in cell “E14.” All totals should appear in Row 14.
3. Create a formula that calculates the tax, which is 20% of the gross pay for each employee, then calculate a total for the tax.
4. Create a formula that calculates the net pay for each employee, then calculate a total for the net pay.
5. Create a formula that calculates the superannuation, which is 8% of the gross pay for each employee, then calculate a total for the superannuation. 6. Use functions to determine the average, maximum, and minimum values for each column, setting the number of decimal places to 2. The average, maximum, and minimum values for each column should appear in Rows 16, 17, and 18, respectively.
7. Use the “Save As” command to save the workbook as “Activity Formulas and Functions (Completed).xlxs.”