P $1-10($LO$1\mathrm{.}5)$ Download the file Regional Sales Dataser.xIsx. Using Excel,...

Download the file Regional Sales Dataset xlsx$.$ Using Excel, summarize sales by month, by sales region $($regions $1-4),$ and by bot month and region using a pivot table. $($This problem may require a review of Excel skills, which you will find in Appendix $A$ at the of this book$)$

Required:

a$.$ Use a pivot table to sum sales by month.

What are the January monthly sales?

What are the February monthly sales?

b$.$ Use a pivot table to sum sales by region.

What are the total sales for region $2?$

What are the total sales for region $4?$

c$.$ Use a pivot table to sum sales by both month and region. $($Hinthin the pivot table, put month in the rows and region in the co

What are the December sales for region $1?$

What are the April sales for region $4?$