Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I have already submitted this question. I recieved instructions that are not very explicit. I am confused. Can some one please explain in deeper detail.
I have already submitted this question. I recieved instructions that are not very explicit. I am confused. Can some one please explain in deeper detail. The first 4 questions for this that were included in what was sent to me were not answered. Please help!
EX16 XL CH07_GRADER CAP AS- Sales Data 1.4 t Description: sistant created a spreadsheet that lists names, hire dates, quarterly sales, and total sales for nkte the nurnter of years each representative has worked and each representative's bonus. create a nested lookup function to look up a person's name and particular quarter to identify son. Next you will perfom advanced database filtering and use summary database functions plete an amortization table to build a small addition to your office complex ctions: purpose of grading the project you are required to perform the following tasks: Instructions Download and open the file named exploring eo7 grader al Sales.xdsx, 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 C 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 J2) 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 3% (cell 13) of his or her total annual sales. Use relative and mixed (or absolute) references correctly in the nested function. Copy the function from J8 to the range 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. enter a database function to calculate the highest total sales for records meeting In cell 38, the criteria enter a database function to calculate the average sales for records meeting the In cell 39, criteria. EX16 XL CH07_GRADER CAP AS- Sales Data 1.4 t Description: sistant created a spreadsheet that lists names, hire dates, quarterly sales, and total sales for nkte the nurnter of years each representative has worked and each representative's bonus. create a nested lookup function to look up a person's name and particular quarter to identify son. Next you will perfom advanced database filtering and use summary database functions plete an amortization table to build a small addition to your office complex ctions: purpose of grading the project you are required to perform the following tasks: Instructions Download and open the file named exploring eo7 grader al Sales.xdsx, 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 C 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 J2) 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 3% (cell 13) of his or her total annual sales. Use relative and mixed (or absolute) references correctly in the nested function. Copy the function from J8 to the range 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. enter a database function to calculate the highest total sales for records meeting In cell 38, the criteria enter a database function to calculate the average sales for records meeting the In cell 39, criteriaStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started