Please follow the directions provided and save your results in this (Question 4 Data mangement) workbook. Activity 1 2 3 Use the Sales Analysis Worksheet. Import the Bargain's Are Us Men's Clothing Store file PARLUST Sort the the information (data) by salesperson, category, order amount and sales item. Calculate the following stats from the work sheet. Subtotal on order amount by salesperson Show a pivot table and pivot chart based on the following information-salesperson, category, order amount and sales item.

lease follow the directions provided and save your results in this (Question 4 Data mangement) workbook. activity 1 Use the Sales Analysis Worksheet. Import the Bargain's Are Us Men's Clothing Store file 2 Sort the the information (data) by salesperson, category, order amount and sales item. Calculate the following stats from the work sheet. Subtotal on order amount by salesperson 3 Show a pivot table and pivot chart based on the following information-salesperson, category, order amount and sales item