Field check – that values in a cell are only numeric

The ISNUMBER function tests whether the cell contains only numeric data.

5. 
   Size check – that cell accepts no more than 40 characters of text
   

6. 
   Reasonableness check – that cell’s value is less than 75% of cell to its left
   

7. 
   Validity check – that a value exists in a list of allowable values
   
8. 
   
   
9. 
   
   
10. 
    
    
11. 
    If the preceding data validation rule was applied to cell C7, the spreadsheet would look like this:
    
12. 
    
    
13. 
    
    
14. 
    
    
15. 
    And clicking the drop-down arrow would display the following:
    
16. 
    
    
17. 
    
    
18. 
    
    Directory: ntsbagga -> web -> 300 sp11 web
    300 sp11 web -> Control and accounting information systems suggested answers to discussion questions
    300 sp11 web -> -
    300 sp11 web -> Relational databases suggested answers to discussion questions
    300 sp11 web -> Suggested answers to discussion questions
    300 sp11 web -> Bio & preliminary assessment inss 300 (Spring 2011—web)
    300 sp11 web -> Post assessment inss (Spring 2011W) Name (print)
    300 sp11 web -> Auditing computer-based information systems suggested answers to discussion questions
    300 sp11 web -> Computer fraud suggested answers to discussion questions
    300 sp11 web -> Computer fraud and abuse techniques suggested answers to discussion questions
    300 sp11 web -> Suggested answers to discussion questions
    
    
    
    Download 1.18 Mb.
    
    Share with your friends: