I need help getting started with this excel homework! The first few questions are really confusing so if anyone can walk me through it step by step that'd be great. :)

a Ex16bacHo7GRADERCAPAS Sales Data 11 Instructions (Compatibility Model Ex16 CH07 GRADER CAP AS Sales Data 1.1 Project Description: Your assistant aeated a spreadsheet that Mests names sales and total sales for In addition, wil alaulate the number of years each representative has worked and each bonus. the sales for you wil aeate function a persons name and particular quarter to identify that person. Next, perform advanced database fitering and use summary database fundtions. Finaly, you wil oomplete an amortization table to build a smal addition to your office complex. For the purpose of grading the project you are required to perform the following tasks: Download and open the file named exploring eoz grader al salesxtsx, and then save the 0.000 fie as exploring eo7 grader ai 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. 7.000 On the Sales Worksheet, enter a nested nction in cell of the Bonus column to display the bonus If the employee sold s200,000 or more (cell J2)AND is International (cel 4, he or she earns a 5% (cell J4) bonus on his or her total annual sales; otherwise, the 7.000 representative earns 3% (cel J3) of his or her total annual sales. Use relative and mixed (or absolute) references correctly in the nested function. Copy the function from JB to the range 9:120. Enter a nested lookup function in cell E4 that uses the cells E2 and E3 to return a specific 4 sales record. For example, using the current data, you want the function to return the third 7.000 quarter sales for Erica. aick the Database worksheet tab and enter conditions in the Criteria Range for Domestic 4.000 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. Use 7 the output range A22:G35 for the database argument in the function. a Ex16bacHo7GRADERCAPAS Sales Data 11 Instructions (Compatibility Model Ex16 CH07 GRADER CAP AS Sales Data 1.1 Project Description: Your assistant aeated a spreadsheet that Mests names sales and total sales for In addition, wil alaulate the number of years each representative has worked and each bonus. the sales for you wil aeate function a persons name and particular quarter to identify that person. Next, perform advanced database fitering and use summary database fundtions. Finaly, you wil oomplete an amortization table to build a smal addition to your office complex. For the purpose of grading the project you are required to perform the following tasks: Download and open the file named exploring eoz grader al salesxtsx, and then save the 0.000 fie as exploring eo7 grader ai 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. 7.000 On the Sales Worksheet, enter a nested nction in cell of the Bonus column to display the bonus If the employee sold s200,000 or more (cell J2)AND is International (cel 4, he or she earns a 5% (cell J4) bonus on his or her total annual sales; otherwise, the 7.000 representative earns 3% (cel J3) of his or her total annual sales. Use relative and mixed (or absolute) references correctly in the nested function. Copy the function from JB to the range 9:120. Enter a nested lookup function in cell E4 that uses the cells E2 and E3 to return a specific 4 sales record. For example, using the current data, you want the function to return the third 7.000 quarter sales for Erica. aick the Database worksheet tab and enter conditions in the Criteria Range for Domestic 4.000 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. Use 7 the output range A22:G35 for the database argument in the function