PLEASE HELP WITH TAB $1.$ please give me step by step instructions on excel and add notes as indicated on bottom

Tab $1-$ Apple Sales

Create a Pivot table to find the total sales for each Quarter. $(10$ pts$)$

Create a Pie Chart and a Bar Graph showing sales distribution across Quarters. $(20$ pts$)$

Tab $2-$ ShoesSales

Which country had the highest Sales quantity in $2014?$ Use a Pivot Table to show $2014$

Sales for each country. $(20$ pts$)$

Is there a seasonal pattern in the sales quantity of women's shoes in the United States

stores? Use a Pivot Table and a Line chart to show the monthly sales for female shoes in

the United States stores. $(25$ pts$)$

How is the Sale$\_$Price distributed in Canadian stores? Create a Histogram and interpret

the results. $(25$ pts$)$

Notes:

Include a title, data labels, and a legend.

For the pie chart, include percentage information.

Keep two decimal places.