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.