Right click on the Sales Data sheet tab and select Move or Copy . Create a copy of the current spreadsheet and move it to the end . Name the sheet Sorted Data .
B . In order to sort the data , you must convert them to a data table . Format the data table to look attractive .
C . Sort the data by selling agent ( A to Z ) and then by asking price ( largest to smallest ).
D . Convert the sorted data back into a range , and create a summary report showing the total asking price and total selling price by selling agent
E . Create a column chart that shows the difference by agent between asking price and selling price
Step 4 . Filter the data
A . Create another copy of the original sales data . Rename the sheet Filtered Data .
B . Convert the range to a table , and then filter to show only those properties sold in Miami by agent Carey .
Step 5 . Apply Conditional formatting
You determine that one measure of how well the company " gets your price " is to set a scale . Excellent performance is at or above the asking price . Good performance is between 95 % and 100 %. Below 95 % is average performance . You will create conditional formatting rules to display graphically the performance level for each sale . Make a copy of the original sales data chart . Name the new sheet Conditional Format .