1. Create a named range based on the Student ID and Reduction Ratedata in the sheet ReductionTable (include cells A4 to B100). Call this name ReductionRate. Do not include the headings when defining this named range.

1. Create a macro to add validation to the reduction rate value to the current cell in the sheet Reduction Table. Name the macro ValidReductionRate with a short-cut key of Ctrl + m. For this macro, only allow the user to enter a value between 0 (0%) and 0.2 (20%). Use the Stop style to show an error message. Also assign a user-friendly message when the user moves to that cell. Test the macro on the first cell in the ReductionRate column (B4).

1. Use the macro to add validation to all other Reduction Rate values in column B in the ReductionTable sheet.

1. Add an extra column to the qryAllEnrolments sheet after the curFee column. Name this column Reduction Rate. Use a lookup function to search for the Student ID in that row using the Reduction table on the Reduction Tablesheet. Copy this formula down the column.

1. Add another column after the Reduction Rate column and call this Final Fee. Use an Excel formula to work out the final fee for each unit of competency enrolled by the student by reducing the Fee by the rate calculated in part 3 above. For example, if the fee payable for a unit of competency is $75.00 and the student is entitled to a 10% reduction, the final fee is $67.50 ($75.00 - 10% of $75.00).

1. Format all monetary fields to currency and 2 decimal places. Format the reduction rate values to percentage with 1 decimal place.