) Create defined names by selection from the range A4:I30. Verify that the labels in Row 4 are now range names.

In the Name Manager, delete the Account_Type range and the Client range, then change the Account_Manager range name to Advisor. Go to the Sales Call Log worksheet, then in cell C3, use point and click to enter the cell address containing Greg Watsons name. Repeat step 5 to enter the cell address for Mario Trottas name in cell C4 of the Sales Call Log worksheet.

7) Return to the Client Data worksheet and then select the required ranges and set Validation rules: Range Name Validation Rules Error Alert and Message Client_ID Allow Text Length Uncheck Ignore blank Set the text Length equal to 4 Stop Title: 4 digits Message: The entry must contain exactly 4 digits State Allow Text length Uncheck Ignore blank Set the text Lenth equal to 2 Stop Title: State code Message: Use the twoletter state code Phone Allow Text length Uncheck Ignore blank Set the text length equal to 12 Warning Title: Format Message: Include the format xxx-xxx-xxxx Birthdate Allow Date Uncheck Ignore blank Date is less than or equal to 1/1/1995 Warning Title: Invalid Date Message: Enter a date before1/1/1995 8) Go to the Sales Call Log, then set Validation rules for the following ranges: Range Name Validation Rules Error Alert and Message Date Allow Date Uncheck Ignore blank Date is greater than Start date: 1/1/2014 Warning Title: Invalid Date Message: Enter a date after 1/1/2014 Time Allow Time Uncheck Ignore blank Time is greater than 08:00 Time is less then 18:00 Warning Title: Invalid Time Message: Use the 24-hour clock format. 9) Go to the Client Data worksheet and test the validation rules as follows: a. Click cell A18, type 56 and press [Tab], read the error alert, and then type 4589. b. Click cell B18, type Hans Marx, press [Tab], type Gary Marketing, press [Tab], type 87 Watson Road, and then type Phoenix. c. In cell F18, type Arizona, read the error alert, and then type AZ. d. In cell G18, type 85010, in cell H18, type 6025552344, read the error alert, and then type 602-555-2344