data validation

What is the main purpose of data validation in Excel?

• To delete duplicate entries

• To restrict and control data entry

• To color cells automatically

• To print the spreadsheet

Which of the following is a type of data validation?

• Cell shading

• Text wrapping

• List validation

• Spell check

What happens if invalid data is entered into a validated cell with an error alert set up?

• The program crashes

• Excel gives a warning message

• The data is automatically corrected

• Nothing happens

Which field would be best validated using a number range?

• Student name

• Favorite color

• Age

• School name

What is the correct data validation rule for a column containing UAE landmarks?

• Whole number

• Date format

• Custom formula

• List of values

Why is it important to use data validation in real-life scenarios like school records?

• To make the file look better

• To prevent typing

• To ensure data consistency and accuracy

• To increase file size

Which of the following is NOT a valid reason to use data validation?

• Preventing incorrect data

• Formatting text

• Limiting data range

• Restricting text to predefined values

How do you apply a data validation list using cell references?

• Use a formula

• Select a table

• Reference a cell range that contains the list items

• Copy and paste the list into every cell

In Excel, which option would you select to set up data validation?

• File > Data > Validation

• Home > Format > Validate

• Data > Data Validation

• Insert > Validate

What should be the validation type for a student’s full name column?

• Whole number

• Date

• Decimal

• Text only