P $1-9($LO$1\mathrm{.}5)$ Download the file Monthly Sales Dataset.xlsx$.$ Using Excel,...

Download the file Monthly Sales Dataset.xlsx$.$ Using Excel, summarize monthly sales and compute the percent change from one month

to the next. To calculate percent change, calculate $($Current Month Sales $-$ Prior Month Sales$)/$Prior Month Sales. $($This problem may

require a leview of Excel skills, which you will find in Appendix $A$ at the back of this book.$)$

Required:

a$.$ Use a pivot table to sum monthly sales.

What is the total amount of August monthly sales?

What is the total amount of December monthly sales?

b$.$ Modify the value field settings for the pivot table $($as shown in Appendix A$)$ and calculate the percent change from one month as

compared to the previous month.

What is the percentage change in monthly sales from June to July?

What is the percentage change in monthly sales from November to December?

Note: Round your answers to $2$ decimal places.