need help with a easy excel assignment

Are you pressed for time and haven’t started working on your assignment yet? Would you like to buy an assignment? Use our custom writing services for better grades. Even if your deadline is approaching fast, our writers can handle your task right when you need it. Our writers will complete your order from scratch and make sure it’s completely unique.


Order a Similar Paper Order a Different Paper

For NFL Team and Analysis tab:

1.Create a formula (IF) to revise the value of each team based on the number of wins they recorded. Increase the value of any team that recorded 10 or more wins by $20 million and decrease the value of any team that won 9 games or fewer by 10%, The revised worth of each team should appear in column E. (10 points)

2.Calculate the Average and Median values for the Revised values of the worth of all teams (average and median of column E) (3 points each).

For Sales Data tab:

1.Create a lookup formula in column G that will populate the warehouse number from tab Warehouse Addresses in column G (hint, the identifier is the Customer name). (10 points)

2.Create a Pivot table on all the data in the Sales Data tab

3.Answer the following questions (5 points each)

a.What is the customer with the highest purchase amount?

b.What Product sells best (by count)?

c.What is the preferred Payment Type (by count)?

d.Which Warehouse is responsible for the most dollar amount sales?

4.Create a PIE chart (either from a pivot table, or directly a pivot chart) showing the customers (customer name) and the slice of the total (sum) of the amount purchased by each individual customer. Name the chart Percentage of Sales, and make sure the chart is showing percentages on each of the slices of the Pie. Make sure that the names of the customers appear in the legend (labels). Move the chart to its own worksheet and name the worksheet SalesChart. No missing data should be shown on the chart. (20 points)

Attached document is the excel file for you to work.

Writerbay.net

Do you need help with this or a different assignment? Even when your task is complicated and the deadline is in less than 2 days, you still have every chance to get a good grade for it. How? By completing the order form, you will get the finest custom-written assignment at an affordable price. We also deliver a number of services for free (e.g., revisions, editing, checking the text for authenticity). Use our paper writing service to receive effective help with your homework.


Order a Similar Paper Order a Different Paper