Modifying a Drop Down Control
Challenge
Exercise
-
Open the sample Excel spreadsheet,
Time Sheet
-
When prompted, SAVE to My Documents
-
Go to My Documents and double click on Time Sheet.xls to open the
spreadsheet. in Microsoft Excel
Try It!
Test the
drop down boxes. Do they work?
Update the
information
Add the
following names to the Accounts reference sheet
-
Denver
-
Houston
-
Seattle
-
Los
Angeles
Change the
properties of each drop down box to show 12 lines.
Change the
graphics
Use one of the
following files to update the corporate logo:
Clock 1,
Clock 2,
Clock 3,
Clock 4,
Computer
|
Level 9: Practice
