Please explain by the steps thanks
Instructions Step Download and file as exploring e07 grader_a1 Sales LastFirst, open the file named exploring eo7 grader a1 Sales.xdsx, and then save the replacing Lasthirst with your name. On the Sales worksheet, enter a date function in cell C8 to calculate the number of years the 2 first representative has worked for your company. Copy the function to the range C9 C20. 7 les worksheet, enter a nested function in cell 18 of the Bonus column to display the al annual sales, oatie and mixed (or l representative earns 3% (cell J3) of his or her total annual sales. Use relative and mixed (or bonus amount. If the employee sold $200,000 or more (cell 32) AND is International (cell 14), he or she earns a 5% (cell J41 bonus on his or absolute) references correctly in the nested function. Copy the function from 38 to the range 19:120 Enter a nested lookup function in cell E4 that uses the cells E2 and E3 to return a specific quarter sales for Erica. Click the Database worksheet tab and enter conditions in the Criteria Range for Domestic 4 sales record. For example, using the current data, you want the function to return the third sales reps that made 240000 or more in sales. Perform an advanced filter based on the criteria range. Set the filter to copy the new data to the range A22:G22. 6 In cell 17, enter a database function to calculate the number of reps meeting the criteria. In cell J8, enter a database function to calculate the highest total sales for records meeting the criteria. In cell 39, enter a database function to calculate the average sales for records meeting the Instructions Step Download and file as exploring e07 grader_a1 Sales LastFirst, open the file named exploring eo7 grader a1 Sales.xdsx, and then save the replacing Lasthirst with your name. On the Sales worksheet, enter a date function in cell C8 to calculate the number of years the 2 first representative has worked for your company. Copy the function to the range C9 C20. 7 les worksheet, enter a nested function in cell 18 of the Bonus column to display the al annual sales, oatie and mixed (or l representative earns 3% (cell J3) of his or her total annual sales. Use relative and mixed (or bonus amount. If the employee sold $200,000 or more (cell 32) AND is International (cell 14), he or she earns a 5% (cell J41 bonus on his or absolute) references correctly in the nested function. Copy the function from 38 to the range 19:120 Enter a nested lookup function in cell E4 that uses the cells E2 and E3 to return a specific quarter sales for Erica. Click the Database worksheet tab and enter conditions in the Criteria Range for Domestic 4 sales record. For example, using the current data, you want the function to return the third sales reps that made 240000 or more in sales. Perform an advanced filter based on the criteria range. Set the filter to copy the new data to the range A22:G22. 6 In cell 17, enter a database function to calculate the number of reps meeting the criteria. In cell J8, enter a database function to calculate the highest total sales for records meeting the criteria. In cell 39, enter a database function to calculate the average sales for records meeting the
