Kindly make an excel sheet of below enteries

1. On the Payment Table sheet, in cell B9, enter rates in decrements of .5% beginning with 9.00% and ending with 5.50% in cell B16. Format rates with two decimal places.
2. In cell B8, enter a PMT function using the information in cells B2:B4 to yield a positive value. Create a data table in the range B8:H16 using the information in cells B2:B4, in which the row input cell is the Period and the column input cell is the Interest rate. Apply the format from B8 to the results in the data table. Select the payment option closest to $10,500 per month and format the option with the Note cell style.
3. On the Employee Classification sheet, Name the range A5:A9 Employee_Classification Name the range A5:D9 Job_Code Click to display the Employee Budget sheet. Using the Data Validation dialog box, validate the range A10:A14 from a List using the Source =Employee_Classification.
4. In cell A10 select GREET from the list. In cell B10, type 2 In C10 insert a VLOOKUP function that looks up the Description from the Employee Classification worksheet using the Job Code range, fill the VLOOKUP formula through cell C14. In cell D10, create a VLOOKUP that looks up the Type from the Employee Classification worksheet using the Job Code range and fill down to D14. In cell E10, insert the VLOOKUP function that looks up the Salary from the Employee Classification worksheet using the Job Code range, fill down to cell E14.
5. Beginning in cell A11, add the following Job Codes and # Positions:

Job Code	# Positions
TECH	5
ASST	2
GEN	1
CASH	4

6. Calculate the Budget Amount. Sum the # Positions and the Budget Amount columns in the Totals row; apply the Total cell style to A15:F15.
7. On the Employee Classification worksheet, fix the error in E5 using Trace Precedents changing b to .72 Use Error Checking to locate and correct additional errors.