Exam 77-427 Microsoft Excel 2013 EXPERT 3. Create Advanced Formulas 3.2 Look Up Data with Functions: Data Validation (Drop Down List-Settings)

Data Validation: Settings 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 Timesheet. Select Cell A2. Go to Data ->Data Tools-> Data Validation. Allow: List Source: =Clients   Keep going...   Memo to Self: All equations begin with equals. (=). Clients is the Name of the reference table. Data ->Data Tools-> Data Validation