Reference no: EM131776268

Question 1 - Pie Chart

Requirements:

1. Create a pie chart for data in the sheet named "Question 1". The chart should be on the same sheet as the data.
2. Give the chart an appropriate title.
3. The legend should be on the right hand side of the chart.
4. The pie chart should have data labels which should be in precentages.
5. Move the pie chart segment with the highest percentage so that it is separated from the rest of the pie chart.

Question 2 - Formulas& Projections

Requirements: Extend the table in the sheet named "Question 2" and use appropriate formulas to show the following:
1. Total for each quarter, total for each city and overall total
2. Average per quarter for each city and average per city for each quarter
3. Create another table in the same sheet, showing projections for next year, using the following assumptions:
a. Quarter 1 - increase by 5% compared to current quarter 1
b. Quarter 2 - increase by 7% compared to current quarter 2
c. Quarter 3 - increase by 9% compared to current quarter 3
d. Quarter 4 - increase by 10% compared to current quarter 4

Question 3 - Using the IF function

Requirement: use the IF function to enable automatic Grading in the "Grade" column for data in the sheet called "Question 3"

Question 4 - Pivot Tables

Requirements: Using data on sheet called "Question 4",
1. Use Vlookup to automatically fill in the unit price of the products, which is included in the Table 2.
2. Use appropriate formula for total column in Table 1
3. Create a pivot table that looks like the table below (the order of region and product does not matter). Your pivot table should have the appropriate numbers instead of zero's as in the table below:

Salesperson	(All)
Units sold	Region	East	West	Grand Total
Product
Binder	0	0	0	0
Desk	0		0	0
Pen	0	0	0	0
Pen Set	0	0		0
Pencil	0	0	0	0
Grand Total	0	0	0	0

Attachment:- Sales data.xlsx