I need help with an Excel Spreadsheet (Its attached)

I have attached instructions for this and then seperately I attached the Excel worksheet that the work needs to be done on and saved and sent back to me.

Instructions for Assignment.

I have attached the Commission Worksheet with all of the info that needs to be in there, you just need to complete this assignment with correct formula-follow instructions below.

Notice that cell B2 contains a sales commission rate. Each salesperson receives a commission equal to his or her total sales multiplied by the commission rate. the commission rate changes periodically. The worksheet is set up so that if the sales manager changes the rate in Cell B2, all the sales commissions will be recalculated.

1. Create a formula in cell B10 to calculate the sales commission for column B by multiplying the Total Sales in cell B9 by the commission Rate in cell B2. (Hint: you must use an absolute reference for the Commission Rate in the formula.)

2. Copy the formula from cell B10 to cells C10 through E10.

3. Check the results of the copied formulas to make sure that they show the correct results. If cells C10 through E10 contain zeros, you did not use the correct absolute reference for the formula that you entered in Step 5. If necessary, modify the formula in B10, then recopy it to cells C10 through E10.

4. Change the contents of cell B2 to 0.03.

5. Enter your name in cell B4. (My name is Amanda)

Then Save and send to me.

Sheet1

$ 500.00 $ 501.00 $ 502.00 $ 503.00

Commission Worksheet
Commission Rate:	0.02
Salesperson	Renfrew, Steven	Anderson, Jane	Cole, Michael	James, Ron
Week 1	$ 14,283.00	$ 11,020.00	$ 13,477.00	$ 12,405.00
Week 2	$ 17,808.00	$ 12,381.00	$ 1,100.00	$ 12,889.00
Week 3	$ 12,302.00	$ 14,830.00	$ 13,747.00	$ 14,700.00
Week 4	$ 13,100.00	$ 19,787.00	$ 18,483.00	$ 15,806.00
Total Sales	$ 57,493.00	$ 58,018.00	$ 46,807.00	$ 55,800.00
Sales Commission
Base Salary		$ 500.00		$ 501.00		$ 502.00		$ 503.00
Salary Plus Commission