Discuss the below:
Q: a. Filter the list and start the results in cell H6. You are to display sales which were greater than fifty-five units and whose per-unit price was no larger than $3.15 during 2005. Display in the body of the table the total sales for each salesperson.
b. Filter the list and copy to v2 to display those 2012 return were greater than the 2011 return and less than the 2013 return or in the top 20 % of 2014 returns.
Attachment:- Data extraction.rar