I need help with this homework! Here are clearer photos that are more zoomed in as well.

Step Points Possible Instructions Download and open the file named exploring e07 grader al Sales.xlsx, and then save the file as 0.000 exploring e07 grader al Sales LastFirst, replacing LastFirst with your name. On the Sales worksheet, enter a date function in cell C8 to calculate the number of years the first 7.000 representative has worked for your company. Copy the function to the range C9:C20. On the Sales worksheet, enter a nested function in cell J8 of the Bonus column to display the bonus amount. If the employee sold S200,000 or more (cell J2) AND is International (cell l4), he or she earns a 3 5% (cell J4) bonus on his or her total annual sales; otherwise, the representative earns 3% (cell J3) ofhis or 7.000 her total annual sales. Use relative and mixed (or absolute) references correctly in the nested function. Copy the function from range J9:J20 Enter a nested lookup function in cell E4 that uses the cells E2 and E3 to return a specific sales record. For 7.000 example, using the current data, you want the function to return the third quarter sales for Erica. Click the Database tab and enter conditions in the Criteria Range for Domestic sales reps that made 240000 or more in sales. 4.000 Perform an advanced filter based on the criteria range. Set the filter to copy the new data to the range Step Points Possible Instructions Download and open the file named exploring e07 grader al Sales.xlsx, and then save the file as 0.000 exploring e07 grader al Sales LastFirst, replacing LastFirst with your name. On the Sales worksheet, enter a date function in cell C8 to calculate the number of years the first 7.000 representative has worked for your company. Copy the function to the range C9:C20. On the Sales worksheet, enter a nested function in cell J8 of the Bonus column to display the bonus amount. If the employee sold S200,000 or more (cell J2) AND is International (cell l4), he or she earns a 3 5% (cell J4) bonus on his or her total annual sales; otherwise, the representative earns 3% (cell J3) ofhis or 7.000 her total annual sales. Use relative and mixed (or absolute) references correctly in the nested function. Copy the function from range J9:J20 Enter a nested lookup function in cell E4 that uses the cells E2 and E3 to return a specific sales record. For 7.000 example, using the current data, you want the function to return the third quarter sales for Erica. Click the Database tab and enter conditions in the Criteria Range for Domestic sales reps that made 240000 or more in sales. 4.000 Perform an advanced filter based on the criteria range. Set the filter to copy the new data to the range