Question: Conditional Formatting: Determine the average sales (Dollars) for the top 10 states for the selected category. Use Conditional Formatting to highlight sales figures that are

Conditional Formatting: Determine the average sales (Dollars) for the top 10 states for the selected category. Use Conditional Formatting to highlight sales figures that are above the average. Insert a chart into your written summary with the top 10 sales, in descending order to view which state has the highest total sales, and highlight sales figures that are above the average

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock