|
Before
You Begin: Rename the Sheet
Double-click the tab. Rename the
sheet: Accounts. 3.
Try This: Create a Drop Down List Go to the
Time Sheet. Select
Cell A2. Go to
Data ->Data Tools-> Data Validation. Allow:
List Source:
=Clients
Memo to Self: All equations
begin with equals. (=). Clients is the Name of the reference table.
Data ->Data Tools-> Data Validation
Exam 77-888: Microsoft Excel Expert
2010
2. Applying Formulas and Functions
2.4. Apply functions in formulas:
Data Validation Settings |
|
| |
