Microsoft Office Tutorials and References
In Depth Information
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 ﬁ le using the ﬁ 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 ﬁ 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.
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 ﬁ eld is ﬁ ltered. Ensure that all rows in the
table are displayed.
3. The conditional formatting for the % of Quota ﬁ eld uses only four icons in the rule instead of ﬁ ve.
Change the icon style of the rule to use 5 Arrows (Colored).