PS10 Data Validation

Data Validation is used in ...

• MS-Excel
• MS-Word
• MS-Powerpoint
• Inkscape

Why is data validation used for?

• (A) to control the type of data entered
• (B) to ensure data entered meets requirements
• Both (A) & (B)
• None of the above

How many Data Validation Types are there?

• 1
• 2
• 3
• 4

Which of the following are Data Validation types?

• Length
• Range
• Type
• All of the above

A user is required to enter "exactly 7 characters for a password". Which data validation check is used?

• Length
• Range
• Type
• All of the above

A user is required to enter "between 5 to 8 characters in a cell". Which data validation check is used?

• Length
• Range
• Type
• All of the above

A user is required to enter "only numbers in a cell for postal code". Which data validation check is used?

• Length
• Range
• Type
• All of the above

Error messages are system defined & �

• computer defined
• internet defined
• network defined
• user defined

Which Tab in MS-Excel is used to access data validation for a cell or cell range?

• Charts
• Data
• Formulas
• Tables

Which of the following data validation settings can be set for a cell range?

• Data Settings
• Input Message
• Error Message
• All of the Above