Excel Work in detail properly

Question 2 Compare the total salary for each position and status?

Utilizing the data contained in worksheet, Q1_Salary, construct a pivot table that compares the total salary for each position for each player status.

Construct a pivot chart from the pivot table that compares the total salary for each position for each player status.

Add a timeline to the pivot table to filter by date drafted.

Question 3 What is the composition of total salary by position for each team?

Construct a pivot table that calculates the composition of total salary by salary within each team in the worksheet Q3.

Construct a pivot chart to visualize the composition of total salary by position for each team.

Ensure that your pivot table and chart utilize best practices and incorporates techniques to draw the readers attention.

Question 4 Nested IF Statement

ACME Company has a bulk buy purchase that they offer customers. They have found that the discounts are mot effective if applied differently for times of the year.

Between the months of January to the end of June, customers are offered a discount of 10% if the quantity was greater than or equal to 20 and a 5% discount if the quantity is over 10. For the remainder of the months the discounts have been reduced to 8% and 3% respectively. Construct an IF statement in column E that will calculate the discount %? The Total Cost is calculated (Price x Quantity x (1 Discount)