OCTC Logo
 

Data Validation

The textbook explains this very well, so please read pages 7.02 through 7.10 and perform the steps as instructed in the tutorial.
 
 

Quick Quiz: Using a blank worksheet, type Interest Rate in cell A2.  Then apply data validation to cell B2 so that only values between .01 and .20 can be entered.  Give appropriate titles and messages for the Input Message and Error Alert.  Use the Stop Error Alert.  Save the file as Validation and e-mail it to me. 

 
Go to Range Names. Go back to Using An Input Area.

sloopj@octech.edu