Pivot Table Quarter Sales includes your raw data in which you will use to create your Pivot table. Complete your worksheet using the following instructions. 1. Save e05_Exercise5_PivotTable_Student Copy with your last and first name at the end. 2. Create a copy of "1st Quarter Sales," move it to the end, and name it "1st Quarter Sales Table" 3. In "1st Quarter Sales Table," create a table to begin the process of creating the Pivot Table. Ensure that you check mark that your table has headers. 4. Create a Pivot Table in a new worksheet. Move the Pivot table worksheet to the end of the other tabs. 4. Name your Pivot Table worksheet "Pivot Table_Salesperson." 6. Change the number format to be in accounting form with 0 decimal places. 7. Change the Sum of Order Amount to be in descending order in order to view the values from highest to smallest. Salesperson individually. In this case select the top 3 salespersons based on the information provided from the Pivot Table_Salesperson Pivot Table. sales. and show the values as a \% of grandtotal. for each month. To do so ensure month is included in column area, salesperson in row area, and sum of amount in the values ares. months, and delete the slicer box if it still appears. Move the chart to the right of the table on the same worksheet. 14. Choose the "Colorful Palette 2" color to be able to distinguish better between the months. 15. Your file is complete, make sure you have all of the following worksheets with the tabs in the appropriate order as such below: Pivot Table_Salesperson_Month \begin{tabular}{|c|c|c|c|} \hline Salesperson & Region & Account & Order Amount Month \\ \hline Albertson, Kathy & East & 29386 & 925 January \\ \hline Albertson, Kathy & East & 74830 & 875 February \\ \hline Albertson, Kathy & East & 90099 & 500 February \\ \hline Albertson, Kathy & East & 74830 & 350 March \\ \hline Brennan, Michael & West & 82853 & 400 January \\ \hline Brennan, Michael & West & 72949 & 850 January \\ \hline Brennan, Michael & West & 90044 & 1500 January \\ \hline Brennan, Michael & West & 82853 & 550 February \\ \hline Brennan, Michael & West & 72949 & 400 March \\ \hline Davis, William & South & 55223 & 235 February \\ \hline Davis, William & South & 10354 & 850 January \\ \hline Davis, William & South & 50192 & 600 March \\ \hline Davis, William & South & 27589 & 250 January \\ \hline Dumlao, Richard & West & 67275 & 400 January \\ \hline Dumlao, Richard & West & 41828 & 965 February \\ \hline Dumlao, Richard & West & 87543 & 125 March \\ \hline Flores, Tia & South & 97446 & 1500 March \\ \hline Flores, Tia & South & 41400 & 305 January \\ \hline Flores, Tia & South & 30974 & 1350 January \\ \hline Flores, Tia & South & 41400 & 435 February \\ \hline Flores, Tia & South & 30974 & 550 February \\ \hline Flores, Tia & South & 30974 & 425 March \\ \hline Martinez, Peter & West & 72949 & 355 February \\ \hline Martinez, Peter & West & 90044 & 1500 January \\ \hline Martinez, Peter & West & 82853 & 425 January \\ \hline Martinez, Peter & West & 72949 & 700 March \\ \hline Post, Melissa & East & 78532 & 765 January \\ \hline Post, Melissa & East & 78532 & 150 February \\ \hline Post, Melissa & East & 65532 & 425 February \\ \hline Post, Melissa & East & 78532 & 350 March \\ \hline Thompson, Shannon & North & 91987 & 875 January \\ \hline Thompson, Shannon & North & 91041 & 265 January \\ \hline Thompson, Shannon & North & 91987 & 375 February \\ \hline Thompson, Shannon & North & 91041 & 1345 February \\ \hline Thompson, Shannon & North & 91987 & 300 March \\ \hline Walters, Chris & South & 55667 & 225 January \\ \hline Walters, Chris & South & 54393 & 105 January \\ \hline Walters, Chris & South & 40028 & 25 January \\ \hline Walters, Chris & South & 55667 & 155 February \\ \hline Walters, Chris & South & 54393 & 2600 February \\ \hline Walters, Chris & South & 54393 & 225 March \\ \hline Walters, Chris & South & 55667 & 785 March \\ \hline \end{tabular}