We Helped With This Excel Programming Assignment: Have A Similar One?

Problem 3 (12 points)

Using the Problem3.xlsx dataset, answer the following questions using the worksheets found in the workbook (Q1 for question a, Q2 for question b, etc.)

a.      (3 points)  Filter the list in place to display those funds who were in the top 12% of returns in 2018.

b.      (3 points)  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.10 during 2005.

c.       (3 points)  Using subtotals, display in the body of the table the total sales for each person.

d.      (4 points)  Filter the list and starting in cell V2 display those 2014 return were less than the 2018 return or in the top 15 % of 2018 returns.

Save your workbook as Part 1 Problem3.xlsx.