Explain how to use conditional formatting effectively.
What will be an ideal response?
?• Document the conditional formats you use. If a bold, green font means that a sales number is in the top 10 percent of all sales, include that information in a legend in the worksheet.• Don't clutter data with too much highlighting. Limit highlighting rules to one or two per data set. Highlights are designed to draw attention to points of interest. If you use too many, you will end up highlighting everything-and, therefore, nothing.• Use color sparingly in worksheets with highlights. It is difficult to tell a highlight color from a regular fill color, especially when fill colors are used in every cell.• Consider alternatives to conditional formats. If you want to highlight the top 10 sales regions, it might be more effective to simply sort the data with the best-selling regions at the top of the list.
You might also like to view...
When a sequential file is created, the __________ name is the name that it will be saved with on a computer’s storage medium.
Fill in the blank(s) with correct word
An animation is limited to two style rules defined at the initial and end states.
a. true b. false
What does the /text command option do and why is it important to know?
What will be an ideal response?
Templates that you distribute to others are called ____ templates.
A. workgroup B. shared C. user D. group