Exam 77-427 Microsoft Excel 2013 EXPERT 3. Create Advanced Formulas 3.2 Look Up Data with Functions: Data Validation (Clear All)

Still Before You Begin The spreadsheet that we just copied has cells formatted with Data Validation. Here are the steps to remove those settings.   2. Try it: Change the Validation Criteria Go to Timesheet (2). Select Cells A2:A12. Go to Data ->Data Tools-> Data Validation. Click on Clear All.   Click OK. Keep going... Data ->Data Tools-> Data Validation