Students will work with the Data File EX G-5. Students will use conditional formatting to format cells with negative balances and then sort the table on the color of the cells. They also work with table style options. Students will research how to create a print area with nonadjacent areas on a single page and then create that type of print area.

Estimated completion time: 25 minutes

Solution file: EX G-Associates:

Account Number	Associate	Balance
96634	Kris Lowe	$ 5,000
32577	George Well	$ 10,000
15334	Janet Colby	$ 19,790
98661	Judy Makay	$ 25,000
84287	Joe Wood	$ 345,000
78441	Nancy Allen	$ 600,000
41557	Judy Makay	$ (15,000)
21889	Nancy Allen	$ (10,000)
57741	George Well	$ (10,000)
38997	Janet Colby	$ (5,000)