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

Exam 77-888: Microsoft Excel Expert 2010

2. Applying Formulas and Functions

2.4. Apply functions in formulas: Data Validation