Can someone help me with these questions? I can't figure out the formulas to do calculations.

Each sales rep makes a 20 percent commission on all weekly sales above $1000. If the rep does not have more than $1000 in weekly sales, his/her Commission Wages equals zero. Write an IF function in cell E11 that determines Als (the first sales rep) Commission Wages. After writing the IF Function for cell E11, use the most appropriate method to quickly compute the commissions for the remaining sales reps.

HINT: When the IF functions are entered correctly, Al (the first sales rep makes no commission; Bill (the second sales rep) makes $40.00.

Calculate the Gross Wages for each sales rep. Gross wages include the base wages plus any commission wages earned. Place your answers in the appropriate cells in Column F.

Locate the Assumptions area in the worksheet (starting in cell A29) to view the Federal Tax rate for all the sales reps. Place a formula in cell G11 that uses an absolute cell reference referring to the 28% Federal Tax Rate and calculates the amount of Als Federal Tax. Then use the best method to quickly compute the Federal Tax for the remaining sales reps.

Calculate the Net Pay for each sales rep. For this problem, net pay is the amount of gross wages remaining after the Federal tax has been subtracted. Place your answers in the appropriate cells in Column H.

In cell B35, use the appropriate function to total the weekly sales for the entire group of Stereo sales reps. Repeat this procedure to sum the weekly sales for the sales reps in the remaining three departments and place your answers in the corresponding cells.

In cell C35, use the appropriate function to find the average amount of sales among the sales reps in the Stereo department. Repeat this procedure to determine the average sales figures for the sales reps in the remaining three departments and place your answers in the corresponding cells.

Format all the numbers in the spreadsheet in the comma format (with two decimals). Then format only the numbers in row 11 in the Accounting format.

Use conditional formatting to change the background of the Net Pay cells of all employees who earn more than $400.00 net pay to Green Fill with Dark Green Text.

Delete the blank rows above the Worksheet title.

Locate the shaded Goal Seek Step 14 area in the worksheet (starting in cell A 33). Read through the data in rows 34 and 35 to see that Holly has a salary of $1,234.00, the current Fed Tax % is blank, and there is a formula ( =B35 * C35) in cell D35 to calculate the amount of Fed Tax Holly needs to pay when you set the Tax Rate % in cell C35. Use the goal seeking process to find what the Fed Tax % would be if Holly had to pay $502.00 in Federal Tax.

Correct any spelling or grammar errors (like capitalization) in the worksheet. (All words in the two title lines are spelled correctly.)

Change the name of the worksheet tab to Supplemental Problem (2 points).

Working with the cells in TOTAL SALES BY DEPARTMENT, place the appropriate type of chart, on its own chart sheet that shows the labels and percentages of each departments total sales compared to the 100% total of all for departments sales. Format your table so that information is logical and appropriately proportioned. Name your Chart tab.