Microsoft Office Tutorials and References
In Depth Information
Make It Right
Make It Right
Analyze a workbook and correct all errors and/or improve the design.
Tables, Conditional Formatting, and Database Functions
Instructions: Start Excel. Open the workbook Make It Right 5-1 Van Dyl Kitchen Accessories Sales
Rep List and then save the fi le using the fi le name, Van Dyl Kitchen Accessories Sales Rep List
Complete. See the inside back cover of this topic for instructions for downloading the Data Files for
Students, or see your instructor for information on accessing the fi les required for this topic. Correct
the following table, conditional formatting, and database function problems so that the worksheet
appears as shown in Figure 5–74.
Figure 5–74
1. Use the Table Style Options group on the Design tab on the Ribbon to make certain that the table
in the worksheet includes banded rows.
2. The table does not show all of the rows because the Age fi eld is fi ltered. Ensure that all rows in the
table are displayed.
3. The conditional formatting for the % of Quota fi eld uses only four icons in the rule instead of fi ve.
Change the icon style of the rule to use 5 Arrows (Colored).
Search JabSto ::

Custom Search