BIS 155 Course Great Wisdom / tutorialrank.com BIS 155 Course Great Wisdom / tutorialrank.com | Page 55

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.
A. Select the data range and insert a table.
B. Use Advanced Formatting to set up the following conditional
formatting rules for the field Perc