Can you please give me step by step instructions along with pictures?

EX16_XL_CHO7_GRADER_CAP_AS - Sales Data 1.4 scription: nt created a spreadsheet that lists names, hire dates, quarterly sales, and total sales for the number of years each representative has worked and each representative's bonus ate a nested lookup function to look up a person's name and particular quarter to identif Next, you will perform advanced database filtering and use summary database function e an amortization table to build a small addition to your office complex. ns: pose of grading the project you are required to perform the following tasks: Download and open the file named exploring e07 grader al Sales.xisy, and then save the file as exploring e07_grader a1 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 representative has worked for your company. Copy the function to the range C9:C20 On the Sales worksheet, enter a nested function in cell 38 of the Bonus column to display the bonus amount. If the employee sold $200,000 or more (cell ?2) AND is International (cell 14), he or she earns a 5% (cell 34) bonus on his or her total annual sales; otherwise, the representative earns 396 (cell J3) of his or her total annual sales. Use relative and mixed (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 sales record. For example, using the current data, you want the function to return the third quarter sales for Erica. Click the Database worksheet tab and enter conditions in the Criteria Range for Domestic 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. In cell J7, 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 19, enter a database function to calculate the average sales for records meeting the criteria