Can someone complete by deadline

Sort Sales Data Lab 3, Step 3 A. Make a copy of the Sales Data in order to ensure that you have a backup copy of the

original data. Right click on the Sales Data tab and select Move or Copy:

Make sure that you click the Create a Copy checkbox and select Move to End:

Click OK. Rename the new sheet Sort Data. B. Convert the data list range into a table. Select the range of cells that contains the

Sales Data. Click the Insert Tab and select Tables from the Tables Group:

The Create Table dialog box will open. Make sure that the My table has headers checkbox is checked:

Click OK. The data will be converted into a Table and the Table Tools tab will open.

C. Select a Table Style that will make the table data more readable by using the Table Styles group:

D. Sort the data by selling agent and then by asking price. Select a cell that is inside the table. From the Data Tab, select Sort from the Sort and Filter Group:

Set the first Sort Key:

Click the Add Level button to add a secondary Sort Key and then sort by Asking Price:

Click OK. E. Now that the data has been sorted, you can convert it back into a Range. You MUST

convert to range before you can provide a Summary report.

From the Table Tools Design Tab, select the Tools Group and the Convert-to-Range command:

You will be asked if you are sure you want to convert the table to a range. Click Yes. F. Create a summary report showing total asking and total selling price by agent. Select all of the sales data. From the Data Tab, Outline Group, select Subtotal:

In the Subtotal dialog box, you will select the criteria for your subtotal. Each time the Agent name changes, you want the total (sum) of both the Asking and Selling price:

Click OK. Excel provides subtotals:

To make this a bit more readable, remove the fill color by selecting all of the data and choosing No Fill:

Select a fill color to highlight the rows containing subtotal data:

Create a Column Chart to compare Asking vs. Selling Price by agent. Change the Outline Level of your subtotals:

You will now see only the Subtotal Data:

Select the Selling Agent, Asking Price, and Selling Price data. Do NOT include the Grand Total row in your selection. Use the Insert Tab and create a 2-D Clustered Column Chart:

Add a Title and Move the chart to a separate sheet called Ask vs Sell by Agent: