quiz G7-Q3-W7

What is the primary purpose of data validation in Excel?

• To encrypt data

• To ensure data accuracy and consistency

• To delete data

• To format data

Which of the following is NOT a common use case for data validation in Excel?

• Restricting data input to a specific range

• Validating email addresses

• Ensuring data uniqueness

• Formatting cell borders

What is a drop-down list created through data validation called in Excel?

• Data sheet

• Validation menu

• Data validation list

• Drop-down menu

When a user enters invalid data, what can Excel do to provide guidance?

• Display a warning message

• Automatically correct the data

• Delete the invalid data

• Freeze the spreadsheet

What happens when a user tries to enter data that doesn't meet the data validation criteria?

• The data is automatically corrected

• A warning message appears

• The data is deleted

• Excel crashes

Which of the following are Data Validation types?

• Length
• Range
• Type
• All of the above

A table can have blank columns and rows in it, if they are selected when the table is created.

• TRUE

• FALSE

Which conditional formatting feature can be used to identify duplicate values on a worksheet?

• Data Bars

• Highlight Cell Rules

• Top / Bottom Rules

• Color Scales

What is this icon?

• Sum

• AutoSum

• Insert Function

• Object

The best data type to choose for date of birth would be

• Number

• Date/Time

• Text

• Currency